Which of the following is NOT a characteristic of a table in First Normal Form (1NF)?
The table contains a foreign key referencing another table
There are no repeating groups of columns
A primary key uniquely identifies each row
Each column contains atomic values
When designing a schema for a library, what is the most appropriate primary key for the 'Books' table?
Book Title
ISBN
Publication Year
Author Name
Which of the following is NOT a valid SQL data type for storing numerical values?
VARCHAR
FLOAT
DECIMAL
INTEGER
What is the primary difference between a Star Schema and a Snowflake Schema?
Snowflake Schemas normalize dimension tables.
Star Schemas are used for real-time analytics.
Snowflake Schemas don't use fact tables.
Star Schemas have more joins.
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?
Second Normal Form (2NF)
None of the above
First Normal Form (1NF)
Third Normal Form (3NF)
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Multi-valued dependency
Join dependency
Partial dependency
Transitive dependency
What is the role of cardinality in an ER diagram?
It indicates the number of instances of one entity that can be associated with instances of another entity
It determines the primary key of an entity
It defines the data type of an attribute
It specifies the name of the relationship between entities
What does the 'ON DELETE CASCADE' constraint do?
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.
It prevents deletion of records in the parent table if there are matching records in the child table.
It automatically deletes matching records in the child table when a record in the parent table is deleted.
It has no impact on the child table when a record in the parent table is deleted.
A Foreign Key in a database is used to...
Create a primary key for a related table.
Enforce data validation rules on a column.
Define a new data type for a column.
Establish a link between two tables based on a common column.
Which SQL keyword is used to establish a relationship between two entities by referencing the primary key of one table in another table?
RELATIONSHIP
FOREIGN KEY
JOIN
PRIMARY KEY