1
DATABASE DESIGNS
Table of Contents
Assignment 3 Part B – Develop a Database Prototype....................................................................2
Database Development................................................................................................................2
Database Design..........................................................................................................................2
Sample Data.................................................................................................................................2
Proof of Testing...........................................................................................................................6
Testing of Primary key............................................................................................................6
Testing of Foreign key.............................................................................................................7
Deletion Testing.......................................................................................................................8
SQL Queries................................................................................................................................9
Club facilities...........................................................................................................................9
Members list for a class.........................................................................................................10
Counting club members.........................................................................................................10
Personal trainers.....................................................................................................................11
Information about club managers..........................................................................................12
Trainers specialized in weight loss........................................................................................13
Members statistic...................................................................................................................13
Club timetable........................................................................................................................14
Bibliography..................................................................................................................................16

+13062052269

info@desklib.com

Database Prototype Designs

Contribute Materials

Related Documents

TRA Race Entry System Author: Name + Number.

Database System and Design