ER model

Consider the following ER diagram. The minimum number of tables needed to represent M, N, P, R1, R2 is:

• 2

• 3

• 4

• 5

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

• Weak entity

• Strong entity

• ID-dependent entity

• ID- independent entity

Properties that describe the characteristics of entities are called:

• entities.

• attributes.

• identifiers.

• relationships.

Entities can be associated with one another in which of the following?

• Entities

• Attributes

• Identifiers

• Relationships

What is an Entity? 

• Person or place.
• Association between the instances 
• Named Property or characteristic
• Person, Place, Object, event or concept about which the data is to be maintained

What is an Attribute?

• Person, Place, Object, event or concept about which the data is to be maintained
• Association between the instances 
• Named Property or characteristic
• The next important link

Which of these is  an example of an Attribute for Student

• Student_ID
• Doors
• Model

Which would NOT likely be an attribute of an entity called “Student”?

• Age

• Student identification number

• Class room number

• Home phone

• Gender

WHICH OF THE FOLLOWING IS NOT AN ATTRIBUTE TYPE

• Simple

• Multivalued

• cardinality

• composite

"Address" of an employee entity is a ___________ attribute

• composite

• single

• simple

• derived