How is a one-to-many relationship represented in an ER diagram?
Two lines connecting two entities
A line with a crow's foot symbol on one end and a single line on the other
A diamond connecting two entities
A single line connecting two entities
Why is defining a clear and well-structured schema important in database design?
It simplifies data management, improves data integrity, and enhances query efficiency.
It makes the database look visually appealing.
It eliminates the need for using SQL queries.
It automates the process of data entry.
What is the primary benefit of using cascading actions in database design?
Enhanced security
Simplified data manipulation
Improved query performance
Reduced storage space
Which of the following relationships is typically NOT implemented directly in a database but is often represented using an intermediary table?
Many-to-Many
One-to-Many
One-to-One
All of the above
Which of the following is NOT a good practice when designing a simple schema for a single entity?
Defining primary keys to uniquely identify each row
Storing redundant data in multiple columns
Choosing appropriate data types for columns
Using descriptive names for tables and columns
What happens to records in the 'Orders' table with 'ON UPDATE CASCADE' if a customer's ID is updated in the 'Customers' table?
An error occurs, and the update operation on the 'Customers' table is rolled back.
The 'Orders' table is unaffected, and the old customer ID remains.
The corresponding orders are deleted from the 'Orders' table.
The corresponding customer IDs in the 'Orders' table are automatically updated.
What is the main advantage of achieving higher normal forms in database design?
Slower query processing
Increased data redundancy
More complex database structure
Improved data integrity and reduced anomalies
You are designing a schema to represent a relationship between 'Students' and 'Courses'. What type of relationship best describes this scenario?
One-to-many
One-to-one
Many-to-one
Many-to-many
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Entity Table
Dimension Table
Fact Table
Lookup Table
What is the primary purpose of a Primary Key in a database table?
To ensure that all columns in the table have a value.
To establish a relationship with another table.
To uniquely identify each row within the table.
To define the order in which data is stored.