Which of the following is NOT a typical example of a dimension in a data warehouse schema?
Time
Product
Customer
Sales Amount
What is the main advantage of achieving higher normal forms in database design?
Improved data integrity and reduced anomalies
Increased data redundancy
More complex database structure
Slower query processing
What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
Many-to-many
One-to-one
Many-to-one
One-to-many
In a database table, what does a 'row' represent?
A specific attribute or characteristic of an entity.
A relationship between two different tables.
A unique record or instance within the table.
A column header describing the data type.
When converting an ER diagram to a database schema, what does an entity typically become?
A column
A row
A database
A table
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Join dependency
Partial dependency
Multi-valued dependency
Transitive dependency
Which of the following is NOT a good practice when designing a simple schema for a single entity?
Choosing appropriate data types for columns
Storing redundant data in multiple columns
Using descriptive names for tables and columns
Defining primary keys to uniquely identify each row
What is the primary purpose of a Primary Key in a database table?
To define the order in which data is stored.
To uniquely identify each row within the table.
To ensure that all columns in the table have a value.
To establish a relationship with another table.
In a normalized database, what is the typical relationship between tables?
One table contains all the data, while others are empty
Tables are connected through foreign keys
Tables are organized alphabetically
Tables are completely independent
In which scenario might denormalization be considered acceptable in database design?
To increase data redundancy
To simplify the database schema
To enforce strict data integrity
To improve query performance by reducing joins