DBMS Day 3

Which of the following gives a logical structure of the database graphically?

• Entity-relationship diagram

• Entity diagram

• Database diagram

• Architectural representation

The entity relationship set is represented in E-R diagram as

• Double diamonds

• Undivided rectangles

• Dashed lines

• Diamond

The Rectangles divided into two parts represents

• Entity set

• Relationship set

• Attributes of a relationship set

• Primary Key

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality

• One to One

• One to Many

• Many to one

• Many to Many

We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________

• Diamond , diamond

• Rectangle, diamond

• Rectangle, rectangle

• Diamond, rectangle

An entity set that does not have sufficient attributes to form a primary key is termed a __________

• Strong entity set

• Variant set

• Weak entity set

• Variable set

For a weak entity set to be meaningful, it must be associated with another entity set, called the

• Identifying set

• Owner set

• Neighbour set

• Strong entity set

Weak entity set is represented as

• Underline

• Double line

• Double diamond

• Double rectangle

If you were collecting and storing information about your music collection, an album would be considered a(n) _____

• Relation

• Entity

• Instance

• Attribute

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

• Relation

• Instance

• Table

• Column