Overview
Correctly interpreting the information presented in tables and identifying the outputs of certain commands are skills necessary for success in data analytics. In this assignment, you will practice identifying the components of a database. You’ll also see some of the commands that can be used to present information and update the tables as well.
Prompt
The tables below follow a relational data structure. Use what you’ve learned from this module’s resources, the tables, and the SQL statements below to answer the questions that follow. Download the Module Two Activity Template from the Guidelines for Submission section below, retitle it to include your last name, place your answers in it, and submit it for grading. The SQL statements shown here relate directly to commands that can be used to generate similar outcomes to those in the tables below.
Employee Table
Employee_IDFirst_NameLast_NameDepartment_IDClassificationStatusSalary100JohnSmith1ExemptFull-Time90000101MaryJones2Non-ExemptPart-Time35000102MaryWilliams3ExemptFull-Time80000103GwenJohnson2NULLFull-Time40000104MichaelJones3Non-ExemptFull-Time90000
SQL Statement 1
CREATE TABLE Employee (
Employee_ID SMALLINT,
First_Name VARCHAR(40),
Last_Name VARCHAR(60),
Department_ID SMALLINT,
Classification VARCHAR(10),
Status VARCHAR(10),
Salary DECIMAL(7,2));
Branches Table
Department_IDDepartment_Name1Accounting2Human Resources3Information Systems4Marketing
SQL Statement 2
CREATE TABLE Branches (
Department_ID SMALLINT,
Department_Name VARCHAR(50));
0 comments