Homework Questions? Ask a Tutor for Answers ASAP
In W2 Assignment 2, you used MySQL Workbench to create an Entity-Relationship (ER) diagram for ABC Manufacturing's customer relationship management (CRM) system and in W3 Assignment 2 you created the database. The company has received significant value for your work and they have asked you take on a new project. ABC Manufacturing would like you to create an inventory management system.
You will need to start by creating an ER model, including both Entity Classes and attributes. This is to be done in MySQL Workbench.
Then, using both MySQL Workbench and MySQL Server, create a schema called ABC_YourLastName. In this schema, create all the necessary tables, columns, and relationships to meet the following requirements:
To submit your database to the Dropbox, you must export the schema to a file. To perform an export, complete the following steps from the MySQL Workbench Home tab:
Lastly, you will need to populate the tables using SQL scripts. You will also need to produce the SQL scripts to provide the raw material reorder data. Save your SQL scripts in a Microsoft Word document as you will need to submit them.
In addition, in a 2- to 3-page Microsoft Word document, create a report that includes the following information:
Cite any sources in APA format.