Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 3 4 Given the data model shown below, please define the following: 1 ) Table names 2 ) Primary Keys for each table. If

QUESTION 34
Given the data model shown below, please define the following:
1) Table names
2) Primary Keys for each table. If the key is composite, please indicate.
3) Foreign Keys for each table and what table/field the FK relates to.
EMPLOYEE(EmployeeNumber, ELastName, EFirstName, EAddress, ECity, EZipCode, DepartCode)
DEPARTMENT(DepartmentCode, DeptName, DivisionCode)
DIVISION(DivisionCode, DivName, DivVP)
EPHONE(PhoneID, EmpNum, PhoneNumber, PhoneType)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions

Question

In Problems 120, evaluate each expression. 10! 6!

Answered: 1 week ago