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.

Review the table definitions at right. When we launch FileMaker Pro we will recreate files which represent these tables. FileMaker regards each table as a separate file. We may add a few additional columns to some tables to hold values we will have the DBMS calculate for us (such as total cost/patient) but these fields will be the ones that require data entry.

Review them and then we will begin to use the DBMS to create this database.