Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Study the ERD and write down your comments/recommendation for each cardinality. LOCATIONS number(4) PK varchar2(50) LOCATION_ID LOCATION NAME STREET_ADDRESS varchar2(40) N POSTAL_CODE DEPARTMENTS COUNTRIES DEPARTMENT

Study the ERD and write down your comments/recommendation for each cardinality.

image text in transcribed

LOCATIONS number(4) PK varchar2(50) LOCATION_ID LOCATION NAME STREET_ADDRESS varchar2(40) N POSTAL_CODE DEPARTMENTS COUNTRIES DEPARTMENT ID DEPARTMENT NAME MANAGER ID LOCATION ID number(4) PK varchar2(30) number(6) N FKOCITY number(4) N FK COUNTRY_ABBRV char(2) PK COUNTRY NAME varchar2(40) varchar2(12) N oREGION ID STATE_PROVINCE varchar2(25) N COUNTRY_ABBRV) N FK PROVINCE varchar225) N REGIONS REGION ID REGION_NAME varchar2(25) number PK EMPLOYEES EMPLOYEE_ID FIRST NAME LAST NAME number(6) PK varchar2(20) N varchar2(25) varchar2(25) PHONE NUMBER varchar2(20)N O HIRE_DATE varchar2(10) FK number(8,2) N COMMISSION PCT number(2,2) N MANAGER ID DEPARTMENT ID number(4) N FK number(6) N FKo JOB_HISTORY EMPLOYEE ID number(6) PK FK DEPARTMENT ID number(4) PK F varchar2(10) PK FK PK START DATE END varchar2(10) PK JOB TITLE varchar2(35) MIN SALARY number(6) N MAX_SALARY number(6) N TE date

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

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

3. Describe the strategic training and development process.

Answered: 1 week ago

Question

10. Microsoft Corporation

Answered: 1 week ago