Create the sql code to insert the data

Assignment Help Computer Engineering

Reference no: EM133694881

Question: Create the SQL Code to insert the data for each of the tables in the database provided in the pictures. I will provide the SQL code used to create the tables as well in case its needed. You can ignore the Dependent tables data, as that one has not been created yet.

SQL CODE USED TO CREATE THE TABLES:

CREATE TABLE EMPLOYEE_maw
(SSN_Number CHAR(9) NOT NULL,
First_Name VARCHAR(15) NOT NULL,
Mid_Name CHAR,
Last_Name VARCHAR(15) NOT NULL,
Birthday DATE,
Address VARCHAR(50),
Gender CHAR CHECK (Gender IN ('M', 'F', 'm', 'f')),
Salary DECIMAL DEFAULT 80000,
Supervisor_SSN CHAR(9),
Department_Number INT,
CONSTRAINT EMPLOYEE_PK PRIMARY KEY(SSN_Number),
CONSTRAINT EMPLOYEE_FK FOREIGN KEY(Supervisor_SSN) REFERENCES EMPLOYEE_maw(SSN_Number));

CREATE TABLE DEPARTMENT_maw
(Department_Name VARCHAR(15) NOT NULL,
Department_Number INT NOT NULL,
Manager_SSN CHAR(9) NOT NULL,
ManageStartDate DATE,
PRIMARY KEY (Department_Number),
CONSTRAINT DEPARTMENT_FK FOREIGN KEY (Manager_SSN) REFERENCES EMPLOYEE_maw (SSN_Number));

CREATE TABLE DEPT_LOCATION_maw
(Department_Number INT,
Department_Location VARCHAR(15),
CONSTRAINT PK_DEPT_LOCATION PRIMARY KEY (Department_Number),
CONSTRAINT FK_DEPT_LOCATION_DEPARTMENT FOREIGN KEY (Department_Number) REFERENCES DEPARTMENT_maw (Department_Number) ON DELETE CASCADE);

CREATE TABLE PROJECT_maw
(Project_Name VARCHAR(15) UNIQUE NOT NULL,
Project_Number INT PRIMARY KEY,
Project_Location VARCHAR(15),
Department_Number INT,
CONSTRAINT PROJECT_maw_FK FOREIGN KEY (Department_Number) REFERENCES DEPARTMENT_maw(Department_Number));

CREATE TABLE PROJECT_ASSIGNMENT_maw
(Employee_SSN CHAR(9),
Project_Number INT,
Hours DECIMAL(3, 1) NOT NULL,
CONSTRAINT PROJECT_ASSIGNMENT_maw_PK PRIMARY KEY (Employee_SSN, Project_Number),
CONSTRAINT PROJECT_ASSIGNMENT_maw_EMP_FK FOREIGN KEY (Employee_SSN) REFERENCES EMPLOYEE_maw(SSN_Number) ON DELETE CASCADE,
CONSTRAINT PROJECT_ASSIGNMENT_maw_PROJ_FK FOREIGN KEY (Project_Number) REFERENCES PROJECT_maw(Project_Number) ON DELETE CASCADE);

Reference no: EM133694881

Questions Cloud

Should social media sites have the right to locate : Should social media sites have the right to locate where you are at all times or as a user should you have the right to turn off those services?

Reduced oral food consumption capacity : Reduced Oral Food Consumption Capacity and Distaste for Nasogastric Tube Feeding are linked to Reduced Nutritional Intake.

Which phase of the kill chain are you mitigating : As part of your response to a network intrusion, you revoke a set of compromised user credentials. Which phase of the kill chain are you mitigating

How does applying statistical techniques for measuring : How does applying statistical techniques for measuring and controlling reliability, maintainability, and availability contribute to quality assurance

Create the sql code to insert the data : Create the SQL Code to insert the data for each of the tables in the database provided in the pictures. I will provide the SQL code used

What is pulmonary ventilation : What is pulmonary ventilation? What functions does the nose perform? What structures perform/contribute to these functions?

Coding denial or abstracting the correct codes : As a coder, there are times we feel frustrated with resolving a claim, coding denial or abstracting the correct codes.

Create three 1gb thin provisioned disks : Create three 1GB THIN PROVISIONED disks for your VM and rescan the SCSI adapter to enumerate the disks on vmware

Analysis of health policies or legislation : Analysis of health policies or legislation to address the issue: What policies have been proposed to address this issue?

User Account

All Pages