Question: Create two tables in the practice database. Step by step The Employee table has the attribute: Emp_ID, Emp_Name, Office_ID, where the Office_ID is used as
Create two tables in the practice database. Step by step
The Employee table has the attribute: Emp_ID, Emp_Name, Office_ID, where the Office_ID is used as the foreign key linking to the Office table.
The Office table has the attribute: Office_ID, Location.
Please set up the data type constraints according to common sense. For example, the Emp_ID should be not null and the Emp_Name should be a character type variable.
Please take the following two screenshots:
Your code in the SQL code editor
Expand each table in the Schemas view in MySQL Workbench, then take a screenshot.
Step by Step Solution
3.46 Rating (149 Votes )
There are 3 Steps involved in it
Creating the Employee Table CREATE TABLE Employee EmpID INT NOT NULL EmpName VARCHAR25... View full answer
Get step-by-step solutions from verified subject matter experts
