SQL Quiz 4

Select the Normal Form by the table description: Schedule (sch_id (PK), teacher_id, subject_id, time)

• <3 NF>

• <0 NF>

• <1 NF>

• <2 NF>

Select the Normal Form by the table description: Departments (department_id (PK), name, teacher_lastnames)

• <0 NF>

• <1 NF>

• <2 NF>

• <3 NF>

Select the Normal Form by the table description: Groups (group_id (PK), group_name, student_lastnames)

• <0 NF>

• <1 NF>

• <2 NF>

• <3 NF>

Third normal form is based on the concept of ...

Which normal form is considered "good" for relational database design?

• <3NF>

• <0NF>

• <1NF>

• <2NF>

Complete the code to create the table Teachers (teach_id (PK), last_name, depart_id (FK)): CREATE TABLE Teachers( teach_id int PRIMARY KEY, last_name varchar(20), depart_id int, ________________ (depart_id) REFERENCES Departments(depart_id));

Complete the code to create the table Departments (dep_id (PK), dep_name): CREATE TABLE Departments( dep_id int ___________ , dep_name varchar(15));

Complete the code to create the table Students (stud_id (PK), last_name): CREATE TABLE Students( stud_id int, last_name varchar(20), ________________ (stud_id));

Complete the code to create the table Groups (group_id (PK), group_name): ___________ Groups( group_id int PRIMARY KEY, group_name varchar(20));

• The SQL command which allows to change the structure of a table is