Notes for week 4

For this week's links click here.

Discussion of The Final Project Interface

Tuesday each group will bring a complete description (with drawings (can be hand drawn or screen dumps)) of the interface you will use in your final project. Each group will present this interface to the class with reasons for each choice. The class will write final specifications for the final project after viewing the interface designs. Every group will meet the specifications decided at this time.

Hierarchy of Classes in a Database

  1. The Problem

    2. You will design a database for the problem you get by clicking here . The completed program can be downloaded by clicking here .

  2. Design The Classes

    3. The design of the classes is left to the reader as an exercise. You will note a few things here. First there are two types of rentals, so you will need two rental classes. You will build a rental class hierarchy as shown here:

    While the base class seems to be an abstract class, you will need to provide some real functions in this class since it will be the generic class of the database. There will in fact be a table for this class that allows you to create an abstract factory for retrieving specific rentals from the database. This rental table will contain

    Rentals are made to customers, so you should have a customer class. Each customer will be contained in an object, and that object will have a reference id in the database. This id must be included in the Rental classes.

  3. Design And Create an Access Database

    4. To see actual database design and creation click here . Remember to add this database to your list of shortcuts in BDE.

  4. Create The Program

    5. This discussion in week 5 .