Determine the primary and foreign keys

Assignment Help Operation Management

Reference no: EM133961588

Question

Entity sets and attributes:

Station: StationID, location, Region

Staff: MinStaffing, Apparatus

Equipment: Apparatus, StationID

1. Determine the Primary and Foreign Keys.

2. What relationships exist between them and explain why. (Explain why there are one-to-one / many-to-one relationships in your database plan)

3. Draw the ER diagram you have described above. Note: what you describe in parts i) and ii) should be reflected in your diagram.

Reference no: EM133961588

Questions Cloud

Company changes to hi-speed shredder and sells : What is the monthly profit or loss if the company changes to the Hi-Speed shredder and sells 60,000 bags per month?

Did jfk act responsibly in the cold war : Did JFK act responsibly in the Cold War (e.g., Bay of Pigs, Berlin Crisis, Cuban Missile Crisis, Vietnam)? Explain briefly.

Do you think that world war 2 could have been avoided : Do you think that world war 2 could have been avoided? If so, how? If not, why? Do modern-day conflicts and war compare with WW 2 in this respect?

Do you think globalization is making people around the world : Do you think globalization is making people around the world more alike or more different? What are the implications?

Determine the primary and foreign keys : Determine the Primary and Foreign Keys. What relationships exist between them and explain why.

How did islam expand so rapidly and so extensively : In spite of the early divisions, how did Islam expand so rapidly and so extensively (i.e. How did it spread so fast and so far)?

What are cultural values of italian mafia of mezzogiorno : What are the cultural values of the Italian Mafia of the Mezzogiorno?

Insurance company chain with central inventory operation : Thomas Smith is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation.

How can risk assessments be used to promote resiliency : How does mitigation planning improve a community's resiliency? How can risk assessments be used to promote resiliency?

User Account

All Pages