Chapter 3 – Data Modeling Using the ER Model ( Flashcards )

Group 1,2 – Chapter 3: ER Model

Rifal Abdulrahman Al-Yamani – 44713669 – Section 1

Jana Gazi Al-Ahmadi – 44710680 – Section 1

Jana – 44712799 – Section 1

Rose Bandar Alharthi – 44711323 – Section 2

What are the two main activities of the database design process?

a) Conceptual design and physical design

b) Database design and applications design

c) Requirements analysis and testing

d) Logical design and data mapping

b) Database design and applications design

In database design, what does applications design focus on?

The programs and interfaces that access the database.

What is the first phase of the database design process?

a) Conceptual design

b) Logical design

c) Requirements collection and analysis

d) Physical design

c) Requirements collection and analysis

True or False: The conceptual design phase produces the internal schema.

False. Conceptual design produces the conceptual schema. The internal schema is produced by physical design.

In the database design process, what is another name for the logical design phase?

a) Functional analysis

b) Data model mapping

c) Physical design

d) Requirements analysis

b) Data model mapping

True or False: Conceptual design depends on a specific DBMS.

False. Conceptual design is DBMS-independent.

What is an entity in the Entity-Relationship (ER) model?

A specific thing or object in the mini-world that is represented in the database.

In the ER model, what are attributes?

Properties used to describe an entity.

Which of the following is an example of a simple attribute?

a) Address(Street, City, ZipCode)

b) Name(FirstName, MiddleName, LastName)

c) SSN

d) {Color}

c) SSN

What is a composite attribute in the ER model? Give an example.

An attribute made of several components, e.g., Name(FirstName, MiddleName, LastName).

True or False: A multi-valued attribute can have multiple values for one entity and is written in curly braces, e.g., {Color}.

True.

In the ER model, what type of attribute is {PreviousDegrees(College, Year, Degree, Field)}?

a) Simple attribute

b) Composite attribute only

c) Multi-valued attribute only

d) Composite multi-valued attribute

d) Composite multi-valued attribute

What is an entity type in the ER model?

A group of entities that share the same basic attributes, e.g., EMPLOYEE.

In the ER model, which attribute must have a unique value for each entity?

a) Composite attribute

b) Key attribute

c) Multi-valued attribute

d) Simple attribute

b) Key attribute, e.g., SSN of an employee.

True or False: An entity type can have only one key.

False. An entity type can have more than one key, e.g., CAR has VIN and VehicleTagNumber(Number, State).

True or False: In an ER diagram, key attributes are underlined.

True.

In an ER diagram, how are multi-valued attributes displayed?

a) Rectangles

b) Ovals

c) Double ovals

d) Double rectangles

c) Double ovals