Each dinner serves many members and any member is allowed to attend Each dinner

Each dinner serves many members and any member is

This preview shows page 4 - 5 out of 5 pages.

Each dinner serves many members and any member is allowed to attend. Each dinner has an invitation. This invitation is mailed to each member. The invitation includes the date of the dinner and location. Each dinner is based on a single entrée and a single dessert. This entrée and dessert can be used again for other dinners.
Background image
DINNERMEMBERpreparationhasINVITATIONentreedessertdatelocationattendancemailOFFICEEMPLOYEEassignmentofferPROJECTSCUSTOMERworkskilltimeintensitymanageSeniorJuniorPromo-datecountryExercise 12: Model the following situation using ERD. Include appropriate attributes.A consulting company maintains offices in several countries. Each office can have several employees assigned, each employee is assigned to one office. Customers offer projects to the company, each project is from one customer. Employees work on the projects for a given time and intensity, and can work on more than one project at the same time. A project will have several employees assigned. Each employee has a list of skills. An employee can be either a senior or junior consultant (who has a date for promotion set), a senior one manages several junior one, each junior is assigned to one senior. For each project, there can be several invoices with different amounts and dates.
Background image

You've reached the end of your free preview.

Want to read all 5 pages?

  • Fall '14
  • Relational Database, Reorder level, Entity-relationship model, Stock Control, preferred supplier, new entity types

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture