Purpose: Develop an EEOC compliance system for Wilco Construction Company (the Wilco EEOC Information System)

As a team perform the following steps: Step 1> Read the case and answer the 5 questions below, as a team.

What are the problems at Wilco?

What do you believe to be the most pressing problem facing Wilco? Why?

What do you think should be the scope of the current project? Why?

What do you think should be the priorities for implementing the system and its applications? What makes you think so?

What other kinds of applications might be built into the system in the future?

Step 2> Analyze the information in this case and generate the requested deliverables:

Create a data model using Entity-Relationship diagrams for the Wilco Construction Company EEOC system. The E-R diagrams should be complete, in that they represent real things in the Wilco environment. You should also specify entities, entity descriptions, attributes, attribute descriptions, unique identifiers, and relationships (and their descriptions). The deliverable will be your E-R diagrams and supporting documentation.

Create a set of leveled (context level, level 0, and level 1) data flow diagrams (DFDs) for the Wilco Construction Company EEOC system. You should also specify processes, data stores, external entities, and data flows. The deliverable will include your set of leveled data flow diagrams, along with any explanatory documentation.

Step 3> Design the input forms and reports for the Wilco Construction Company EEOC compliance system. The form should be aesthetically pleasing, and should insert all relevant information into the appropriate tables (entities) in the database. For example, you should make certain that your input form makes appropriate use of zoning and navigation flow between fields.

The output reports should be designed such that they describe fully the appropriate information. The form should be neat, clean, easily readable, and communicate clearly and quickly the relevant information.

Step 4> Build tables, forms and reports in Microsoft Access. The database tables, reports, forms, and any processing logic should be implemented fully in the database. This includes (but is not limited to) assignment of foreign keys, data types, and field lengths. This also includes the assurance of referential integrity between your tables. At the completion of this assignment, everything should be done except the programs and interfaces.

Wilco Construction Part 1 2

Bonus Step 5> Build the necessary programs and interfaces that will enable end-users to fully and effectively use the Wilco EEOC compliance system. This step of your term project requires you to put everything together, and make it work. This includes building things like combo boxes and menus. It also means doing up documentation to explain to the user how to use the system. It also involves using test data provided to develop sample reports.

There are several elements to this part of term project. First, you will be required to generate queries to create tables with the information necessary to create the EEOC reports. This will require that you draw out the appropriate data, do some calculations, and then make this available to the Access report generator to print out the reports. The final report should have all of the general data and proper formatting. Dont worry about the graphics from the original case, but do put in nice headers, boxes, etc., where applicable. The report should take the project ID and description from the project table. Youll need to build another query to do this. These are, by the way, the correct numbers for the Adams County Project. You should generate a report for all three projects. The reports should include all of the information Mary would need to fill out the EEOC compliance reports.

What you should do is imagine that Wilco has submitted the reports generated from your database to the EEOC, and they have been noted. Because regulations require that Wilco use 10 percent women and 10 percent minorities on all projects and in all skill classifications.

Can you send me an email address where I can send the file because I'm trying to upload the file as a email attachment, but it wouldn't let me do it.