CLASS SUBJECT - Modern System Analysis

I need the answer for 9.44 ONLY

5 > C Chegg: Modern System x + V O & https://ereader.chegg.com/w/books/9780135172827/cfi/6/258!/4/2/4/2/2/2/290:100 E 9.44 Transform the E-R diagram of Figure 8-23 into a set of 3NF relations. Make up a primary key where needed and one or more nonkey attributes for each entity. 9.45 Consider the E-R diagram of Figure 9-210 a. Transform this E-R diagram into a set of 3NF relations. b. State and justify all referential integrity rules for the 3NF relations you created in Problem and Exercise 9.45a. Figure 9-21 E-R diagram for Problem and Exercise 9.45 VENDOR PRICE QUOTE Quote Quantity Vendor ID Price Address PART Item Number Description Priced at PART RECEIPT Order_Number Date Order_Quantity 9.46 Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities. PATIENT(Patient_ID, Room_Number, Admit_Date Address) ROOM(Room_Number, Phone, Daily_Rate) PATIENT(Patient_Number, Treatment_Description, Address) TREATMENT(Treatment_ID,Description, Cost) PHYSICIAN(Physician_ID, Name, Department) PHYSICIAN(Physician_ID, Name Supervisor_ID) 334 6 Aa ^ - Fa Type here to search 5 > C Chegg: Modern System x + V O & https://ereader.chegg.com/w/books/9780135172827/cfi/6/258!/4/2/4/2/2/2/290:100 E 9.44 Transform the E-R diagram of Figure 8-23 into a set of 3NF relations. Make up a primary key where needed and one or more nonkey attributes for each entity. 9.45 Consider the E-R diagram of Figure 9-210 a. Transform this E-R diagram into a set of 3NF relations. b. State and justify all referential integrity rules for the 3NF relations you created in Problem and Exercise 9.45a. Figure 9-21 E-R diagram for Problem and Exercise 9.45 VENDOR PRICE QUOTE Quote Quantity Vendor ID Price Address PART Item Number Description Priced at PART RECEIPT Order_Number Date Order_Quantity 9.46 Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities. PATIENT(Patient_ID, Room_Number, Admit_Date Address) ROOM(Room_Number, Phone, Daily_Rate) PATIENT(Patient_Number, Treatment_Description, Address) TREATMENT(Treatment_ID,Description, Cost) PHYSICIAN(Physician_ID, Name, Department) PHYSICIAN(Physician_ID, Name Supervisor_ID) 334 6 Aa ^ - Fa Type here to search