the relation POLICE_OFFICER (OfficerID, LastName, FirstName, Email, StationID, S

Question

the relation POLICE_OFFICER (OfficerID, LastName, FirstName, Email, StationID, StationPhone, CarID, CarModel)

FIrst i need the candidate keys

Second need the functional Dependencies break them down into new table

third the referential dependecy like officer ID in OFFICER must exist in officer id in STATION

here is the order it should look like

Relation : POLICE_OFFICER(OfficerID,LastName,FirstName,Email,StationID,StationPhone,CarID,CarModel)

1)Candidate Keys:

OfficerID,Email

2) Functional Dependency:

OfficerID -> LastName,FirstName,Email

StationID -> StationPhone

CarID -> Car Model

3)

POLICE_OFFICER (OfficerID,LastName,FirstName,Email)

STATION(StationID,StationPhone)

CAR (CarID,CarModel,OfficerID,StationID,Email)

Explanation / Answer

The question is not very clear because it seems after reading your question that you have answered your own question.

Relation : POLICE_OFFICER(OfficerID,LastName,FirstName,Email,StationID,StationPhone,CarID,CarModel)

1)Candidate Keys:

OfficerID,Email

2) Functional Dependency:

OfficerID -> LastName,FirstName,Email

StationID -> StationPhone

CarID -> Car Model

3)

POLICE_OFFICER (OfficerID,LastName,FirstName,Email)

STATION(StationID,StationPhone)

CAR (CarID,CarModel,OfficerID,StationID,Email)

If your have any specific question or have any other requirements, kindly update the question with the updated requirements and I will answer your questions.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.