Write down the CREATE TABLE query to create the WORKS_ON table. (Include primary key and foreign...

  

Transcribed Image Text:

Write down the CREATE TABLE query to create the WORKS_ON table. (Include primary key and foreign key constraints in the create table query) Consider the following database schema of the "Company" database. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation WORKS ON Essn Pno Hours DEPENDENT Essn Dnum Dependent_name Sex Bdate Relationship Write down the CREATE TABLE query to create the WORKS_ON table. (Include primary key and foreign key constraints in the create table query) Consider the following database schema of the "Company" database. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation WORKS ON Essn Pno Hours DEPENDENT Essn Dnum Dependent_name Sex Bdate Relationship

Answer rating: 100% (QA)

To create tables without any problems first we need to identify and create the parent tables and the... View the full answer