Module Three Major Activity
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by BaronDog3922
DAD 220 Module Three Major Activity Database Documentation Template
Mitchell Curtis
Create a Database
1.
In your integrated development environment (IDE),
create a database schema
called
QuantigrationRMA. List out the database name. Provide the SQL commands you ran to
successfully complete this in your answer, then connect to it:
This is a screenshot of the creation and connection to the database QuantigrationRMA.
2.
Using the entity relationship diagram (ERD) as a reference,
create
the following
tables
with the appropriate attributes and keys
:
a.
A table named
customers
in the QuantigrationRMA database as defined on the
project ERD. Provide the SQL commands you ran against MySQL to complete
this successfully in your answer:
This is a screenshot of the creation of the table Customers.
b.
A table named
orders
in the QuantigrationRMA database as defined on the
project ERD. Provide the SQL commands you ran against MySQL to complete
this successfully in your answer:
This is a screenshot of the creation of the table Orders.
c.
A table named
rma
in the QuantigrationRMA database as defined on the project
ERD. Provide the SQL commands you ran against MySQL to complete this
successfully in your answer:
This is a screenshot of the creation of the table RMA.
3.
Manually
add 10 records
into the
Customers table
. The data can be made up for now,
as you you’ll populate all three tables later from the provided CSV files.
This is a screenshot of the addition of 10 records into the Customers table. One is missing
because I inserted it alone to test that my input was correct.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4.
Create a view from the
existing Customers table
by using the SQL command provided
below
to say "Collaborators." The view should show all instances of "Customer" renamed
as "Collaborator."
This is a screenshot of the result of creating a view called collaborators changing the word
customer to collaborator from the table Customers.