The system we will create is a simple patient record database. We will employ four tables to create a system that will allow us (in English):

To track a patients admission to the hospital and the tests/procedures employed for each visit. We will also demonstrate the power of the DBMS to calculate simple costs and produce a "bill."

While simple, this model represents the means by which larger systems are created and can be enhanced with the addition of columns and other tables quite easily.

We will examine the table column definitions (the database schema) for the tables and then launch FileMaker Pro to build the database.

The Patients Table will contain data about an individual. Each individual has a unique ID that "follows them" throughout their hospitalization.

The Admissions table will contain a new entry each time a patient is admitted to the hospital. Since one patient may have go to the hospital more than one this will be a one to many relation.

The Tests Table contains a list of all the tests and procedures offered by the hospital.

The Test Results table will contain an entry for every test or procedure given to a specific patient. Since one patient can have many tests and one test might be done on many patients this will represent a many-to-many relationship between Patients and Tests.