Font size
WorksheetssdAsaDJQj213j(DBMS)
Total questions: 40
Worksheet time: 23mins
Which relationship type is considered the norm in a relational database?
1:1
1:M
M:N
Recursive
How should an M:N relationship be implemented in a relational database?
As a single table
By creating a composite/bridge entity to form two 1:M relationships
By using a recursive foreign key
It cannot be implemented
What is a composite entity also known as?
Weak entity
Bridge entity
Derived entity
Recursive entity
In Crow’s Foot notation, what does a dashed line typically indicate?
Mandatory participation
Optional participation
One-to-many relationship
Many-to-many relationship
Which relationship degree involves three entities?
Unary
Binary
Ternary
Quaternary
A relationship where an entity is related to itself is called:
Binary
Ternary
Recursive/Unary
Quaternary
Which of the following is an example of a weak entity?
Student
Invoice
Dependent (of an Employee)
Product
A derived attribute is:
Stored in multiple tables
Calculated from other attributes
Always part of the primary key
A multivalued attribute
Which attribute type can be subdivided into smaller parts?
Simple attribute
Composite attribute
Derived attribute
Single-valued attribute
What does cardinality describe in a relationship?
The type of relationship (1:1, 1:M, M:N)
The minimum and maximum number of entity occurrences
Whether participation is optional or mandatory
The degree of the relationship
In Chen’s ER model, attributes are represented as:
Rectangles
Ovals
Diamonds
Lines
A composite primary key is:
A primary key made of multiple attributes
A foreign key that references multiple tables
A derived attribute used as a key
A key that is always NULL
Which of the following is a multivalued attribute?
Age
Employee ID
Phone numbers (home, mobile, work)
Birthdate
What is optional participation in a relationship?
An entity must be related to another entity
An entity may or may not be related to another entity
The relationship is recursive
The relationship is ternary
A ternary relationship involves how many entities?
1
2
3
4
Which of the following is used to resolve a multivalued attribute?
Create a separate table for the attribute
Ignore the attribute
Store it as a composite attribute
Make it a derived attribute
What does connectivity refer to in ER modeling?
The type of relationship (1:1, 1:M, M:N)
The number of entities in a relationship
Whether participation is optional
The strength of the relationship
A foreign key is used to:
Uniquely identify a row
Link tables by matching a primary key in another table
Store derived data
Resolve M:N relationships directly
Which notation uses crow’s foot symbols to represent relationships?
Chen’s model
Relational model
Crow’s Foot model
Hierarchical model
A bridge entity is created to resolve which type of relationship?
1:1
1:M
M:N
Recursive
True/False: A 1:1 relationship is common in well-designed relational databases.
True
False
True/False: In Crow’s Foot notation, a solid line indicates optional participation.
True
False
True/False: A weak entity can exist independently of its parent entity.
True
False
True/False: A derived attribute should be stored physically in the database.
True
False
True/False: A composite key can be used as a primary key.
True
False
True/False: A unary relationship involves two different entities.
True
False
True/False: In a 1:M relationship, the foreign key is placed in the “many” side table.
True
False
True/False: A quaternary relationship involves four entities.
True
False
True/False: Multivalued attributes are allowed in normalized relational tables.
True
False
True/False: Business rules help determine cardinality and connectivity in ERDs.
True
False
Match the term with its definition: Composite Attribute
An attribute that can be broken down into smaller parts
An entity that depends on another entity for its existence
A key that links two tables by matching a primary key
A relationship where an entity is related to itself
A relationship involving three entities
Match the term with its definition: Weak Entity
An attribute that can be broken down into smaller parts
An entity that depends on another entity for its existence
A key that links two tables by matching a primary key
A relationship where an entity is related to itself
A relationship involving three entities
Match the term with its definition: Foreign Key
An attribute that can be broken down into smaller parts
An entity that depends on another entity for its existence
A key that links two tables by matching a primary key
A relationship where an entity is related to itself
A relationship involving three entities
Match the term with its definition: Recursive Relationship
An attribute that can be broken down into smaller parts
An entity that depends on another entity for its existence
A key that links two tables by matching a primary key
A relationship where an entity is related to itself
A relationship involving three entities
Match the term with its definition: Ternary Relationship
An attribute that can be broken down into smaller parts
An entity that depends on another entity for its existence
A key that links two tables by matching a primary key
A relationship where an entity is related to itself
A relationship involving three entities
The (a) relationship is the most common in relational databases.
An M:N relationship is resolved by creating a __________ entity.
(a) participation means an entity must be related to another entity.
A (a) attribute is one that can have multiple values for a single entity.
The (a) model represents attributes as ovals connected to entities.
