Question
Department(Department-Id,Dept_Name,Location). Note : the table is defined such hat two Departments cannot have the same Department-Id. employee(emp-ID,Department-Id,emp-Last_name,emp-Firstname, email-Id,Contact-No) emp-Id is a primary key. There is
- Department(Department-Id,Dept_Name,Location).
Note: the table is defined such hat two Departments cannot have the same Department-Id.
- employee(emp-ID,Department-Id,emp-Last_name,emp-Firstname, email-Id,Contact-No)
emp-Id is a primary key. There is also a foreign key Department-Id which points to the Department table.
Add three records for each table using sequence object
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
101 Database Exercises Text Workbook
Authors: McGraw-Hill
2nd Edition
0028007484, 978-0028007489
