Lecture 2

Question 1

An abstraction of a real-world object or event used to understand complexities of the real-world environment.

Answer 1

Model

Question 2

A data modeling technique used in software engineering to produce a conceptual data model of an information system, illustrating the logical structure of databases.

Answer 2

Entity Relationship Diagram (ERD)

Question 3

The number of occurrences in one entity associated with the number of occurrences in another, classified as one-to-one (1:1), one-to-many (1:M), and many-to-many (M:N).

Answer 3

Cardinality

Question 4

Attributes that uniquely identify entity instances, often becoming primary keys in Relational Database Systems (RDS).

Answer 4

Identifier

Question 5

Also known as IE notation, Represented by a rectangle, with its name on the top. The name is singular (entity) rather than plural (entities).

Answer 5

Crow’s Foot Notation

Question 6

A policy, procedure, or principle used to define entities, attributes, relationships, and constraints in a database system

Answer 6

Business Rule

Question 7

An attribute that cannot be subdivided, representing atomic values such as Age, Gender, and Marital status.

Answer 7

Simple attribute

Question 8

An attribute that can be further subdivided to yield additional attributes, such as Address (subdivided into Street, City, State, Zip).

Answer 8

Composite attribute

Question 9

An attribute not physically stored within the database but derived using an algorithm or calculation.

Answer 9

Derived attribute

Question 10

An attribute that can have only a single atomic value, such as a social security number or a serial number

Answer 10

Single-valued attribute

Question 11

An attribute that can have multiple values, such as multiple college degrees for a person or multiple phone numbers for a household

Answer 11

Multi-valued attribute

Question 12

A diagram that displays a set of tables and the relationships between them

Answer 12

Data model