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

1 Expert Approved Answer
Step: 1 Unlock

Creating the Employee Table CREATE TABLE Employee EmpID INT NOT NULL EmpName VARCHAR25... View full answer

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!