Databases

Database Management Course Notes

Use the listed exercises to develop further your understanding of computer based database systems.

Our teaching methodology with databases is to run limited classes (few sessions) discussing the ‘theoretical’ components of databases for students to have a grounding, and to continue with lab based exercises where the listed exercises are given to students.

The typical lab introduction format is as follows:

  1. The class completes together one SBS exercise. If you do not have a projection system, I have effectively used the SBS by drawing the dialog boxes etc on a blackboard while students following the notes. After the review of the exercise has been achieved together, students are assigned to complete the exercise on the computer.
  2. students are assigned an additional exercise to complete on their own.
  3. The class completes together (reviews) the previous exercise. Doing the exercise together, away from computers, pushes students to consider the theoretical issues of database manipulation as well as bringing up issues which they do not understand.
  4. The class completes together the next SBS, with an increased complexity. This process introduces new concepts as a group which allows the instructor to explore different methods of describing the new topics.
  5. repeat steps 2 onwards until the desired level of competence has been achieved

  Category Further Information.
  Terms and Definitions Provides a definition of ‘database’ and general terms that is encountered when using databases.
  SBS 1, SBS 2, SBS 3, SBS 4,SBS 5

SBS Introductory Step-by-step exercises in Microsoft Access.

SBS 1 introduces creating a new database and how to create new tables. The guide explains how to find the solutions for Exercise 1 and 2 from the exercise booklet.

SBS 2 - extends on the original exercises by introducing the use of Queries to find custom views of a database. The guide explains how to find the solutions for Exercise 7 from the exercise booklet.

SBS 3 - extends the use of queries. This introducing shows how to sort a table within the table view, and then how to perform more complex sorting through Queries. The introduction uses a database called PayMaster that should be used during the review of the guide.

SBS 4 - extends the use of Queries by performing queries on a database with more than one table. The guide shows how to make calculations using a query and how to formulate compound queries by using the logical operators AND and OR. The guide uses a database called PayMaster that should be used during the review of the guide.

SBS 5 - Creating a Report to view your data. This introduction also instructs how to manually create summary data (for example finding the total of figures displayed in a report.)

  Exercises This is a list of exercises to be used in class and as assignments for the study of using databases.
  Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quizes designed to reenforce with students their level of comprehending database terminology, concepts. Binary and ASCII questions are asked in later quizzes.
  Practical, Marking A Practical exercise taken from an exteranl examination students are required to take (1997). This exercise gives a good evaluation point of how the student has understood the concepts of databases and Microsoft Access and how well they can transfer this knowledge to outside problems.
  Practical 2 Another practical exercise, without a marking schedule.
  Exercise Solutions Sample Solutions to the above exercises, compressed here. Use a decompression utility such as WinZIP to extract the files once downloaded.

Select a topic to view the materials written on the topic.