Database Design and Implementation

****Normalization****

Introduction This project is based on Eagle Hotel International once again. For problems 1-3, answer/do the following based on the relations provided below: a) Label the type of dependencies that have already been identified. b) Identify what normal form the relation is in and explain why. c) Identify a set of 3NF relations (draw the relational schema). Create a Word document for your answers and name the file M4-Assign2.docx. Problem 1: GENERAL_TABLE Eagle Hotel would just like to see if you can normalize a relation by testing you with the following scenario. A B F G 1 Problem 2: PRODUCT_RECEIPT Customers can purchase products at convenience marts in each of the hotels that are supplied by vendors. The hotel chain wants to track product information, vendor information and receipts. The customer receives a receipt with a sale date. The hotel chain also wants to track the quantity sold for each product on each receipt. . . RECEIPT_NUM PROD NUM SALE_DATE PROD_NAME PROD_PRICE VEND_CODE VEND_NAME QUANT_SOLD . Problem 3: EMPLOYEE The hotel chain wants to track employee information. The hotel would like to track the education of each employee by tracking all degrees an employee has. The hotel chain also wants to track the training courses each employee has taken. Each course has a course number and title. EMP NUM LNAME FNAME {EDUCATION) TITLE PAY DOB HIRE_DATE {COURSE(course_num, title)}