Information Systems with Computing

Design and implementation of a hybrid (Relational/XML) database system of your choice.

Assessment Brief

Module Title: Advanced Databases
Module Code:  
Module Leader:  
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%
Issue Date: 12-02-2018
Hand In Date: 17-04-2018
Planned Feedback Date: May 2018
Mode of Submission: Online via Moodle

 

Every student must submit their assignment on Module

Assignments will not be accepted via Email. You must submit your assignment on the due date.

 

ASSIGNMENT OBJECTIVES:

 

  1. To synthesise the skills learned in this module for the design, development and implementation of a hybrid database system.
    1. To design a hybrid XML/Relational database system
    2. To implement a hybrid XML/Relational database system
    3. To demonstrate a hybrid XML/Relational database system

 


 

Details of assignment brief

 

Total:100 Marks(Weighting:50%)

 

You are required to develop 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:

 

  • Background of your chosen system.Scope including business requirements.                                                                                                         (8 marks)
  • A list of business rules for the system (at least 4must be implemented).                         (8 marks)

 

  • A database model for the hybrid database system. The model (relational schema) of your database must fulfil the requirements of 3NF. It must be based on an Entity Relationship Diagram (ERD) for the database application using the ER/EER modelling techniques (include a minimum of 4 strong entities displaying all the relationships with cardinalities and all constraints. At least one entity must contain an attribute with XML data type.                                         (10 marks)

 

  • Critical evaluation of your database design, highlighting the strengths and weaknesses.                                                         (4 marks)

 

  • Report must be well-structured with Conclusions and Bibliography. Screenshots and explanation must be provided where required. (5 marks)

 

Note: All code must be included in appendix.

 

Completed Database System (55 Marks)

 

Develop a SQL Server database system based on the schema developed as part of the assessment. Your database must include the following:

 

  • Tables with relationships using some referential integrity constraints. There should be a minimum of 4 substantial tables and any number of smaller tables that you require to implement your database. Tables should be linked using an appropriate method in SQL Server.   Each table must have a minimum of 5 test records per table.  In your report explain which referential integrity constraints are used and why?                                                                                               (10 marks)

 

  • At least one table with an appropriate field with the proper use of XML data type. Justify the use of XML in the chosen scenario,                                                                                                                                                                                                              (8 marks)

 

  • Queries to meet the business requirements.  The queries that meet business requirements must include the following:
  1. data from two or more tables.
  2. aggregate data based on certain criteria.
  • data based on certain patternand uses EXISTS/NOT EXISTS
  1. generating XML document from SQL records.
  2. retrieving data logically from a field with XML data type as well as data from fields from other data types.
  3. updating data in a field of XML data type.
  • retrieving data using IN keyword
  • Any other queries relevant to business requirements.

Note: All these queries must be developed as “Stored Procedures”. All stored procedures must use parameters.

                                                                                                                                (24 marks)[1]

  • Two triggers to demonstrate the implementation of business rules.

(8 marks)

  • Two Views to demonstrate the development of virtual tables and their advantages.

(5 marks)

Breakdown of Marks for Queries

  • Developing 8 queries without parameters/stored procedures that include the given features and the business requirements.                                                   (8 marks)                                                            
  • Developing stored procedures for the above queries.                                                                                                                                                                                    (12 marks)
  • Extra queries/stored procedures for remaining business requirements.               

                (4 marks)

(Total: 24 marks)

 

 

Demonstration (10 marks):

You are required to demonstrate your database system. As part of demonstration, it is expected that you answer all the relevant questions asked.

 

 

 


 

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,  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 good report writing skills Well-structured and well-written report with good specifications and data model with normalised schema 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.

Demonstration Very Weak demonstration with no knowledge/

understanding of the system

Weak demonstration showing little knowledge of different aspects of the system. Average demonstration showing some knowledge of relevant issues. Good demonstration showing good knowledge of the system and the relevant issues. Excellent demonstration showing excellent knowledge of the system andrelevant details.


 

General Assessment Submission Requirements for Students:

 

  1. Online assignments must be submitted no later than the stated deadline.

 

  1. All relevant provisions of the Assessment Regulations must be complied with.

 

  1. Extensions to assignment submission deadlines will be not be granted, other than in exceptional circumstances.
  2. Students are required to retain a copy of each assignment submitted, and the submission receipt.

 

  1. Assignments that exceed the word count will be penalised.

 

  1. Students are required to refer to the assessment regulations in their Student Guides and on the Student Website.

 

  1. Dublin Business School penalises students who engage in academic impropriety (i.e. plagiarism, collusion and/or copying). Please refer to the attached referencing guidelines for information on correct referencing.

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 www.library.dbs.ie.

 

 

 

 

[1] See Break down of marks for Queries.
Share if you Care!