Answer to Question #324686 in Databases | SQL | Oracle | MS Access for jes

Question

Study the ERM below and answer the questions that follow. The ER diagram captures relationships between production lots (or batches), individual production units, and raw materials.

3.1 Using SQL , design the above conceptual model, with attention to the relationships. Show a screenshot of your logical model.

3.2 Show the SQL query generated for creating the logical model you created in Question 3.1 above.

3.3 Put pseudo data into the tables. After putting the data into the tables, run the following queries:

a. Display all material types contained in the database.

b. Display the results of the inner joint between Lot and Production Units.

c. Create a view of your choice and state what is shown.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order