Catering Database Management
Augustine Barlow PROGRAMMING ASSIGNMENTS HELP help@programmingassignmentshelp.net
This Catering Database Management Assignment discusses developing a database for a catering company. Discerning Event Organizers (DEO) is a private company which offers catering services to a range of clients including individuals, businesses, schools and government departments. The motive to design a database that will fulfill their requirements as stated in the case study. This assignment will help the database designer to understand and apply fundamental concepts of database management system.
An entity relation (E-R) diagram using Crow’s Foot notation
Assumptions  
We have assumed that the entire table must not contain any null field value. Normalization is applied up to 2NF level to ensure the consistency and minimizing redundancy.
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
We have made a separate Supplier_product to manage the supplier product combination. We have made a separate Address table to store the address of all the customers and suppliers and staff members. We have made a separate Staff_booking table to manage only those staff that has current booking of events. We have taken into consideration the dependencies of attributes in each relation.
Read more about Computer network assignment help
Normalization The normalization is a process of eliminating anomalies form the existence database and brings it back to the consistent state.
Dependency diagram
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
Level of Normalization There are several levels of normalization such as 1NF, 2NF or 3NF. We have made the database by applying normalization to it to minimize the duplicity or redundancy into the database.
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net
Customer table is in 1NF Business_Customer table is in 1NF Government_Customer table is in 1NF School_Customer table is in 1NF Address table is in 2NF Supplier table is in 2NF Supplier_product table is in 1NF Product is table in 2NF Order table is in 1NF Staff table is in 2NF Staff_Booking table is in 1NF Read more about computer programming assignment help Programming Assignments Help is the best assignment help provider in the United Kingdom. Our online assignment writing help UK is especially dedicated for the students studying in all UK colleges and universities. Submit assignment to get the best quality assignment help.
www.programmingassignmentshelp.net
help@programmingassignmentshelp.net