Coursework Assignment Brief

Semester: E14

Module Code: PC 206

Module Title: Database Management Systems.

Programme BSc (Hons) CS Programmes

Level: Level 5

Awarding Body: University of Plymouth

Module Leader Aykut Ozkaya

Format: Report

Presentation: Yes

Any special requirements: Your work should be demonstrated professionally on MySQL Workbench CE.

A report format including a title page, introduction, table of contents, appropriate headings, conclusion, references, and an appendix showing any other relevant information.

Word Limit: 2000 words (+-10%)

Deadline date for submission: Should be submitted to turnitin by TBA

Learning outcomes to be examined in this assessment Appreciate how and why database systems are specified, designed, normalised, implemented, tested, maintained and used, and how these functions are related to an organisation’s requirements.

Analyse the effectiveness of data base systems and the factors that give rise to limitations in their use.

Explain languages employed, the networking possibilities available and the control procedures operated to ensure they serve their purpose.

Percentage of marks awarded for module: This assignment is worth 50% of the total marks for the module. To qualify you must submit a formal report to turnitin and present your practical database solution using MySQL Work Bench CE.

Assignment Task:

Introduction:

This Assignment is based on a Scenario. Its approach is incremental, with tasks to be submitted for review by a given date. It is designed to go through a relational database design, build (code), test and document cycle.

A written report of a working database solution in SQL using MySQL Work Bench CE and a 10-minute demonstration– this is worth 50% of your total mark for the module.

Scenario:

A large General Practitioners (GP) surgery require an information system to help record data in order to assist management in decision making for both routine and life-threatening ailments.

The proposed system should:

Store surgery details in MySQL (Patients, medical staff, prescriptions, hospital referrals and any other relevant data)

Incorporate meaningful data search capabilities to identify patients’ referrals, prescriptions and any other data sets that would facilitate the smooth running of the practice.

For this project you will develop a suitable database model. Your database must be in the 3rd normal form at a minimum and must not allow data duplications/redundancies. In addition, you must populate your database with data suitable to run complex queries on involving more than one table. Moreover, you must create two appropriate user views and triggers help automate regular tasks and manage user views. Furthermore you must give advice on how to keep this database safe from accidental and deliberate online threats which may lead to significant data loss in you written report.

Total marks for assignment: 100

Assessment criteria

Assessment criteria Explanatory comments on the assessment criteria Maximum marks for each section

Content, style, relevance, originality Relevant, accurate content, demonstrating research, as required by Assessment Task below. Emphasis will be placed on originality; work which is clearly student’s own. 40 %

Constructive analysis, introduction, conclusion Demonstration of a clear understanding of Database management systems, and mechanisms for protecting data. 40 %

Format, referencing,

bibliography Structured report, Harvard style referencing 10 %

Presentation Professionally presented with full group participation 10 %

Total 100 %

Assessment Tasks for Database Development (the following must be clearly documented in your report)

Identifying Entities, Attributes, Relations and Identifiers

Entity Tables Normalisation

(Must be at the 3rd normal form at a minimum)

E-R diagram

Creating Required number of tables with the required relations between entities and populating them by using SQL.

Constructing complex queries involving minimum of two tables using SQL language

(you must be able to demonstrate an ability to use natural join and execute complex queries including aggregates)

Two appropriate user views and triggers

Security features and advice

Project Report

The Project Report should have the following structure and content: You are required to upload this report through the turnitin via student portal as a group submission (each member must submit this report individually). It is important to check your Student ID numbers before upload.

Cover Page:

Assignment title, module code, full name and student number, as well as submission date.

Table of Contents:

A list of all of the sections, headings and sub-headings, appendices and figures should be provided as well as all page numbers as clearly as possible.

Introduction:

This should show that you have understood the brief and that you will cover everything required.

Findings and Analysis:

This is the substance of your report. Headings and sub-headings should be used to clearly indicate the different sections. You are required to include your UML diagrams, SQL code, query results, triggers, user views and safety features in the body of your report. The content must be explained briefly. You must show evidence of testing at every stage of your development cycle.

Conclusions:

These draw out the implications of your findings. Deductions are based on the facts described in the findings and analysis. Remember not to include any new material here.

References:

All the named sources you have quoted from or reproduced in your report. Please use The Harvard System for all references. Details for the Harvard System can be found on the student portal.

Appendices:

Detailed documentation of points made in the findings. Examples include: technical data, questionnaires, letters sent, tables, charts or leaflets. An appendix contains supplementary information that you consider to be too long, complicated or not quite relevant to include in the main section of the report, but is still relevant to your reader. Each appendix should be referred to in your text. You should not include something as an appendix if it is not discussed in the report.

Presentation:

You are expected to present your final working database in 2 students per group during last week of term in a given presentation time slot. Your presentation will take about 10 minutes with another 5 minute of questioning time about the suitability of your design proposal. Please make sure you book a time slot as early as possible. An online booking form will be made available for you to book a presentation time slot. You must enter your student details correctly to the booking form. You will not be given assistance during the assessment so it is advisable for all the groups to test their practical work beforehand. You are free to use your own laptop but you must make sure you have right type of adaptors for your device so you can project your demonstration to the classroom display. Alternatively a laptop with a working copy of MySQL workbench CE will be provided on the condition that requested one.