Question: Which table in the model does not have a primary key field? Data Model for Police Departments Barry illiams 10th. February 2009 DatabaseAnswers.org Associates pF

 Which table in the model does not have a primary key

Which table in the model does not have a primary key field?

Data Model for Police Departments Barry illiams 10th. February 2009 DatabaseAnswers.org Associates pF person id PF associate_person_id Shifts Officer Shifts officer id shift id date started date sended shiftid PR person id - date association started address id start time end time eg B Watch, Traffic FR title_code first_name middle_name last name date of_birth date in date out phone_number cell_phone email address Titles title code Addresses address id line 1 - eg Mr.,Mrs.,Ms P officer_id deptcode Incident Outcomes - F rankcode outcome code outcome descriotion eg Case solved zip_postcode state_province_county country badge_number date became officer other officer details other_person_details Ranks Incident Status status code status_description eg Under Investigation People in_Incidents pF person id PE incident id rankcode rank short_name rank description - eg Sgt., Officer, Lt. Incidents - P incident id role code outcome code status code F type_code Incident_Types date time incident started date time incident ended type-code type description eg Case, Felony Roles Departments dept. code fI parent dept code role code other_details eg Suspect 1, Victim1 eg Investigating Officer Officers inIncidents officer id PE incident id FR role_code

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!