QUESTION 1

Consider this table which violates 3NF

customer-branch

cust_id	fname	lname	branch	branch_zip_code
1	James	Hadley	Chicago	60007
2	Susan	Tingley	Naperville	60540
3	Frank	Tucker	Elmhurst	60106
4	John	Hayward	Chicago	60007

 Which statement best illustrates the insertion anomaly that can arise due to the 3NF violation?

a		INSERT INTO customers (cust_id, fname, lname, branch, branch_zip_code) VALUES (5, 'Louis', 'Blake", 'Chicago NW', 60007);
b		INSERT INTO customers (cust_id, fname, lname, branch, branch_zip_code) VALUES (5, 'John', 'Hayward', 'Chicago', 60007);
c		INSERT INTO customers (cust_id, fname, lname, branch, branch_zip_code) VALUES (5, 'Louis', 'Blake', 'Naperville', 60500);
d		INSERT INTO customers (cust_id, fname, lname, branch, branch_zip_code) VALUES (4, 'Louis', 'Blake', 'Wheaton', 60187);

QUESTION 2

Consider this table which tracks employees (by id and name) and the number of hours they worked on each project (project number and name). The primary key is {Eid,Pnumber} (Employee ID+Project Number)

Employee_Project +------+-------+---------+---------+----------+ | Eid | Pnumber | Hours | Ename | Pname |

+---------+------+-------+---------+----------+ | 1 | 100 | 15 | Hadley | Google | | 2 | 102 | 30 | Tingley | Facebook | | 3 | 27 | 5 | Tucker | Amazon | | 4 | 100 | 20 | Hayward | Google |

| 2 | 100 | 30 | Tingley | Google |

+------+---------+-------+---------+----------+ Which columns are responsible for the table failing to meet 2NF? (Select all that apply)

a		Hours
b		Eid (Employee ID)
c		Pname (Project Name)
d		Pnumber (Project Number)
e		Ename (Employee Name)

QUESTION 3

Which of these statements stand true for hypervisors (HVs)? (Select all that apply)

a		Type 2 HVs run on an underlying OS.
b		Type 1 HVs run on the underlying hardware.
c		Type 1 HVs were replaced by type 2 HVs after invention of relational databases.
d		Oracle Virtualbox is the fastest Hypervisor.

QUESTION 4

Questions 5, 6, and 7 refer to the following tables:

Which of the following statements is true?

a		There is no relationship between Employee and Department as the two tables arenot in 3rd Normal Form.
b		There a one to many relationship between Employee and Department.
c		Theres a one to one relationship between Employee and Department.
d		Theres a many to one relationship between Employee and Department.

QUESTION 5

Referring to the tables in question 18, which of the following statements are true? (Select all that apply)

a		There is a one to one relationship between Employee and Salary.
b		It would not violate 1NF, 2NF, or 3NF to combine the Employee and Salary tables into one table.
c		Salary should be included in both Employee and Department tables to satisfy 2NF criteria
d		Employee_id should be included in Salary in order to make the database relational.

QUESTION 6

Referring to the tables in question 18, in order to get a list of the employees who work in Downtown which of the following queries is correct?

a		SELECT Employee_id, Office FROM Department join Employee ON Department_id;
b		SELECT e.Employee_id FROM Employee e JOIN Department d ON e.Department_id = d.Department_id WHERE d.Office = Downtown;
c		SELECT d.Office FROM Employee e JOIN Department d ON e.Department_id = d.Department_id WHERE d.Office = Downtown;
d		All of the above.

Please explain in detail!

Thank you!

QUESTION 18 5 points Save Answer Questions 18, 19, and 20 refer to the following tables: Employee Employee_id (PK) Employee_name Ricky Jacobs Timmy Martin Donald Scone Lucy Moore Department_id (FK) HR0001 OP0002 EN0003 HR0001 Sal_id (FK) 101 201 301 401 4 Department sample tables Department_id (PK) HR0001 OP0002 ENO003 Department HR Operations Engineering Office Downtown Bronzeville Evanston Salary Salid (PK) 101 201 301 401 Amount 7000 7655 10000 7500 QUESTION 18 5 points Save Answer Questions 18, 19, and 20 refer to the following tables: Employee Employee_id (PK) Employee_name Ricky Jacobs Timmy Martin Donald Scone Lucy Moore Department_id (FK) HR0001 OP0002 EN0003 HR0001 Sal_id (FK) 101 201 301 401 4 Department sample tables Department_id (PK) HR0001 OP0002 ENO003 Department HR Operations Engineering Office Downtown Bronzeville Evanston Salary Salid (PK) 101 201 301 401 Amount 7000 7655 10000 7500