Database Design : Take a crack at designing a simple database for A Small Dentist Office. To keep it simple, please exclude any financial or billing information. So build a simple database that keeps track of patient information and appointments. Keep this very simple, maybe 4 tables.

Part I: First determine the entities. The entities will be the tables. For example in an employee database the entities might be: an Employee, a Dept. These would then become the tables.the Employee table and the Dept table. Once you have come up with your 4 tables, move on to Part II.

Part II: Design each table. Tables must include:

Appropriate column names

Data type for each column

Whether a column can be null or not

Indicate any Primary Keys and Foreign Keys.

Indicate any relationships with other tables