Requirement of Database for scheduling Process
Database is required mostly in case where our data has more number of records that we were unable to handle them in correct way in manually. While in our case the reason is not only increasing number of record but also to make a perfect schedule so that each course has a teacher assign to it with a valid teacher ID and print schedule so that no one could erase. Forms which created with the help of tables in database help to improve input, view and edit data in case of trainer or course data validation. For scheduling process the output through a report can be viewed as database is develop which help to view schedules in better way.
Relationship between course and trainer tables help to improve integrity of data.
Advantages
Making schedules through database are Capable of handling increase records as number of trainers and courses can increase in future with the growth in organization. It also allows involving relationship between tables which prevent duplication in allotment of resources. Database will help us to get Correct schedules and make easy for reporting purpose another advantage is Referential integrity which help to get each course assign a teacher with valid employee ID. Database lead to less chances of error due to its properties which results in long term benefits as data base can be used for years to come. From database we can also get schedules with the help of reports in printable form so no manual alteration is possible. Database increase efficiency of schedules as we will have better idea of any trainer if he is free and we can give him any course which also leads us to more productivity.
Disadvantages
Implementing database requires many resources which include hardware resources such as computer, printer and server while software resources such as MSACCESS and windows are also required. A developer of database is required to develop database and amend it as per requirements an inputter is also essential to input data and get schedules from database. These all resources make database an expensive approach. In case of small size data it takes more time than making Schedules manually. System failure can cause loss of data which can lead to blackout and important database could be a history in seconds. Due to data base relations it is less flexible and has not many options to edit the architecture.
Referential Integrity
Referential integrity in database is a concept that relationships between tables must be consistent. As one table have a foreign key which link to another table, Referential integrity Force that we cannot add a new record to the table of foreign key unless a corresponding record of the linked table is updated. Referential Integrity help in satisfying data links from one table to another by checking data and its type to be consistence. By linking tables in such way Referential integrity helps us to avoid mistakes. Setting up Referential integrity is easy in MSACCESS and it has greater benefits.
Works Cited
Chapple, M. (n.d.). databases.about.com. Retrieved from about.com: http://databases.about.com/cs/administration/g/refintegrity.htm
Groh, R. (2011). Access 2007 Bible. Hoboken: John Wiley & Sons.
Roman, S. (2002). Access Database Design & Programming. Sebastopol: O'Reilly Media.