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

LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
5th Edition
ISBN:9781337569798
Author:ECKERT
Publisher:ECKERT
Chapter7: Working With The Bash Shell
Section: Chapter Questions
Problem 5DE
icon
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
Transcribed Image Text: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
steps

Step by step

Solved in 6 steps with 1 images

Blurred answer
Knowledge Booster
Arrays
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L