Database Design and Implementation

Running head: DATABASE DESIGN AND IMPLEMENTATION
Database Design and Implementation
Name of the Student
Name of the University
Author’s note:

1DATABASE DESIGN AND IMPLEMENTATION
Table of Contents
Enhanced Entity Relationship Diagram:.........................................................................................2
Database Entities:............................................................................................................................2
Script:...............................................................................................................................................5
Views:............................................................................................................................................18
Queries:..........................................................................................................................................19
Bibliography:.................................................................................................................................22

2DATABASE DESIGN AND IMPLEMENTATION
Enhanced Entity Relationship Diagram:
Figure 1: EERD of FIT CLUB Health Centre
(Source: Created by Author)
Database Entities:
Classes Entity:

3DATABASE DESIGN AND IMPLEMENTATION
Club Entity:
Manager Entity:
Facility Entity:

4DATABASE DESIGN AND IMPLEMENTATION
Clubfacilities Entity:
Classclub Entity:
Timetable Entity:

5DATABASE DESIGN AND IMPLEMENTATION
Trainers Entity:
Timetable Entity:
Script:
-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/