Question

EMPLOYEE Remark Column Name EmployeeNumberINT Primary Key Yes No CHAR (25 CHAR (35 CHAR 25 NUMERIC INT CHAR (12 CHAR Name in the DEPARTMENT table Position No Number in the EMPLOYEE table Su OfficePhone EmailAddress No No No es Sample data from the EMPLOYEE table is shown below: Employee FirstName LastName Department Salary Supervisor OfficePhone Emaidadress 50-324-1453

these are all tables please see the tables and questions are mentioned below

please see that all and I need answers asap
please write proper answer it's an easy task and don't take much time please do it fast
thanks in advance

Answer 1

1.

CREATE TABLE EMPLOYEE (

EmployeeNumber INT PRIMARY KEY,

FirstName VARCHAR(25) NOT NULL,

LastName VARCHAR(25) NOT NULL,

Department VARCHAR(35) NOT NULL,

Position VARCHAR(25) NOT NULL,

Salary DECIMAL(8, 2) NOT NULL,

Supervisor INT,

OfficePhone VARCHAR(12),

EmailAddress VARCHAR(50) NOT NULL,

FOREIGN KEY (Department) REFERENCES DEPARTMENT (DepartmentNumber),

FOREIGN KEY (Supervisor) REFERENCES EMPLOYEE (EmployeeNumber)

);

2)

CREATE TABLE ASSIGNMENT (

EmployeeNumber INT NOT NULL,

ProjectID INT NOT NULL,

HoursWorked DECIMAL(8, 2),

PRIMARY KEY (EmployeeNumber, ProjectID),

FOREIGN KEY (EmployeeNumber) REFERENCES EMPLOYEE(EmployeeNumber),

FOREIGN KEY (ProjectID) REFERENCES PROJECT(ProjectID)

);

3.

INSERT INTO DEPARTMENT VALUES ('Administration', 'BC-100-10', 'BLDG01-210', '360-285-8100');

4. INSERT INTO PROJECT VALUES (1300, '2017 Q3 Tax Production Plan', 'Accounting', 145.0, '08/10/17');

NOTE: As per HOMEWORKLIB POLICY, I am allowed to answer only 4 questions (including sub-parts) on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.