Answered step by step
Verified Expert Solution
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.
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 dateStep 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