案例database UML案例database UML
image.png

CHI2550: Part B project Specification



Module Title: Modern Database Applications
Module Code: CHI2550
project Title: Portfolio
Module Leader: Dr. Colin C. Venters
Hand Out: Week beginning 15th January 2018
Report Hand In: Monday, 16 April 2018
Presentation Hand In: Friday, 27 April 2018
Assessment Weight: 50%
Assessment Type Report and presentation
Word limit: 3000 ± 10%
Feedback: Unilearn


project Background



The aim of this project is to model an underlying database(s) utilizing a range of attributes, data types, methods, visibility and relationships in the models where appropriate.



Learning Outcomes



Knowledge and Understanding



1.1. Critically analyse and evaluate competing data models and database technologies.



Skills



2.1. Produce effective designs for relational and non-relational databases using an appropriate design language.



project Aims



1. To allow student’s to demonstrate their knowledge in the analysis and creation of database management solutions.



2. To understand the significant role that data models play in the design of databases.



3. To compare different approached to modelling data using a variety of modeling techniques and approaches.



School of Computing and Engineering



Department of Informatics



project Objectives



You are required to produce a single report, which demonstrates your understanding of the problem space using the methods introduced during the tutorial sessions. The report should include the following elements:



Task 1: Analysis & Models



• Domain analysis;



• Data Models [70 marks];

i. Relational [10 marks];



ii. Object-Oriented (OO) [15 marks];



iii. XML/XML Schema (XSD) [15 marks];



iv. RDF/RDF Schema (RDFS) [15 marks];



v. PROV Model [15 marks].



(i) All models must conform to strict notation.



(ii) Draw the models using a standard modeling package of your choice i.e Visual Paradigm CE, MS Visio, MS Visual Studio, OmniGraffle etc.

• NB: MS Word is ‘not’ a modeling tool.



(iii) Include attributes, data types, methods, visibility and relationships in the models where appropriate.



(iv) Validate the XML/XML Schema data model using an XML Schema validator of your choice.



(v) Validate the RDF/RDF Schema data model using any RDF Schema validator of your choice.



(vi) Validate the PROV data model using a PROV validator.



(vii) For each of the data models created, provide a rationale as to why you designed each model in the way that you did.



[70 marks]


Task 2: Presentation



Prepare a 10 min presentation that compares and contrasts at least two of you data models:



o Level of understanding demonstrated [10 marks]; o Knowledge of theory [10 marks];



o  Reflection and critical analysis [10 marks].



[30 marks]


School of Computing and Engineering



Department of Informatics



Assessment Weighting



1. This is an individual project. No collaboration with other students or any one else is allowed.

2. This assessment is worth 50% of the module.



Total: 100 marks (50% weighting).



Report Submission Details



• Date: Monday, 16 April 2018.



• Time: 12:00 Midday.



• Digital submission: via Turnitin.



• Digital format: a single PDF document, which clearly states the student name and studentID.



• File naming for individual files should follow the convention of yourstudentID.pdf.



v Word limit: 3000 ± 10%.



v Course work that is submitted late will be automatically capped at 40%.



v Work submitted later than one week without approval after the deadline will be treated as a non-submission.



Presentation Submission Details



• Date: Friday, 27 April 2018.



• Time: 12:00 Midday.



• Digital submission: via Turnitin.



• Digital format: a PowerPoint presentation, which clearly states the student’s name and your studentID.



• File naming for individual files should follow the convention of yourstudentID.pptx.



v Course work that is submitted late will be automatically capped at 40%.



v Work submitted later than one week without approval after the deadline will be treated as a non-submission.



v Students who do not give the presentation will receive a zero (0) grade.



University of Huddersfield’s Guidelines on Academic Misconduct



Your work will be checked by software for plagiarism. If in doubt please consult the Student Handbook of regulations.