LEARN MORE...

Access Millions of academic & study documents

DAD 220 Module Three Major Activity Database Chris Thorpe

Content type
User Generated
Showing Page:
1/5
DAD 220 Module Three Major Activity Database Documentation Template
Christopher Thorpe
Step One: 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:

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
2. Using the 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:
1.CREATE TABLE Customers (
-> CustomerID INT,
-> First_Name VARCHAR (25),
-> Last_Name VARCHAR (25),
-> Street VARCHAR (50),
-> City VARCHAR (50),
-> State VARCHAR (25),
-> ZipCode INT,
-> Telephone VARCHAR (15));

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
DAD 220 Module Three Major Activity Database Documentation Template Christopher Thorpe Step One: 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: 2. Using the 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: 1.CREATE TABLE Customers ( -> CustomerID INT, -> First_Name VARCHAR (25), -> Last_Name VARCHAR (25), -> Street VARCHAR (50), -> City VARCHAR (50), -> State VARCHAR (25), -> ZipCode INT, -> Telephone VARCHAR (15)); 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: CREATE TABLE Orders ( -> OrderID INT, -> CustomerID INT, -> SKU VARCHAR(20), -> Description VARCHAR(50)); b. 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: CREATE TABLE RMA ( -> Reason VARCHAR(25), -> RMAID INT, -> OrderID INT, -> Status VARCHAR(50), -> Step VARCHAR(15)); 3. Edit the provided SQL query to update your existing table from ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

Arcs and chords :) Please and thanks!
...
Saint Martin's University Sociology of Race & Ethnicity Paper
this is for a course called Sociology of Race & Ethnicity For this final paper, select a topic that addresses issues s...
MGT 403 SEU Knowledge Management Processes Questions
‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية ا...
MM Discussion 2
What Is the Best Type of Marketing Research?Many market researchers have their favorite research approaches or techniques,...
DSS Periodicals, management homework help
Write a brief review of 1 article found on each of the below listed websites, for a total of 2 article reviews, and how th...
Ashford University Public Administration Case Discussion Questions
Write a summary of the readings for this week. Work on identifying the key ideas in each reading and explaining them and t...
M466 United States Ship Forrestal.edited 1 .edited.edited
The United States Ship (USS) Forrestal was a carrier ship that was designed to aid in the Vietnam War. The USS Forrestal w...
Revised History Of A Grammatical Structure Annotated Bibliography 1
Arguably, the rhetorical of English incorporates the historical perspective in the grammar and the structure. This is main...
Normalization relationship database
A database is an information structure that stores information. Most of them comprise various tables, which may also incor...