The Daffodil Theatre Booking System

Only available on StudyMode
  • Download(s) : 53
  • Published : November 7, 2012
Open Document
Text Preview
KINGSTON UNIVERSITY

Faculty of Science, Engineering and Computing
CI 3116 – Advanced Database Systems

DESIGN EXERCISE
FINAL REPORT

Daffodil Theatre Booking System

Gabriel Delucis Hilal K0935109

15th May 2012
Table of Contents
Introduction1
Aim1
Objectives1
Conceptual Data Model1
Relational Data Model1
Implementation1
Conceptual Data Model2
Class Diagram2
Descriptions and Assumptions2
Discussion4
Relational Data Model5
Relational Data Model Diagram5
Data Dictionary5
Discussion8
Implementation9
Table Listing9
staff9
productions9
prices_level9
seats9
productions_prices9
performances10
customers10
cards10
bookings10
tickets11
members11
duties11
members_duties12
performances_duties12
Discussion13
Conclusion14
Appendix A – Queries for the Coursework Demonstration15
Query 1 – Details of each scheduled production (name, date, time, tickets available and prices)15
Query 2 – The management of ticket sales16
Query 3 – The production of a report detailing the customers with reserved tickets awaiting to be collected for a particular performance (tickets to be printed)17
Query 4 – The production of a summary of ticket sales for a particular production18
Query 5 – Details of the volunteers required for each performance of a production19
Query 6 – Details of when volunteers are available to help and the duties they can do19
Query 7 – Details of the volunteers who have been assigned to duties for a performance20
Appendix B – Constraints for the Coursework Demonstration21
Constraint 1 – NOT NULL21
Constraint 2 – CHECK21
Constraint 3 – UNIQUE21
Constraint 4 – DATA TYPE22
Constraint 5 – INTEGRITY22

Introduction
The Daffodil Theatre is a small provincial theatre, which has received funds to finance the building of a new large auditorium. The money will also be used to develop a computerised booking system to manage the whole process, from seat reservation to profit reports. In order to develop the request Daffodil Theatre Booking System, the assignment description was carefully read to ensure that all requirements were fulfilled. However, some assumptions have been taken to fill gaps where requests were not specified, allowing the achievement of a comprehensive system as reported in this document. Aim

The aim of this report is to describe the design decision, as well as any assumption taken during the different stages of the system’s development. Objectives
The reported is divided in three main sections: Conceptual Data Model, Relational Data Model and Implementation. Each section has the following objectives. Conceptual Data Model
* Identify the needed classes for the system;
* Recognise the relationships between the found classes;
* Solve any many-to-many association that might resulted; * Describe any assumption taken while identifying classes; * Discuss the design decisions when developing the conceptual model. Relational Data Model

* Convert classes into tables;
* Identify the primary key within the existing attributes; * Add or remove attributes if necessary;
* Recognise the associations between primary and foreign keys; * Describe any assumption taken when converting classes into tables; * Define the data type required for each attribute;
* Identify the required constraints for each attribute;
* Discuss the design decisions when developing the relational data model. Implementation
* Identify the chosen data types within the available Oracle data types; * Change the data types to be in accordance to Oracle;
* Implement the tables according to the relational data model; * Describe any assumption taken when implementing the tables; * Discuss the design decisions when converting the relational data model into Oracle CREATE TABLE statements.

Conceptual Data Model
Class Diagram

Descriptions and Assumptions...
tracking img