(Solved): bakeryDB.sqlbakeryQueries.sqlcustomers.csvitems.csvorders.csv what you info you want Bakery Database ...

 

Bakery Database In this exercise, we will focus on the design and creation of several tables and queries to model a simple bakery system. The class diagram of the system is as follows: Note that this is a class diagram not an E-R diagram. So, mapping might be needed. There also might be a need to add some additional fields to some tables, add some tables, combine or delete class(es). Add an E-R diagram of your database design along your submission (a png or jpg file). Your database design should be in 3-NF. The bakeryDB.sql file will have an SQL script that contains all of the necessary SQL queries to create your database. Be sure that you do the following: - Use conditional drop table if exists statements to clear out old versions of tables with the same name. - Do not include a use database statement in your final script file. We will be running your DDL on our own database instance and will not have access to your database. - After creating your tables, include all necessary insert statements from the provided data files. In bakeryQueries.sql, you need to create queries to perform the following operations: 1. A query to retrieve the main attributes of each customer (their id, name, and phone Number). 2. A query to retrieve the main attributes of each item. 3. A query to get the email addresses of a specific customer. 4. A query to change the email address of a specific email record 5. A query (or series of queries) to remove a specific customer record 6. A query to get all the names of items purchased by a specific customer order 7. A query to find the total number of orders made by each customer 8. A query to find the name of any invalid customer. An invalid customer is a guest customer that did not made any order. Clearly number these queries (using comments) in your SQL script and add any additional testing queries at the end. - create your database here - insert the records from the .csv files after that - remove your (use USRNAME) in your final submission - remove your use USRNAME in your final submission -. comment and number each query \( \begin{array}{lll}\text { itemid } & \text { itemName price } & \text { dateOfManufacturing } \\ 1 \text { Pagel } & 1.89 \\ \text { 2 Brownie } & 3.69 \\ 3 \text { Cookie } & 2.89 \\ 4 \text { Croissant } & 3.59 \\ 5 \text { Cinnamon 1 } & 3.99 \\ 7 \text { Bear Claw } & 3.99 \\ \text { 8 Muffine } & 3.69\end{array} \)