Create two tables in the practice database. Step by step The Employee table has the attribute: Emp_ID,
Fantastic news! We've Found the answer you've been seeking!
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 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.
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: