NEW
Font size
WorksheetsDatabase Design Process Quiz
Total questions: 15
Worksheet time: 5mins
What are the functional requirements in database design?
User-defined operations.
Data storage methods.
Database security measures.
What is a conceptual schema?
A concise description of data requirements.
A detailed implementation plan.
A method for data storage.
What does logical design refer to in database design?
The actual implementation of the database.
The conceptual schema.
The requirements analysis.
What are weak entity types?
Entity types without key attributes.
Entities that are always strong.
Entities that have multiple attributes.
What is an identifying relationship?
The relationship between weak and strong entity types.
A relationship that does not involve entities.
A relationship that is always one-to-one.
What is a key attribute?
An attribute that helps identify an entity uniquely.
An attribute that can have multiple values.
An attribute that is derived from another.
What is a multivalued attribute?
An attribute that contains a set of values.
An attribute that can be divided into further attributes.
An attribute that is derived from another.
What is a composite attribute?
An attribute that can be divided into further attributes.
An attribute that contains multiple values.
An attribute that is derived from another.
What is a derived attribute?
An attribute whose value is derived from another.
An attribute that is always unique.
An attribute that cannot be divided.
What is a primary key?
An attribute that uniquely identifies a record in a table.
An attribute that can be null.
An attribute that is used for indexing.
What is a foreign key?
An attribute that creates a link between two tables.
An attribute that is always unique.
An attribute that cannot be changed.
it is a thing or an object that has existence and it is represented by a rectangle
Key Attribute
Entity
Weak Entity
Attribute
It is the property to describe an entity and it's represented by an oval.
Attribute
Entity
Key Attribute
Weak Attribute
It helps in identifying an entity uniquely is represented by an oval with the underline.
Entity
Attribute
Key Attribute
Entity
Type of entity that do not have key attributes of their own represented by double rectangle
Weak Entity
Entity
Attribute
Key Attribute
