When converting an ER diagram to a database schema, what does an entity typically become?
A row
A column
A database
A table
What is the main advantage of achieving higher normal forms in database design?
Improved data integrity and reduced anomalies
Slower query processing
More complex database structure
Increased data redundancy
Which of the following is a characteristic of a Dimension table in a Star Schema?
Contains highly transactional data
Typically has a small number of rows
Focuses on storing calculated metrics
Provides descriptive attributes about business entities
What is the primary purpose of a Primary Key in a database table?
To establish a relationship with another table.
To ensure that all columns in the table have a value.
To uniquely identify each row within the table.
To define the order in which data is stored.
What is the PRIMARY purpose of using indexes in a database?
To enforce data integrity constraints
To speed up data retrieval operations
To reduce disk space consumption
To improve data security
Which of the following best illustrates a table violating First Normal Form (1NF)?
An "Employee" table with EmployeeID as the primary key
A "Customer" table with columns for CustomerID, Name, and Address
A "Product" table with a ProductID, Name, and Price
An "Order" table with an OrderID and separate columns for each item ordered (e.g., Item1, Item2, Item3)
Which of the following is a key benefit of using a well-designed schema for a data warehouse?
Increased data redundancy for backups
Reduced need for data modeling and analysis
Simplified data loading from various sources
Improved query performance and efficiency
You are designing a schema to represent a relationship between 'Students' and 'Courses'. What type of relationship best describes this scenario?
One-to-one
One-to-many
Many-to-many
Many-to-one
Which of the following best describes a partial dependency in a database table?
A primary key is dependent on a foreign key
A foreign key is dependent on the primary key of the same table
A non-key attribute is dependent on another non-key attribute
A non-key attribute is dependent on only part of a composite primary key
What is the key difference between a database and a schema?
There is no difference; the terms are interchangeable.
A database is a broader concept encompassing one or more schemas, each defining a logical structure within the database.
A database is a collection of tables, while a schema defines the structure of a single table.
A database stores the actual data, while a schema defines the rules for accessing that data.