What is the role of a column in a database table?
To define a row in the table.
To link the table to another table.
To represent a specific attribute or characteristic of an entity.
To store the entire dataset of the table.
Why is data redundancy undesirable in a database?
It can lead to data inconsistencies and anomalies
It complicates data retrieval and manipulation
It increases storage space requirements
All of the above
How is a one-to-many relationship represented in an ER diagram?
A single line connecting two entities
Two lines connecting two entities
A diamond connecting two entities
A line with a crow's foot symbol on one end and a single line on the other
What is the primary benefit of using cascading actions in database design?
Improved query performance
Reduced storage space
Simplified data manipulation
Enhanced security
Which of the following relationships is typically NOT implemented directly in a database but is often represented using an intermediary table?
One-to-Many
Many-to-Many
One-to-One
What element in an ER diagram describes the properties or characteristics of an entity?
Cardinality
Entity
Attribute
Relationship
Which of these is crucial to consider when choosing data types for columns?
The type of storage device used by the database server.
The kind of data the column will store and its expected size.
The color scheme of the user interface.
The username of the person creating the table.
You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?
Third Normal Form (3NF)
Second Normal Form (2NF)
First Normal Form (1NF)
None of the above
What is the role of cardinality in an ER diagram?
It defines the data type of an attribute
It indicates the number of instances of one entity that can be associated with instances of another entity
It specifies the name of the relationship between entities
It determines the primary key of an entity
Which of the following best illustrates a table violating First Normal Form (1NF)?
An "Employee" table with EmployeeID as the primary key
A "Product" table with a ProductID, Name, and Price
A "Customer" table with columns for CustomerID, Name, and Address
An "Order" table with an OrderID and separate columns for each item ordered (e.g., Item1, Item2, Item3)