Question: 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
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
Step by Step Solution
3.48 Rating (151 Votes )
There are 3 Steps involved in it
To create tables without any problems first we need to identify and create the parent tables and the... View full answer
Get step-by-step solutions from verified subject matter experts
