Here my ERD. Help me to present the relational schema until 3NF. This is the example for 1NF on how I use to do normalization:CRISPY FRIED CHICKEN SDN BHD (Company_Staff_ID, Company_Product_Code,Customer_ID, Customer_Name, Customer_Address, Customer_PhoneNo,Delivery_ID*, Staff_ID, Staff_Name, Staff_Address, Staff_PhoneNo, Order_ID,Order_Date, Order_Quantity, Staff_ID*, Customer_ID*,Product_Code,Product_Name, Product_Price, Order_ID*, Delivery_ID*, Vehicle_ID, Vehicle_Types,Staff_ID*, Delivery_ID, Delivery_Quantity, Vehicle_ID*). REGISTERfillsfillsK PK Student_IDFK1 Subject_CodeSTUDENTSUBJECTPKStudent_IDPK Subject_CodeFK1Student_NameFK1 Subject_NameStudent_AgeSubject_Descriptionis enrollSubject_CodeStudent_AddressStudent_No. TelephonedownloadENROLLI hasPKClass_Codeshow inCLASSFK1 Student_IDE-BOOKPK Class_CodeEnroll_GradeSUBJECT_TECHPK eBook_CodeFK1 Subject_CodePK Subject_Codeis enrollFK1 eBook_TitleTutor_IDK FK1 Student_IDSubject_codeTutor_IDhasTUTORuploadPKTutor_IDteachesFK1 Tutor_NameSubject_CodeTutor_EmailTutor_No. Telephone

Normalize the following to the first, second and third normal form: HEALTH HISTORY REPORT PET…

Answered: Here my ERD. Help me to present the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Here my ERD. Help me to present the relational schema until 3NF. This is the example for 1NF on how I use to do normalization: CRISPY FRIED CHICKEN SDN BHD (Company_Staff_ID, Company_Product_Code, Customer_ID, Customer_Name, Customer_Address, Customer_PhoneNo, Delivery_ID*, Staff_ID, Staff_Name, Staff_Address, Staff_PhoneNo, Order_ID, Order_Date, Order_Quantity, Staff_ID*, Customer_ID*, Product_Code, Product_Name, Product_Price, Order_ID*, Delivery_ID*, Vehicle_ID, Vehicle_Types, Staff_ID*, Delivery_ID, Delivery_Quantity, Vehicle_ID*).

REGISTER
fills
fills
K PK Student_ID
FK1 Subject_Code
STUDENT
SUBJECT
PK
Student_ID
PK Subject_Code
FK1
Student_Name
FK1 Subject_Name
Student_Age
Subject_Description
is enroll
Subject_Code
Student_Address
Student_No. Telephone
download
ENROLL
I has
PK
Class_Code
show in
CLASS
FK1 Student_ID
E-BOOK
PK Class_Code
Enroll_Grade
SUBJECT_TECH
PK eBook_Code
FK1 Subject_Code
PK Subject_Code
is enroll
FK1 eBook_Title
Tutor_ID
K FK1 Student_ID
Subject_code
Tutor_ID
has
TUTOR
upload
PK
Tutor_ID
teaches
FK1 Tutor_Name
Subject_Code
Tutor_Email
Tutor_No. Telephone

Expert Solution

Step by step

Solved in 6 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions