DAD_220_Project_One

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by wsalter1

DAD 220 Database Documentation Template Complete these steps as you work through the directions for Project One. Replace the bracketed text with your screenshots and brief explanations of the work they capture. Each screenshot and its explanation should be sized to approximately one quarter of the page, with the description written below the screenshot. Follow these rules for each of the prompts and questions below. Review the example document located in the Project One Supporting Materials for assistance. Step One: Create a Database 1. Navigate to your online integrated development environment (IDE). List and record the SQL commands that you used to complete this step here: The commands are as follows:  chmod +x change_perm.sh  ./change_perm.sh  Mysql  Show databases I followed the initializing instructions, then pulled up available databases. 2. Create a database schema called QuantigrationUpdates. List out the database name. Provide the SQL commands you ran against MySQL to successfully complete this in your answer:  Create database QuantigrationUpdates;  Show databases;

I created the database QuantigrationUpdates, then listed the available databases to confirm. 3. 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 QuantigrationUpdates database, as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:  Use QuantigrationUpdates;  Create TABLE Customers (CustomerID INT,  FirstName VARCHAR(25),  LastName VARCHAR(25),  Street VARCHAR(50),  City VARCHAR(50),  State VARCHAR(25),  ZipCode INT,  Telephone VARCHAR(15),  PRIMARY KEY (CustomerID));  Describe Customers;

I created the table Customers using the fields from the ERD. I then used the command DESCRIBE Customers to confirm the table was correct. b. A table named Orders in the QuantigrationUpdates 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),  PRIMARY KEY (CustomerID));  DESCRIBE Orders;

I created the table Orders based on the data in the ERD. I then used the describe command to confirm the table Orders was correct. c. A table named RMA in the QuantigrationUpdates 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 (RMAID INT,  OrderID INT,  Reason VARCHAR(25),  Status VARCHAR(50),  Step VARCHAR(15),  PRIMARY KEY (RMAID));  DESCRIBE RMA;

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version