5.3.0 Database Schema Quizizz

What is the primary key in the "employees" table?

• emp_no

• dept_no

• hire_date

• birth_date

Answer explanation

You're looking for the golden "key" symbol.

Which table contains the "salary" field?

• salaries

• employees

• titles

• departments

Answer explanation

This UML shows the columns (aka. fields) in each table.

Which table is "dept_name" a field in?

• departments

• dept_emp

• employees

• titles

What data type is used for the "first_name" field in the "employees" table?

• VARCHAR(14)

• INT(11)

• DATE

• ENUM('M','F')

Which tables do NOT have any primary keys?

Check all that apply & click Submit.

• dept_emp

• salaries

• departments

• dept_manager

• titles

Which of these are a one-to-one relationship?

Check all that apply & click Submit.

• employees, dept_emp

• deparments, dept_emp

• departments, employees

• employees, salaries

• None of these

Which of these are a one-to-many relationship?

• employees, dept_emp

• deparments, dept_emp

• departments, employees

• employees, salaries

• None of these

Which of these are a many-to-many relationship?

• employees, dept_emp

• deparments, dept_emp

• departments, employees

• employees, salaries

• None of these

Which of these are junction tables?

• employees

• dept_emp

• departments

• titles

• dept_manager

Answer explanation

Junction tables are used to link two tables in a many-to-many relationship. 'dept_emp' connects employees to departments, and 'dept_manager' links departments to their managers, making them junction tables.

What's the foreign key relationship between employees & dept_emp?

Answer explanation

Junction tables are used to link two tables in a many-to-many relationship. 'dept_emp' connects employees to departments, and 'dept_manager' links departments to their managers, making them junction tables.