QUESTION 2

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);

5 points

QUESTION 3

1. 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)

5 points

QUESTION 4

1. Consider this table which satisfies Fourth Normal Form (4NF)

   student_id	course	student_hobby
   1	Math	Running
   1	Science	Running
   1	Math	Chess
   1	Science	Chess
   2	Math	Baseball
   2	Math	Chess
   2	Math	Movies

   If student 2 starts taking Biology, how many rows will need to be added to the table?

   a		2
   b		4
   c		3
   d		1

   QUESTION 11

2. Which of the following statement is true about views?

   a		Creating a view for a table with many rows of data takes longer than creating a view for an empty table because all the new data must be created and stored.
   b		A view can be constructed from one and one table only.
   c		A view is the formal name for a table.
   d		A view is a query that is stored in the data dictionary. It looks and acts like a table,but there is no data associated with a view.

   QUESTION 13

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 16

4. Select the true statement about MySQL workbench.

   a		MySQL Workbench is a relational database with capabilities to connect to the internet.
   b		MySQL Workbench is a visual database design tool that integrates SQLdevelopment, administration, database design, creation and maintenance into asingle integrated development environment for the MySQL database system.
   c		MySQL Workbench does not allow the execution of raw SQL commands.
   d		All of the above

5. Questions 18, 19, and 20 refer to the following tables:

6. 

7. QUESTION 18

8. 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.

9. 5 points

   QUESTION 19

10. 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.

11. QUESTION 20

12. 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.

13. Please explain! Thanks!

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