Question: Create a database and write two queries following the instructions. In MySQL workbench, create a simple three table database to store the simplified details of

Create a database and write two queries following the instructions. In MySQL workbench, create a simple three table database to store the simplified details of noodles, manufacturer and their ingredients as follows: Table Noodle (noodleId, noodleName, noodleType, packetWeight, numberOfServes, manufacturerId) Table Ingredient (ingredientId, ingredientName, ingredientAmount, ingredAmtType, noodleId) Table Manufacturer (manufacturerId, manufacturerName, streetAddress, city) Note: This is not meant to be a complete solution. 1. Create the tables assigning primary and foreign keys and selecting appropriate data types; 2. Forward engineer so that a script is created and save the script somewhere you will be able to find it to attach before submission; 3. Run the script and test the server to ensure correct. (10 marks) 4. Write a query that demonstrates that you can join the three tables. It is to display Manufacturer Name, Noodle Name and list of ingredients for each noodle and sort the results by manufacturerName and then Noodle Name. 5. You can check your query by adding some data to your tables and executing the query. 6. Save your query in a file as Query 1 somewhere you will be able to find it. (4 marks) 7. Write another useful query, test and save as Query 2. Remember to demonstrate your SQL skills that are different to the first query.. (6 marks) Instructions to attach the three (3) SQL script files The first file to be attached is your database creation script. Browse your computer files, select the file, save and then move onto the next question to attach your query 1 file. The final question will let you attach your query 2 file. Well done you will be finished once you have attached these files.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!