Advanced Databases
MSc Information Systems with Computing
Assessment Brief
Module Title: |
Advanced Databases |
Module Code: |
B9IS100 |
Stage (if relevant): |
Award |
Assessment Title: |
Design and implementation of a hybrid (Relational/XML) database system of your choice. |
Assessment Number (if relevant): |
1 |
Assessment Type: |
Advanced Databases |
Restrictions on Time/Length : +/- 10% |
N/A |
Individual/Group: |
Individual |
Assessment Weighting: |
50% of the Total Grading |
Details of assignment brief
(IT SHOULD BE ORIGINAL WORK OF THE STUDENT)
Total: 100 Marks (Weighting: 50%)
You are required to design and implement a hybrid database system for a company/business of your choice (real or virtual). As part of your assessment, you are required to submit the following:
Report: (35 Marks)
The report must include the following:
Note: All code must be included in the appendix.
Completed Database System (45 Marks)
Develop a SQL Server database system based on the schema developed as part of the assessment. Your database must include the following:
Innovation (20 marks)
Use of any other features to enhance the usability of your database system.
For Example, Put Front End and Create formatted reports to enhance usability of the system and mention it in your report.
Assessment criteria
Criteria/Mark |
< 40 |
40 - 49 |
50 - 59 |
60 – 69 |
70 + |
Report |
Insufficient or incomplete report with poor or incomplete data model, no/poor normalisation, poor explanation, poor formulation of requirements, etc. |
Some but insufficient and poorly written report with poorly developed data model, some normalisation and explanation not enough to meet the requirements |
Sufficient explanation with data model with normalised schema that solves problem but lack of attention to formulating business requirements and good report writing skills |
Well-structured and well-written report with good specifications and data model with normalised schema. Appropriate requirements for the business. |
Excellent solution to problem proving originality, creativity and evidence of research – very well written with excellent data model and normalised schema to 3NF |
Database System |
Less than four tables not properly structured, queries without the required features that do not meet business requirements, no/poor implementation of stored procedures/Views/Triggers |
Four substantial tables demonstrating some structure of data, queries with some required features that meet some business requirements, some implementation of stored procedures/Views/Triggers |
Four substantial tables with some structure, queries with most required features that meet most business requirements, implementat-ion of stored procedures/Views/Triggers but not as appropriate as required |
Four substantial and structured tables with appropriate records queries with all required features that meet the business requirements, good implementation of stored procedures /Views/Triggers,etc. |
Excellent database system that meets all the business requirements, required features, etc. |
General Assessment Submission Requirements for Students:
What is referencing and why is it necessary?
Please follow this link to the Harvard Style Referencing Guide - all referencing is required in this format.
http://issuu.com/dbslibrary/docs/harvard-referencing-guide/1?mode=a_p
The School of Arts generally use APA Referencing , information is available under DBS library guides on http://www.library.dbs.ie .
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services