Question: write in sql and take screenshot of syntax that runs correctly Table Name: DEPT LOCATION Attribute Data Type Department Number INT Primary Foreign Department (DenN)

write in sql and take screenshot of syntax that runs correctly
write in sql and take screenshot of syntax that runs correctly Table

Table Name: DEPT LOCATION Attribute Data Type Department Number INT Primary Foreign Department (DenN) ON DELETE CASCADE Constraint NOT NULL Department Location VARCHAR(15) NOT NULL Foreign Table Name: PROJECT Attribute Data Type Primary Project Name VARCHAR(15) UNIQUE Project Number INT Project Location VARCHAR(15) Department Number INT Constraint NOT NULL NOT NULL Department (Den No) Table Name: PROJECT ASSIGNMENT XXX Attribute Data Type Primary Foreign Employee SSN CHAR(9) Employee (SSN) ON DELETE CASCADE Project Number INT Project (PNumber) ON DELETE CASCADE Hours DECIMAL (3.1) Constraint NOT NULL NOT NULL NOT NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!