As a stage of designing the Semuarasa restaurant database, some entity information and documents are known as follows. • Food Menu: consists of menu code, name of food menu, food category, area of origin, price, picture menu (one menu can have many pictures), number of portions available per day. • Customer: customer code, full name, place of birth, type of phone, address, email, cellphone number, WA number. • Employee: employee code, employee name, cellphone number, and method. • Restaurant Branch: Branch code, branch name, address, city, telephone number, WA number, email. • An example of a purchase receipt form as follows. 1. From the information above, do the normalization steps from 1NF, 2NF to 3NF. 2. Draw ERD from the table of results for the 3NF. ERD is completed with all the attributes of each entity, PK, FK, multiplicity (participation and cardinality). 3. Do an enhanced entity-relationship with ERD, complete with participation and disjoint constraints.
As a stage of designing the Semuarasa restaurant
• Food Menu: consists of menu code, name of food menu, food category, area of origin, price, picture menu (one menu can have many pictures), number of portions available per day.
• Customer: customer code, full name, place of birth, type of phone, address, email, cellphone number, WA number.
• Employee: employee code, employee name, cellphone number, and method.
• Restaurant Branch: Branch code, branch name, address, city, telephone number, WA number, email.
• An example of a purchase receipt form as follows.
1. From the information above, do the normalization steps from 1NF, 2NF to 3NF.
2. Draw ERD from the table of results for the 3NF. ERD is completed with all the attributes of each entity, PK, FK, multiplicity (participation and cardinality).
3. Do an enhanced entity-relationship with ERD, complete with participation and disjoint constraints.
Step by step
Solved in 4 steps with 23 images