Which constraint would ensure that no two rows in the same table have the same values in a specific column?

table Order with a column Customer ID references Customer table with the primary key Customer ID. What constraint would you use to enforce this relationship?

In which situation would you use an ON DELETE CASCADE referential constraint?

A Not Null constraint is used to:

You are tasked with creating a Customer table where the email address must be unique for each customer. What constraint would you apply to the email column?

Each department can have multiple employees, but each employee can belong to only one department. What kind of relationship does this represent?

Which integrity constraint would you use to ensure that a salary column in an Employee table only accepts values greater than zero?

In a library database, each book can only be checked out by one member at a time, but a member can check out multiple books. What type of relationship should you define between Member and Book tables?

Which of the following is not a characteristic of a Primary Key?

You are designing a schema where an employee can be managed by another employee, and you need to model this relationship within the same table. How would you represent this?

A Foreign Key constraint ensures that:

Which of the following is a valid reason to use a Check Constraint?

Suppose that there are two tables, Customer and Order. If a customer is deleted, all related orders should also be deleted. What referential action should you use?

In which situation would you use an ON DELETE SET NULL referential constraint?

A Customer table has a foreign key referencing the Country table, but you want to ensure that if a country is deleted, the related customer records should remain, with the Country ID set to null. How would you enforce this?

You are designing a hotel booking system where each room can only be booked by one customer at a time, but each customer can book multiple rooms during their stay. What type of relationship should you create between the Room and Customer tables?

Which type of constraint would you apply to a column that should not contain duplicate values but can contain nulls?

In a sales database, you want to ensure that discounts are never negative. What constraint should you apply to the Discount column?

What is the main purpose of a Foreign Key Constraint in a relational database?

You have a Product table where each product can have multiple suppliers, and the supplier information is repeated for each product. What normal form is this table violating?

Which of the following ensures that all data is atomic and eliminates repeating groups?

You have an Orders table where both Order ID and Product ID form the composite primary key. The Customer Name is also stored in this table but only depends on Order ID. What normal form does this table violate?

table is in Second Normal Form (2NF) when:

You are working with a university database where students can enroll in multiple courses, and each course is taught by a single instructor. How would you design this to meet 3NF?

Which normal form removes transitive dependencies, ensuring that non-key attributes do not depend on other non-key attributes?

The following table stores customer orders, where Order ID and Customer Name are included. Customer Name only depends on Order ID, not on Product details. What normal form is violated?

In which normal form must a table be if it is already in BCNF?

In a Books table, you store Author Name, Book Title, and Publisher Name. The Publisher Name depends on the Author Name but not the Book Title. How would you bring this table to 3NF?

Which of the following best describes Boyce-Codd Normal Form (BCNF)?

You are designing a database for a retail store. Each product can be supplied by multiple vendors, and each vendor can supply multiple products. How would you design this to eliminate redundancy?

The following table stores student information where Student ID is the primary key, and a student can have multiple hobbies and enroll in multiple courses. What normal form is violated?

A table is in 4NF if:

In a hospital database, each doctor can have multiple patients, and each patient can be treated by multiple doctors. How would you normalize this relationship?

Which normal form deals specifically with eliminating partial dependencies in composite keys?

You are creating a Students table where each student can enroll in multiple courses, but each course has only one instructor. If the table also has an Instructor ID for each course, what normal form is it violating?

In which normal form are multivalued dependencies eliminated?

The following table stores courses and instructors, but each course has only one Instructor. If the course time is dependent on the Instructor, not the course itself, what normal form is violated?

Why might you choose to denormalize a database?

In a sales database, orders include both customer and product information. You need to avoid anomalies while maintaining performance. What strategy would you use?