each city. A factory produces many models of car and many types of part although each type of part is produced at one factory only. A UNIVERSITY A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of courses. All teaching staff is attached to departments, each staff member belonging to a unique department. (Note: see how many meanings you can assign to this ambiguous sentence). Every course is composed of subcourses. Some subcourses are part of more than one course. Staff may teach on many subcourses and each subcourse may be taught by a number of staff. Draw an entity-relationship model for this example. Show both cardinalities and optional ties. An Organization A department employs many employees, but each employee is assigned under one department. Some employees are not assigned to any department. A division operates many departments, but each department is operated by one division. One of the employees manages each department, and each department is managed by only one employee. Project An employee can work on several projects at the same time. Each employee belongs to one department and has one manager within the department. Each project has a start date and a finish date and a
number of employees assigned to it. One employee is assigned as project manager. Projects are identified by a Project Code but there is a requirement to list all projects due to finish in a certain week. Most projects are carried out for a single customer although there are some internal projects for which there is no client. At any one time a client may have several projects under way. The company has about 100 customers each identified by a customer number. PDI Corner PDI Corner is a child daycare centre. A parent registers their child or children at the school using a registration form. A parent can submit more than one registration form. Each room in the daycare is assigned an age group. For example an infant is under 1 year of age and toddlers are from 1 to 3 years of age. A child is assigned to a room based on their age and availability of space. A room may be assigned one or more employees. An employee can only be assigned to one room. The minimum number of
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '14
- Computer Graphics, Entity-relationship model, mail order database