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

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

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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Use the tables in your schema. Display the employee last name and employee id along with their manager's last name and manager number (in other words the manager's employee id) for all employees...

Use the tables in your schema. Display the region, the employee first and last name (separated by a space) in a column titled "Employee Name", and the employee's salary. Only include employees with a...

The salary analysis information you provided in question is helpful; however, the company would like to add to their analysis. They would like to know the average salary of employees in departments...

Use the tables in your schema. Create a report showing: First name, last name, and salary of all of the employees who make over $11,000. Use a column command to format the salary to have a heading of...

***Pleace reach out to me at 859-398-9677 for SQL Script. Thanks*** Chapter 7 Homework To create MSU Human Resources database, use MSU_HR_MySQL script provided. Before answering the questions, be...

Chapter 7 Homework To create MSU Human Resources database, use MSU_HR_MySQL script provided. Before answering the questions, be familiar with the database structure by referring to the database...

can you please help with this Cross Joins and Natural Joins 1 . Create a cross - join that displays the last name and department name from the employees and departments tables. 2 . Create a query...

DATABASE PROGRAMMING WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS List all the department IDs in the company, and the amount of highest income (salary plus commission_pct * salary), lowest income...

Question 1) Show all employees whose current job has a max salary of at least 9000. Display the employee id, full name, job title and max salary. Sort the results by the largest max salary first....

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Name three types of work-piece features that are well suited to using a rotary positioning device.

Rob, a student, asks your help in understanding some characteristics of a corporation. Explain each of these to Rob. (a) Separate legal existence. (b) Limited liability of stockholders. (c)...

Someone who invests in the Vanguard Index 5 0 0 mutual fund could most accurately be described as using which approach? Multiple Choice 1 6 : 5 7 Fundamental analysis Active management Passive...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. Discuss how business strategy influences the type and amount of training in a company.

3. Describe the strategic training and development process.

10. Microsoft Corporation