1 / 8

Database Design & Implementation Workshop 4 – Drawing ER Diagrams

Database Design & Implementation Workshop 4 – Drawing ER Diagrams. Draw Degree, Type & Participation diagrams that depict each of the following relatively simple ‘real-world’ situations: A member of staff must work in a department, and there are many members of staff in each department.

caesar-ashley
Download Presentation

Database Design & Implementation Workshop 4 – Drawing ER Diagrams

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design & ImplementationWorkshop 4 – Drawing ER Diagrams • Draw Degree, Type & Participation diagrams that depict each of the following relatively simple ‘real-world’ situations: • A member of staff must work in a department, and there are many members of staff in each department. • Several buses can park in the garage, and each bus may cover any number of routes. • Each producer is in charge of several plays and there are several actors appearing in each play. At any one time an actor may be involved in more than one play. • An operator can work on many machines and each machine has many operators. Each machine belongs to one department, but a department can have many machines.

  2. M <=Works 1 Department Staff Member Provides Work Spaces => A. A member of staff must work in a department, and there are many members of staff in each department. M Department Staff Works in Staff 1

  3. Garage 1 Can accommodate => Is parked in=> M covers => Bus/Rou Bus Team 1 M <= Driven By M Is part of => Covered by => 1 Route Driver 1 B. Several buses can park in the garage, and each bus may cover any number of routes.

  4. B/R M M 1 1 Route Bus M M M 1 1 Garage B. Several buses can park in the garage, and each bus may cover any number of routes.

  5. C. Each producer is in charge of several plays and there are several actors appearing in each play. At any one time an actor may be involved in more than one play. Acts in => 1 M M 1 Actor Act/Play Play <= Has M Produces => <= Has 1 Producer 1 M 1 M M 1 In charge=> Has => Producer Play Pl/ Ac Actor <= run by <= Stars in

  6. C. Each producer is in charge of several plays and there are several actors appearing in each play. At any one time an actor may be involved in more than one play. Acts in => 1 M M 1 Actor Act/Play Play <= Has M Produces => <= Has 1 Producer 1 M 1 M M 1 In charge=> Has => Producer Play Pl/ Ac Actor <= run by <= Stars in

  7. D. An operator can work on many machines and each machine has many operators. Each machine belongs to one department, but a department can have many machines. Department Operator 1 1 Belongs to => has => <= works on M M <= used by Op/Ma Machine M 1

  8. D. An operator can work on many machines and each machine has many operators. Each machine belongs to one department, but a department can have many machines. M M Ope+Mac 1 1 M Ope Mac M M 1 Dep

More Related