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

Question

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 date

Explanation / Answer

Cardinality:

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---