Skip to content

Latest commit

 

History

History
30 lines (21 loc) · 796 Bytes

README.md

File metadata and controls

30 lines (21 loc) · 796 Bytes

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

G00376379@gmit.ie