Database Relationships and Keys

The video tutorial covers the process of designing database tables, focusing on items, loans, employees, and departments. It explains the importance of primary and foreign keys, and how to establish relationships between tables. The tutorial emphasizes the need for logical table design and the significance of one-to-many relationships in database management.

What is the primary purpose of a primary key in a database table?

• To store the name of the table

• To store the date of creation

• To uniquely identify each record in the table

• To link tables together

Why should certain data, like loan details, not be included in the items table?

• Because they change frequently and belong to a different table

• Because they are too complex to store

• Because they are irrelevant to the database

• Because they are not numerical data

What is the main reason for introducing a loan ID in the loans table?

• To calculate the total number of loans

• To store the name of the borrower

• To ensure each loan record is unique

• To make the table look more complex

What is the benefit of using a foreign key in a database table?

• To increase the size of the database

• To link tables and establish relationships

• To make the table more colorful

• To store additional data

Why might it be more practical to list the employee rather than the department in a loans table?

• Because employees are easier to remember

• Because it helps in tracking the specific person responsible for the item

• Because departments do not exist in the database

• Because employees have shorter names

What is a common relationship type between tables in a database?

• One-to-one

• One-to-many

• Many-to-one

• None of the above

What is the primary key in the employee table?

• Loan ID

• Department ID

• Employee ID

• Employee name

What is a potential issue if a supervisor table is not properly designed?

• It will not fit on the screen

• It will be too small

• It will be confusing and lack necessary data

• It will be too colorful

Why is it important to have a logical layout for relationships in a database?

• To increase the database size

• To make the database look pretty

• To ensure data integrity and ease of understanding

• To reduce the number of tables

What is the role of a department ID in the department table?

• To calculate the department's expenses

• To list all employees in the department

• To uniquely identify each department

• To store the department's budget