Subject Computer Sciences Technology
Topic Wirer’s Choice (additional for 8052637614)
Sources 15 mostly academic & Journals
*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
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.
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:
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
ВВ· 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.
Latest completed orders:
|#||Title||Academic Level||Subject Area||# of Pages||Paper Urgency|