Question: Using an ER Diagram Using the attached diagram HumanResources and Person, answer the following questions. What is the primary key of the entity Person.Person ?

Using an ER Diagram

Using the attached diagram HumanResources and Person, answer the following questions.

  1. What is the primary key of the entity Person.Person?

  1. The entity Person.Person is related to which other entity(ies)?

  1. How many addresses may a single person have?

Zero Exactly One Zero or One to Many

  1. How many persons can have the same address?

Zero Exactly One Zero or One to Many

Using an ER Diagram Using the attached diagram

JobCandidate (Human Resources) JobCandidate Business Resume Medets Employee (Human Resources) Business NationalONUMDA LoghD Organizacionade Organizational Person Phone (Person) BEID 7 PhoneNumbe PhoneNumbeTypelo ModifiedDate PhoneNumberType (Person) Phone Number pelo Name ModifiedDate Job Tide Birth Date Marital Status Gender HereDets Business Entity (Person) Business row Medidace Vacation us Siddleave Hous | Person (Person) Busty PersonType NameStyle L EmployeePay History (Human Resources) 7 RateChanges rowguid Medfied Date Password (Person) Business Passwarah PasswordSalt rows ProName Dyrequency Medfasete Medited Date Business EntityAddress (Person) MiddName LastName Sut Address Emal Promotion Additional Contacts Demographics rogue Meetiedete AddressType (Person) Address TypeID Meeders Name reguld Megredare Department (Human Resources) Departmen Nemre GroupName Medfedete Employee Department History (HumanRes to Business Entity 7 Department Shit StartDate End Date Modified Date cc Business EntityContact (Person) Business Ency Personi 7 Contacte rowguld Medited Date Email Address (Person) Business Email AddressID Email Address rowguld Modedete Address (Person) State Province (Person) Starovci Stanovrescade Country Region Code On State Province Name Textary roguid Medited Date Sales Person (Sales) Business Ency Territory Sale Quote Bonus Commissioner Sale YTD SalesLaster rowguid Modified Date ContactType (Person) - Cantealipala Name Moded Date Stara Province Postal Code Spatiallocation row us MestedDace Country Region (Person) CoureRegion Code Name ModifiedDate JobCandidate (Human Resources) JobCandidate Business Resume Medets Employee (Human Resources) Business NationalONUMDA LoghD Organizacionade Organizational Person Phone (Person) BEID 7 PhoneNumbe PhoneNumbeTypelo ModifiedDate PhoneNumberType (Person) Phone Number pelo Name ModifiedDate Job Tide Birth Date Marital Status Gender HereDets Business Entity (Person) Business row Medidace Vacation us Siddleave Hous | Person (Person) Busty PersonType NameStyle L EmployeePay History (Human Resources) 7 RateChanges rowguid Medfied Date Password (Person) Business Passwarah PasswordSalt rows ProName Dyrequency Medfasete Medited Date Business EntityAddress (Person) MiddName LastName Sut Address Emal Promotion Additional Contacts Demographics rogue Meetiedete AddressType (Person) Address TypeID Meeders Name reguld Megredare Department (Human Resources) Departmen Nemre GroupName Medfedete Employee Department History (HumanRes to Business Entity 7 Department Shit StartDate End Date Modified Date cc Business EntityContact (Person) Business Ency Personi 7 Contacte rowguld Medited Date Email Address (Person) Business Email AddressID Email Address rowguld Modedete Address (Person) State Province (Person) Starovci Stanovrescade Country Region Code On State Province Name Textary roguid Medited Date Sales Person (Sales) Business Ency Territory Sale Quote Bonus Commissioner Sale YTD SalesLaster rowguid Modified Date ContactType (Person) - Cantealipala Name Moded Date Stara Province Postal Code Spatiallocation row us MestedDace Country Region (Person) CoureRegion Code Name ModifiedDate

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 General Management Questions!