Subject Computer Sciences Technology

Topic     Wirer’s Choice (additional for 8052637614)

Type      Essay

Level     University

Style      Harvard

Sources                15 mostly academic & Journals

Language             English(U.S.)


Dear Expert


*Your Writing style must be at University level

*Table of content needs to be included.

*Each one of the requirement below must be achieved all critically analysed with attention to detail TO ACHIVE THE HIGHEST MARK AVAILABLE FOR EACH.




Coursework Part 2:

Data Management (50% of the overall module coursework marks)



Learning Outcomes covered by this assessment


Explain the fundamental concepts of data modeling and database design and implementation

Translate process models and systems requirement models into a database design using class diagrams and entity relationship diagrams and write SQL statements for the definition, access and control of data

Evaluate different approaches to the storage and management of unstructured data such as images and multimedia data



Assessment Brief


Design and implement a database and then write a report to describe the development of this database based on a on the Raleigh Theatre Booking System case study provided for this part of the coursework.


Aim: the aim of the exercise is to enable students to investigate a business situation within the context of an organisation and then design and implement a database to support the data needs of the organisation under study.


Database Design and Development Requirements


Conceptual Design Stage


Design a class diagram that will capture the data and links capable of supporting the requirements outlined above. The figures provide some sample data to give you additional information on the kind of data you will need to store. The model needs to capture the data requirements in order for the system to work. You also need to develop a list of constraints and a list of assumptions.


Relational Design Stage


The class diagram will then be adapted into a relational model. A relational model consists of relations with attributes and their data types, primary and foreign keys.






Implementation Stage


The final stage will be to implement your design, using Oracle.


Convert your relational model into an SQL database.

Populate your database with some sample data

Test your database. You will need to consider testing the database to ensure that the database meets the information requirements of the system. You need to create and run SQL queries that produce the information required.

Coursework Report Requirements


Write a report on the analysis and design of the database required to meet the information requirements. The report should have the following structure:


Executive Summary


Chapter 1: Introduction – one page description of the aims and objectives of the report


Chapter 2: The Class Diagram with constraints and assumptions together a one page discussion of the major design decisions taken in construction of the model


Chapter 3: The Relational Model and a one-page discussion of major design decisions taken in conversion of the class diagram into a relational model


Chapter 4: The Implementation stage. Here you will include your CREATE TABLE statements.


Chapter 5: Conclusion/ Discussion (A critical evaluation of your final product and a review of the entire exercise).






Background on case study with clear aims and objectives of the report.




The Conceptual Data Model

Class diagram, constraints and assumptions

ВВ· Represents information requirements

ВВ· Good use of assumptions to justify modeling decisions

ВВ· Use of constraints to model features that cannot be represented by modeling features 20 MARKS




A one-page discussion of the major design decisions taken in construction of the conceptual model

ВВ· Considers modeling of areas where alternate representations are possible.

ВВ· Justifies the representation chosen to capture the data requirements




The Relational Data Model

Model showing the relations, attributes and data types, primary and foreign keys plus any constraints

ВВ· Should show relations and attributes with clear indication of primary and foreign keys.

ВВ· Resolve any generalization structures that cannot be supported by the relational model

ВВ· Consideration of constraints to model implementation of 1:1 relationships (if relevant) and constraints from the class diagrams. 20 MARKS



A one-page discussion of major design decisions taken in conversion of the class diagram into a relational model

ВВ· Considers changes that have been made to the design to fit the relational model, e.g. 1:1 relationships, many-to-many relationships, super/sub types

ВВ· Discusses the representation of participation conditions and constraints





Table Listings

ВВ· Requires SQL CREATE TABLE statements for each table together with any constraints – primary key, foreign key and check. 15 MARKS




A one-page discussion of major design decisions taken in conversion of the relational model into an Oracle database.

ВВ· For example, changes made to the design to improve database performance 5 MARKS




Critical evaluation of the final product and the entire exercise.   10 MARKS


Include here the criteria and if possible the weighting given to each criteria.

Spacing Double

Pages    10

Latest completed orders:

Completed Orders
# Title Academic Level Subject Area # of Pages Paper Urgency