Quantigration, a rapidly growing networking equipment manufacturer, has been having problems with their equipment returns. Youve been
Question:
Quantigration, a rapidly growing networking equipment manufacturer, has been having problems with their equipment returns. You’ve been hired to create a database using SQL commands for processing all returns.
Directions
You’ll use the return merchandise authorization (RMA) entity relationship diagram (ERD) to build a database. Each of the tables in the ERD represents a database entity. The ERD is the blueprint for building your relational database.
Before you begin, do the following:
Make sure to download the Module Three Major Activity Database Documentation Template for this assignment. You’ll need to place your answers and screenshots in this document and then submit it for grading.
Check the Database Documentation Template Example to see expectations of what your assignment should look like.
Make sure to review the example RMA entity relationship diagram (ERD) that you should be using as a guide before you begin.
Review the module resources on how to capture screenshots, if necessary.
Go to your online integrated development environment (Codio), log in, start a new terminal session, and then create a database schema called QuantigrationRMA that can hold tables. List it out on the screen. Then, connect to the QuantigrationRMA schema.
Using the ERD as a reference, create the following tables with the appropriate attributes and keys:
A table to store customer information with a primary key of Customer ID
A table to store order information with a primary key of Order ID and foreign key of Customer ID
A table to store RMA information with a primary key of RMA ID and foreign key of Order ID
Manually add 10 records into the Customers table. The data can be made up for now, as you’ll populate all three tables later from the provided CSV files.