Question: Question 9 The following clause is specifying a 1 :M relationship between the DEPARTMENT ( CODE , NAME ) and EMPLOYEE tables: CREATE TABLE EMPLOYEE

Question 9
The following clause is specifying a 1:M relationship between the DEPARTMENT(CODE, NAME) and EMPLOYEE tables:
CREATE TABLE EMPLOYEE(
ID INT PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
DEPARTMENT_CODE NOT NULL,
FOREIGN KEY (DEPARTMENT_CODE) REFERENCES DEPARTMENTT(CODE));
Right
Wrong

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 Accounting Questions!

Q:

Trudy Henry presently operates a retailing proprietorship with a December 31 year end and makes $160,000 of net income for tax purposes annually. She is thinking of incorporating her business and has...

Q:

DATABASE: Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) ); CREATE TABLE staff( STAFFID INT PRIMARY KEY, FNAME VARCHAR(30), LNAME VARCHAR(30),...

Q:

DATABASE | PLEASE NEED YOUR OWN ANSWER! DO NOT PROVIDE ME COPIED OR OTHER PEOPLE ASNWER...THANKS Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) );...

Q:

CREATE TABLE users ( ID int PRIMARY KEY NOT NULL, NAME varchar(50) NOT NULL, DOB varchar(20) NOT NULL, ADDRESS varchar(100) NOT NULL, PHONE varchar(20) NOT NULL, SALARY float NOT NULL, PASSWORD...

Q:

I also publish the same provided with the picture to make your work easier. i appreciate your work. Thank you very much SHORT SUMMARY: Provided the queries as per the requirement. Given the add...

Q:

For the hw2 database, write a SQL query (or queries) to find the average number of sections offered per term by the Computer Science department. Your query should be based on the design of the...

Q:

For the hw2 database, write a SQL query to find the names of all departments whose department office is in the Robinson building. Your query should be based on the design of the tables, not the...

Q:

Hey guys I'm stuck on this section of sql server and what the solution would be. Below the questions I've pasted the MyGuitarShop databse. I hope this helps you guys out thank you again for you help....

Q:

Inserting a new employee 30, F, Null, 9 into the Table Employee. If it is rejected, explain. EMPLOYEE( EmployeeID, EmployeeName, SupervisorID, DepartmentID) PROJECT (ProjectID, EmployeeID)...

Q:

Use the next two tables: CREATE TABLE patient( patientID INTEGER PRIMARY KEY, fname CHAR(25), lname CHAR(25), gender CHAR(1), phone INTEGER ); CREATE TABLE account( accountID INTEGER PRIMARY KEY,...

Q:

CREATE TABLE DEPARTMENT( DEPTNO INT PRIMARY KEY, DEPTNAME VARCHAR(30) ); INSERT INTO DEPARTMENT VALUES(1,'COMPUTER SCIENCE'); CREATE TABLE PROJECT( PROGNO INT, PNAME VARCHAR(30), DEPTNO INT, FOREIGN...

Q:

A historian researching the influence of society on the spread of communicable disease began to speculate on what it would be like if AIDS had appeared at a different time. What differences might one...

Q:

Janis Evans decided to open an editing service in Vernon. Record the following transactions in the transaction analysis charts: A. Janis invested $3,000 in the editing service from her personal...

Q:

Throughout this course, you have worked together as a team to complete a project using the AMPS model. Your team has taken on the role of the analyst hired to provide recommendations to a local real...

Q:

Lab 9 - Regression, for any significance tests, assume 95%CI, =.05 USE LOGICAL THINKING, IF THE MODEL (our ANOVA) IS NOT SIGNIFICANT WE CANNOT REPORT THE FINDINGS. WE WOULD RE-RUN DATA, TRIMMING ONE...