Question: number. Each certified firefighter has a unique fire - fighter number, a name, year of certification, home telephone number, and a rank ( firefighter ,

number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighters supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New Yorks fire departments and firefighters.

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!