SQL DATABASE DESIGN

1. Database Design: A list of all tables in the database using DBDL in at least 3NF. 2. Database Design: Create an E-R Diagram showing each table, the attributes of the table, the primary key and any foreign keys. Please show the relationships between the tables and the type of relationship (1-to-1, 1-to-many, etc). HERE ARE THE REQUIREMENTS- Someone suggests that you meet for a dessert (or two) at a local restaurant. Its is important to pick the right place. Each person has favorite desserts. We need to select a place that serves at least one dessert each person likes. To solve the problem, you decide to design a database to keep track of all the students in the class including their first and last names(required). Each student has a five character id that is unique. You will also record the name of three desserts a student likes. A student may like many different desserts, and many students may like the same dessert. Also, we need to keep track of all the names of all restaurants in the area(required), their phone number and all the different desserts they serve. We need to note the location of each restaurant so that we can easily find the location. A restaurant may serve many desserts, and many restaurants may serve the same dessert. For each dessert, you need to record the name of the desert (required), the price of the dessert which must be greater than zero and the number of calories in the dessert which is between 300 and 1000.