Q. In an ER diagram, how is a multi-valued attribute represented?
A.
As a rectangle
B.
As an oval
C.
As a double oval
D.
As a diamond
Show solution
Solution
A multi-valued attribute is represented as a double oval in an ER diagram.
Correct Answer:
C
— As a double oval
Learn More →
Q. In an ER diagram, how is a primary key typically represented?
A.
Underlined text
B.
Bold text
C.
Italicized text
D.
In a different color
Show solution
Solution
A primary key is typically represented by underlined text in an ER diagram.
Correct Answer:
A
— Underlined text
Learn More →
Q. In an ER model, what does a circle represent?
A.
An entity
B.
An attribute
C.
A relationship
D.
A weak entity
Show solution
Solution
A circle in an ER model represents an attribute of an entity.
Correct Answer:
B
— An attribute
Learn More →
Q. In an ER model, what does a solid line represent?
A.
A weak relationship
B.
A strong relationship
C.
An attribute
D.
A derived attribute
Show solution
Solution
A solid line in an ER model represents a strong relationship between entities.
Correct Answer:
B
— A strong relationship
Learn More →
Q. In an ER model, what is an attribute?
A.
A relationship between entities
B.
A property or characteristic of an entity
C.
A unique identifier for an entity
D.
A type of database operation
Show solution
Solution
An attribute is a property or characteristic that describes an entity in an ER model.
Correct Answer:
B
— A property or characteristic of an entity
Learn More →
Q. What does a crow's foot notation indicate in an ER diagram?
A.
One-to-one relationship
B.
One-to-many relationship
C.
Many-to-many relationship
D.
No relationship
Show solution
Solution
A crow's foot notation indicates a one-to-many relationship in an ER diagram.
Correct Answer:
B
— One-to-many relationship
Learn More →
Q. What does a primary key do in an ER model?
A.
Links two entities
B.
Identifies a unique record
C.
Defines a relationship type
D.
Stores multiple values
Show solution
Solution
A primary key uniquely identifies a record in a database table.
Correct Answer:
B
— Identifies a unique record
Learn More →
Q. What does a primary key in an ER model signify?
A.
A unique identifier for an entity
B.
A foreign key reference
C.
An attribute that can be null
D.
A relationship type
Show solution
Solution
A primary key signifies a unique identifier for an entity in an ER model.
Correct Answer:
A
— A unique identifier for an entity
Learn More →
Q. What does a solid line represent in an ER diagram?
A.
A weak relationship
B.
A strong relationship
C.
An attribute
D.
An entity
Show solution
Solution
A solid line in an ER diagram represents a strong relationship between entities.
Correct Answer:
B
— A strong relationship
Learn More →
Q. What does an entity represent in an ER model?
A.
A relationship between two tables
B.
A real-world object or concept
C.
A specific attribute of a table
D.
A constraint on data
Show solution
Solution
An entity represents a real-world object or concept in an ER model.
Correct Answer:
B
— A real-world object or concept
Learn More →
Q. What is a primary key in the context of an ER model?
A.
A key that allows for data redundancy
B.
A unique identifier for each entity instance
C.
A foreign key that links to another table
D.
A type of relationship between entities
Show solution
Solution
A primary key is a unique identifier for each instance of an entity, ensuring that no two instances are the same.
Correct Answer:
B
— A unique identifier for each entity instance
Learn More →
Q. What is an attribute in an ER model?
A.
A relationship between entities
B.
A property or characteristic of an entity
C.
A unique identifier for a relationship
D.
A type of entity
Show solution
Solution
An attribute is a property or characteristic of an entity in an ER model.
Correct Answer:
B
— A property or characteristic of an entity
Learn More →
Q. What is the main advantage of using an ER model?
A.
It is easy to implement in SQL
B.
It provides a clear visual representation of data
C.
It eliminates the need for normalization
D.
It allows for complex queries
Show solution
Solution
The main advantage of using an ER model is that it provides a clear visual representation of data and relationships.
Correct Answer:
B
— It provides a clear visual representation of data
Learn More →
Q. What is the main purpose of an ER model?
A.
To define SQL queries
B.
To visualize database structure
C.
To manage transactions
D.
To optimize indexing
Show solution
Solution
The main purpose of an ER model is to visualize the structure of a database, including entities, attributes, and relationships.
Correct Answer:
B
— To visualize database structure
Learn More →
Q. What is the primary key in an ER model?
A.
A unique identifier for an entity
B.
A foreign key in another table
C.
An attribute that can be null
D.
A composite of multiple attributes
Show solution
Solution
The primary key is a unique identifier for an entity in an ER model.
Correct Answer:
A
— A unique identifier for an entity
Learn More →
Q. What is the purpose of an associative entity in an ER model?
A.
To represent a many-to-many relationship
B.
To store attributes of a relationship
C.
To simplify complex relationships
D.
All of the above
Show solution
Solution
An associative entity is used to represent a many-to-many relationship and can store attributes of that relationship.
Correct Answer:
D
— All of the above
Learn More →
Q. What is the purpose of an ER diagram?
A.
To define SQL queries
B.
To visualize the database structure
C.
To enforce data integrity
D.
To optimize database performance
Show solution
Solution
An ER diagram is used to visualize the database structure and relationships between entities.
Correct Answer:
B
— To visualize the database structure
Learn More →
Q. What is the purpose of an ER model?
A.
To define the physical storage of data
B.
To provide a visual representation of data relationships
C.
To enforce data integrity constraints
D.
To optimize query performance
Show solution
Solution
The purpose of an ER model is to provide a visual representation of data relationships.
Correct Answer:
B
— To provide a visual representation of data relationships
Learn More →
Q. What is the purpose of normalization in database design?
A.
To increase redundancy
B.
To eliminate data anomalies
C.
To simplify the ER diagram
D.
To enhance query performance
Show solution
Solution
Normalization is used to eliminate data anomalies and reduce redundancy in database design.
Correct Answer:
B
— To eliminate data anomalies
Learn More →
Q. What is the role of attributes in an ER model?
A.
To define relationships
B.
To provide additional information about entities
C.
To serve as primary keys
D.
To represent constraints
Show solution
Solution
Attributes provide additional information about entities in an ER model.
Correct Answer:
B
— To provide additional information about entities
Learn More →
Q. Which of the following best describes a many-to-many relationship?
A.
One entity can relate to many instances of another entity
B.
One entity can relate to only one instance of another entity
C.
Many instances of one entity can relate to many instances of another entity
D.
No relationship exists between the entities
Show solution
Solution
A many-to-many relationship allows many instances of one entity to relate to many instances of another entity.
Correct Answer:
C
— Many instances of one entity can relate to many instances of another entity
Learn More →
Q. Which of the following is a characteristic of a weak entity?
A.
It can exist independently of other entities
B.
It has a primary key of its own
C.
It relies on a strong entity for its identification
D.
It cannot have attributes
Show solution
Solution
A weak entity relies on a strong entity for its identification and does not have a primary key of its own.
Correct Answer:
C
— It relies on a strong entity for its identification
Learn More →
Q. Which of the following is an example of a weak entity?
A.
A customer with a unique ID
B.
An order that depends on a customer
C.
A product with a SKU
D.
A department with a manager
Show solution
Solution
An order that depends on a customer is an example of a weak entity, as it cannot exist without the customer.
Correct Answer:
B
— An order that depends on a customer
Learn More →
Q. Which of the following is NOT a type of relationship in an ER model?
A.
One-to-One
B.
One-to-Many
C.
Many-to-Many
D.
Many-to-One
Show solution
Solution
All listed options are types of relationships in an ER model; however, 'Many-to-One' is typically described as 'One-to-Many' from the other entity's perspective.
Correct Answer:
D
— Many-to-One
Learn More →
Showing 1 to 24 of 24 (1 Pages)
