Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

Creating the Employee Table CREATE TABLE Employee EmpID INT NOT NULL EmpName VARCHAR25... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant Navathe

7th Edition

0133970779, 978-0133970777

Students also viewed these Databases questions

Question

What does the Journal in HDFS refer to? What data is kept in it?

Answered: 1 week ago

Question

Outline an algorithm for deletion from a B + -tree.

Answered: 1 week ago