DataBase for Dental Clinic

Author: Andres Penas Palmeiro

Final Project for the Module "Database Design & Development" of the H.Dip in Computer Science in Software Development - GMIT

Version: 1.0 (Jun 2020)

Summary

Design and implementation of a MySQL Database to manage appointments and payments for a Dental Clinic. A set of Triggers enforce business rules.

Languages

SQL

Usage

Order to import:

1. CreateDataBase
2. Triggers
3. PopulateDataBaseAndViews (Optional)

Special Features

Triggers enforcing business rules

"PopulateDataBaseAndViews" offers a mock population of the database to allow the user to see an example of how it works.

ERD available.

License

MIT License. See "LICENSE" for further information.

Contact Information

[email protected]