University:
Southern New Hampshire University
Course:
DAD220 | Introduction to Structured Database Environments
Academic year:

2023
Views:

446

Pages:

6
Author:

Cameron T.

Cameron Thistle SNHU DAD-220 03/18/2023 Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql> a. use (table you named); i. Example: mysql> use Jetson; mysql> use Thistle Create the Employee table using the SQL statement shown here. Press Return after each line. CREATE TABLE Employee ( creates employee table Employee_ID SMALLINT, creates employee id number First_Name VARCHAR(40), variable length string for first name up to 40 characters Last_Name VARCHAR(60), variable length string for last name up to 60 characters Department_ID SMALLINT, creates department id number Classification VARCHAR(10), variable length string for classification up to 10 characters STATUS VARCHAR(10), variable length string for status up to 10 characters Salary DECIMAL(7,2)); shows salary variable and allows to be decimal Create the Branches table. Fill in the missing characters or punctuation in the incomplete statement shown below to complete this action. a. CREATE Branches ( creates the branches table Department_ID SMALLINT, department id numbers created Department_Name ) department id created with VARCHAR for characters to be inserted Insert the following records into the Employee table. Each line going from left to right is a record. Each line going from top to bottom is a column. Validate your work with a screenshot. a. INSERT INTO Employee VALUES (100, 'John', 'Smith', 1, 'Exempt', 'Full-Time', 90000), (101,'Mary','Jones',2,'Non-Exempt','Part-Time',35000), (102,'Mary','Williams',3,'Exempt','Full-Time',80000); b. Type the command select* from Employee; and take a screenshot of it to validate this