Hot Spot Question: Explore the ERD and corresponding code to identify the error. Figure: Entity Relationship Diagram (ERD). Employee Employee number Department First name Last name Job title Dept number works Dept name in Dept location Dept number Instructions: Click on the keyword, entity (table) or attribute (column) name in the code below where there is a mistake: CREATE TABLE Department( DeptNumber INT NOT NULL AUTO_INCREMENT, DeptName VARCHAR(60), DeptLocation VARCHAR(5), FOREIGN KEY (DeptNumber) );
Hot Spot Question: Explore the ERD and corresponding code to identify the error. Figure: Entity Relationship Diagram (ERD). Employee Employee number Department First name Last name Job title Dept number works Dept name in Dept location Dept number Instructions: Click on the keyword, entity (table) or attribute (column) name in the code below where there is a mistake: CREATE TABLE Department( DeptNumber INT NOT NULL AUTO_INCREMENT, DeptName VARCHAR(60), DeptLocation VARCHAR(5), FOREIGN KEY (DeptNumber) );
Related questions
Question
Transcribed Image Text:Hot Spot Question:
Explore the ERD and corresponding code to identify the error.
Figure: Entity Relationship Diagram (ERD).
Employee
Employee number
Department
First name
Last name
Job title
Dept number
works
Dept name
in
Dept location
Dept number
Instructions: Click on the keyword, entity (table) or attribute (column) name in the code below where there is a mistake:
CREATE TABLE Department(
DeptNumber INT NOT NULL AUTO_INCREMENT,
DeptName VARCHAR(60),
DeptLocation VARCHAR(5),
FOREIGN KEY (DeptNumber)
);
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
