You are working as a corporate trainer for a large organization. There are several other trainers and many training topics. The company has grown quickly and scheduling has become difficult. The current method for scheduling involves writing trainer names and courses on a dry-erase board. This has led to issues with trainers changing the assignments in their favor and accidental erasure of some course assignments. Write a 4-5 page paper in which you:
- Discuss the requirements needed to build a database for the scheduling process.
- Describe the advantages and disadvantages of moving the schedule to a database.
- Create a graphical representation of your proposed database environment.
- Explain how referential integrity can prevent mistakes in a database. Do the advantages outweigh the difficulty of setting it up?
- Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements:
-
- Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number, last name, first name, department, and email address. The course data should include: course number, course name, trainer employee ID number, and training location.
- A relationship should exist between the tables.
- Use referential integrity to make sure that each course has a valid trainer assigned to it.
Your assignment must:
- Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
- Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
- Include charts or diagrams created in Excel, Access, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted.
The specific Course Learning Outcomes associated with this assignment are:
- Create requirements for a system through a formal technique that enables a productive change in a way the business is conducted.
- Use contemporary CASE tools in process and data modeling.
- Use technology and information resources to research issues in systems analysis and development.
- Write clearly and concisely about Systems Analysis and Development topics using proper writing mechanics and technical style conventions