Sherry Rzv
asked on
Need to check the ER diagram is correct
Hi, I am designing a database but am having issues with the Entity relationship diagram. A simple question. The company I am designing the database for has three staff types:
-Studio Manager
-Driver
-Sound Engineer
But I am not sure If my ER diagram is correct. Kindly view attachment ER-Diagram.docx
-Studio Manager
-Driver
-Sound Engineer
But I am not sure If my ER diagram is correct. Kindly view attachment ER-Diagram.docx
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thanks very much! excellent solution
ASKER
Here is what I have observed from the client:
Three staff members work at the client studios; including studio managers, drivers and sound engineers but some members of staff can be allocated to more than one studio. Every studio has a studio manager. The driver is given a van and these vans are under the responsibility of the drivers they are given to and not shared among drivers. Sound engineers ensure customers are provided with the right type of equipment for the music work that they want to do and that they can use it appropriately to get the best value out of it. Furthermore, each engineer oversees a certain number of customers so that to ensure that all the customers have a first point-of-call in case they have any problems. Also each engineer is responsible for a certain number of pieces of equipment which they closely look after. One more point to mention is that pieces of equipment are registered under a specific studio’s name so that a record is kept of which studio is ultimately responsible for it.
Thanks for your help and efforts