In this paper we discuss the details of ascheduler program according to the following rubrics; 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:
¶ … Building a Database for Use in Scheduling Process
The scheduling of various activities can at the moment be with the help of computer programs that implement the methodology of the critical-path method (CPM) (Choo et al.,2008). The requirements for building a database for use in scheduling process are numerous. For instance, each scheduler must have a separate database for storing information persistently. The server administrator and the application scheduler have the choice as well as location of database to be used. The performance of a scheduler is largely affected by the performance of the chosen database. If more tasks per second are needed then the scheduler daemons can be run on larger and faster systems.
According to Johnson (2004), the requirements for building a database for use in scheduling process include ensuring the following;
Availability
The scheduler database and service must be configured have a high level of availability by either creating the necessary scheduler resources in duplicates as well as by creating the resources in clusters.
Recovery as well as delays
The scheduler must be designed in order to take care of overloads caused by insufficient resources.
Scalability
The database to be used in handling the scheduler events must be scalable. This can be achieved by making it able to run redundant scheduler events that can communicate to different databases or tables. This enhances the availability of the scheduler program.
Security
The process of designing the scheduler database must take into account issues of task security as well as the administration security. The task security specifies who the tasks runs as while the administrator security dictates the people who can modify the tasks.
Performance
In regard to performance, the scheduler database and program must be optimized to effectively load as well as run tasks with very minimal level of database interaction.
The advantages and disadvantages of moving the schedule to a database
Advantages
The use of a database-based scheduler allows for scheduling of a project in segments and thereby making very large projects very manageable.
Allows for high level of interchangeability
One of the main benefits of project scheduling tools is that it allows for the easy management of the notifications as well as organizations for the tasks. This includes all elements of the project such as project phases and deadlines. Changes can also be made within the project scope with this tool.
Provides project tracking capabilities
Whenever there is a project that is being managed by several employees, the use of a collaborative tool that is based on a database driven design allows for the easy tracking of the project progression. If one is constantly missing deadlines then they can be reminded by the software. The top performers can also be easily identified and possible rewarded. The weak links in the project management team can therefore be identified.
Disadvantages
Cost
The cost of implementing and running the project management software can be high and this could be a major disadvantage.
Complications
The scheduling tools/programs are noted to make simple projects very complicated.
A graphical representation of your proposed database environment
How referential integrity can help in prevent mistakes in a given database.
You’re 76% through this paper. Sign up to read the full paper.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.