Angela Biroth
9/8/2022
DAD-220 Intro to Structured Database Env. Module 2-4 Lab
Type help;
nysql> use Biroth; Database changed nysql> CREATE TABLE Employee ( Emplovee_ID SMALLINT, First_Name VARCHAR(40), Last_Name VARCHAR(60), Department_ID SMALLINT Classification VARCHAR(lo), STATUS VARCHAR(10), Salary DECIMAL(7,2); Query 0K, o rows affected (o.o5 sec)
-> (102,'Mary','Williams',3,'Exempt','Full-Time' 80000); Query 0K, 3 rows affected(o.o2 sec) Records: 3 Duplicates: 0
nysql> SELECT* FROM Employee;
Emplovee_ID
classification STATUS
I Salary
100 John l01 Mary 102 Mary
Smith I Jones Williams
Exempt Non-Exempt Exempt
Full-Time 90000.00 Part-Time 35000.00 Full-Time 80000.00
in set (0.00 sec)
The screenshot above shows the successful entry of 3 files into the Employee table
/Sq]> SELECT* FROM Employee;
Employee_ID
classification
STATUS
Salar
l06 John 101 Mary 102 Mary 103 Gwen 104 Michael 105 I I Angi
Smith Jones Williams Johnson Jones Biroth
Exempt
Full-Time 90000.00 Part-Time 35000.00 Full-Time 80000.00 Full-Time 40000.00 Full-Time 90000.00 Full-Time 90000.00
I Non-Exempt 3 j Exempt 4 I NULL 41 Non-Exempt Non-Exempt
The above screenshot shows the addition of 3 more files into the table Employee
FROM Enployee;
Classification | sTATUS
Salar
nith
Mary 103 L05 Angi 106
NULL Non-
Full-Time FuLl-T Full
Exempt
The screenshot above shows that I have added a file for an athlete to the Employee table
IVSq]> SELECT First_Name. Last_Nam Employee_ID, Depa
e_ID I Depart
t_ID
Johr
seuoc Williams Johnson
Mary
102 103 104 105
Michael Angi
Biroth
The screenshot above shows the columns of First Name, Last Name, Employee ID and Department ID of the Employee