|
Product Information:
|
Database Principles
3rd Edition |
Employee |
|||
DVD Hire Shop |
|||
Training Courses |
|||
Job Agency |
|||
Correspondence College |
Please note that each database will open in separate window. (Please note you can alternatively download all the files as a single Winzip file - see below.)
All the databases contain sample data for each of the component tables which helps to clarify how the data in the tables relates to each other and enables aspects of the database, such as forms and queries to be tested. However, note that some of the database tables are 'time sensitive' in the sense that in normal use there would be regular updating of the database corresponding to events in the application environment. This has the consequence that data entered into the table will 'age' rapidly and will soon become invalid or inappropriate. A typical example is in the Training Courses database which deals with courses scheduled to run at specific dates in the future. After such dates have passed, further bookings for these course/dates are not valid. In the descriptions given below, such cases are identified. Generally, some sample data is provided but it is likely to be out of date. Is it recommended that all the rows of such tables be deleted and new data entered, preferably by a form if available.
In addition to the above, two further Access databases are included. These are Assets.mdb which is used in Web Databases chapter (chapter 10) and Calculations.mdb. The latter demonstrates how calculations can be performed on Access forms and show the difference between bound and unbound textboxes.
Assets |
|
Calculations |
Please note that each database will open in separate window.
Alternatively, you can download all of the files as a single Winzip file.
Notes on each database
Employee
This is a very basic system included because it is used as the basis for the SQL tutorial in Hands On section 1. The SQL scripts provided enable Oracle or MySQL tables to be created or students may choose to use the Access version.
DVD Hire Shop
In addition to the required database tables, the Access version includes a number of forms, queries and reports to illustrate some of the features of these in the context of a practical system. The Hire table information is time sensitive and may need to be 'refreshed' by entering new hire transaction via the Issue DVD form.
Training Courses
In addition to the required database tables, the Access version includes a number of forms, queries and reports to illustrate some of the features of these in the context of a practical system. The Booking and Schedule tables are time sensitive and should be refreshed by deleting current rows, entering a new set of Schedule rows then entering a series of Booking transactions via the Booking form.
Job Agency
The Job Agency system is used as an example in Chapter 3 part 3 in the description of normalisation.
Correspondence College
This system is the largest in the set of case studies and possibly needs a fair amount of explanation.
The system allows for each student being enrolled on one or more courses and hence Student and Course are connected by an relationship entity, Enrolment.
Each course consists of one or more modules. It is assumed that each module belongs to a single course. If this were not the case, then the relationship Course – Module would need to made many to many.
Students are required to submit Assignments which are related to the modules.
Assignments are marked by external tutors. On receipt by the College, they are grouped into batches (of up to 10 assignments) and despatched by post to the appropriate tutors. The tutors mark the assignments and return a record of results to the College.
The Access version contains just table definitions. This could be used as the basis of a fairly large implementation project for students.