ISM 4212 Exam 6     

Situation:

A manufacturing company has several factories in different locations. An information system to schedule maintenance on machinery is needed. The information system is to have a centralized database at the main office and PCs for entry of data and listing of factory-specific reports in each factory.

Each machine has a schedule for preventive maintenance. In addition special maintenance requests are used to schedule maintenance for breakdowns and degradations.

Each maintenance operation requires 1, 2, or 3 maintenance workers and among those maintenance workers there must be some special skills (such as electrician, pipefitter, etc.)

Each maintenance operation has an expected amount of time that it will take, and that time is for all of the workers assigned to the operation.

Maintenance workers only work in a single factory. Machines are in a single factory.

Information requirements:

In each factory:

1. List the maintenance operations to be performed today in this factory and which workers are to be assigned to each operation and what the expected times are. This will include operations scheduled for today as well as operations scheduled for previous days which were not completed.

2. List the maintenance operations which appeared in report 1 above for yesterday but were not completed yesterday.

3. List the work done and total hours by each worker in this factory.

4. List the work done and total worker hours for each machine in this factory.

At the main office:

1. List all maintenance operations performed in each factory between two dates (entered at report run time) and include the number of worker hours which each required. List in order by date within factory.

2. List all maintenance operations which were performed 2 or more days after the date for which they were scheduled in each factory. List in order by date within factory.

For the above situation: Develop a DFD for the above situation. Develop an ERD for a database which supports ONLY the information requirements specifically listed and numbered. Include all of your attributes on the ERD. Denote PKs by underline. You need only use 1:1 and 1:N relationships (decompose any M:N into 1:N). Show the partition of the database and the processing between the server and the clients.

Submit all work via email to wleighwleigh@yahoo.com. Attach a word file with the ERD and DFD. Have your name and "exam 6" in the subject line of the email.