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.)

Description

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.

 

PLEASE FOLLOW THE REQUIREMENTS BELOW

 

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).

 

 

MARKINGS

 

Introduction

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

5 MARKS

 

 

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

10 MARKS

 

 

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

10 MARKS

 

 

Implementation

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

 

 

Conclusion

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