Assignment front sheet

Qualification Unit number and title
Pearson BTEC HND Diploma in Computing and Systems Development Unit 33: Data Analysis and Design
Student name Assessor name

Date issued Completion date Submitted on
27/04/2015

Assignment title Hospital Information System-HIS
LO
Learning outcome
(LO) AC In this assessment you will have the opportunity to present evidence that shows you are able to: Task no.
Evidence
(Page no)
LO 1

Understand data models and database technologies 1.1 critically compare different data models and schemas
1
1.2 critically discuss the benefits and limitations of different database technologies

1.3 analyse different approaches to database design

LO 2 Be able to design and implement relational database systems 2.1
design a relational database system to meet a given requirement

2
2.2
build a relational database system based
on a prepared design

3

2.3 apply a range of database tools and
techniques to enhance the user interface
LO 3 Be able to use manipulation and querying tools 3.1 explain the benefits of using manipulation and query tools in a relational database system
4
3.2 implement a query language into the
relational database system

3.3 critically evaluate how meaningful data has been extracted through the use of query tools
LO 4 Be able to test and document relational database systems 4.1
critically review and test a relational database system
5
4.2 create documentation to support the implementation and testing of a relational database system

4.3 create user documentation for a developed
relational database system

4.4
explain how verification and validation has
been addressed
6
4.5 explain how control mechanisms have
been used
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully acknowledged.
Student signature: Date:

Assignment brief
Unit number and title Unit 33: Data Analysis and Design
Qualification Pearson BTEC HND Diploma in Computing and Systems Development
Start date 27/04/2015
Deadline/hand-in
Assessor

Assignment title Hospital Information System-HIS
Purpose of this assignment
To provide learners with the knowledge and skills needed to understand, design, query and implement database systems.
Company/Scenario:
You belong to a team of Database developers, who have been assigned to develop a database system for Hospital Information System (HIS), the database should contain the following:
a. Patient information like names, addresses, Unique Patient Numbers (UPN), Patient Medical History (PMH), the database could contain other patient information that may be deemed necessary.
The Patient Medical History (PMH) should contain among others the following relevant information regarding a patient; hospital admission and discharge date, reason of admission, blood group, the room and ward the patient stayed and the type of operation a patient undergo during the hospital visit.
b. The information of hospital staff like names addresses, employment dates, telephone numbers, Salaries among others must be included. The hospital staff that should be in the HIS is limited to Surgeons and Nurses.
c. The Surgeons are classified as Surgeons and Senior Surgeon called consultants, who supervises Surgeons during operation on any patient, but could also carry out some Surgeon role.
d. The Hospital Information System (HIS) must include wards, each ward is assign to a supervisory nurse, also each ward have been named according to the type of care like gynaecology, geriatric , paediatric, orthopaedic. These wards are made up of rooms with unique numbers.
The above specifications was obtained by your team during the requirement analysis stage of the SDLC, as was expected, this specifications might not be complete because it was given to your team by none IT experts, thus lots of reasonable and creative assumptions is expected from your team when developing the database.
[The above scenario is a basic guide, creative imagination and sensible assumptions is encouraged and will be awarded the maximum marks]
Task 1 : (LO1: 1.1, 1.2, 1.3 and M1) interim deadline (10/05/15) Word Limit (500-900)
Task 2 (LO2: 2.1, 2.2, 2.3 and D1 ) interim deadline (24/05/15) Word Limit (350-600) (Formative Assessment in Week 3)

Task3(LO3: 3.1,3.2,3.3,M2 and D2) interim deadline (07/06/15) Word Limit (450-850)
(Formative Assessment in Week 5)

Task 4 (LO4: 4.1) interim deadline (14/06/15) Word Limit (450-550)
Task 5 (LO4: 4.2, 4.3 and M3) interim deadline (21/06/15) Word Limit (350-650) (Formative Assessment in Week 7)
Task 6 (LO4: 4.4, 4.5 and D3) interim deadline (28/06/15) Word Limit (250-550) (Formative Assessment in Week 9)

Evidence checklist Summary of evidence required by student
Task 1
Documents showing: compare different data models and schemas

Task 2
Documents showing the: Design scenario with Normalisation and ERD of the database.

Task 3 Documents showing the: how to use manipulation and querying tools to assess your design and implementations and explanations.
Task 4 Document showing the: testing of the database with enough T-SQL
Task 5 Document showing the: documents prepare for the database systems
Task 6 Documents showing the explanations of verification, validation and functionality, reliability, consistency and performance.

Resources
DFD and ERD software
• Ms Visio
• SmartDraw

DBMS
• Ms SQL Server 2008 R2 Express with Management Studio

Text Books
• Auer D and Kroenke D – Database Concepts, 5th Edition (Prentice Hall, 2010) ISBN-10 0138018804, ISBN-13 978-0138018801
• Avison D and Fitzgerald G – Information Systems Development: Methodologies, Techniques and Tools, 4th Edition (McGraw-Hill Higher Education, 2006) ISBN-10 0077114175, ISBN-13 978-0077114176
• Chao L – Database Development and Management (CRC Press, 2006) ISBN-10 0849392381, ISBN-13 978-0849392382
• Howe D – Data Analysis for Database Design, 3rd Edition (Butterworth-Heinemann Ltd, 2001) ISBN-10 0750650869, ISBN-13 978-0750650861
• Ritchie C – Relational Database Principles, 2nd Edition (Thomson Learning, 2002) ISBN-10 0826457134, ISBN-13 978-0826457134

Website
a) www.freetutes.com/systemanalysis
b) www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx
c) www.geekgirls.com/menu_databases.htm
d) www.smart-it-consulting.com/database/progress-database-design-guide/

Achievement Summary

Qualification Pearson BTEC HND Diploma in Computing and Systems Development
Assessor name

Unit Number and title Unit 33: Data Analysis and Design
Student name

Criteria Reference To achieve the criteria the evidence must show that the student is able to: Achieved?
(tick)
LO 1
1.1 critically compare different data models and schemas

1.2 critically discuss the benefits and limitations of different database technologies

1.3 analyse different approaches to database design
LO 2
2.1
design a relational database system to meet a given requirement

2.2 build a relational database system based
on a prepared design

2.3 apply a range of database tools and
techniques to enhance the user interface
LO 3
3.1 explain the benefits of using manipulation and query tools in a relational database system

3.2 implement a query language into the
relational database system

3.3 critically evaluate how meaningful data has been extracted through the use of query tools
LO 4
4.1
critically review and test a relational database system

4.2 create documentation to support the implementation and testing of a relational database system

4.3 create user documentation for a developed
relational database system

4.4 explain how verification and validation has
been addressed
4.5 explain how control mechanisms have
been used

Higher Grade achievements (where applicable)
Grade descriptor

Achieved?
(tick)
Grade descriptor
Achieved?
(tick)
M1: Detailed explanation of the approach used and how is mapped to System Development Life Cycle (SDLC)?

D1:Evaluate the process involved
in the design of the “Hospital Information Database ” system by producing a complete Entity Relationship Diagram (ERD) on top”, you should use a specific notations (eg Crow foot or Chen’s)

M2: . Critically evaluate how meaningful data has been extracted through the use of query tools: To earn this score, the learner have to show if meaning full data was extracted from the designed database, or an appropriate explanations given why no meaningful data was not extracted.
D2: Ability to use more intensive querying like the following:
i. Group functions
ii. Sub-queries.
iii. others.
Must be shown by the learner.

M3: A statutory documentation for the database system must be produced: is a combinations of all the documents produced in task 5 D3: Critically discuss about the functionality, reliability, consistency and performance of your designed system.
Assignment Feedback
Formative Feedback: Assessor to Student
Action Plan

Summative feedback

Feedback: Student to Assessor
Assessor Signature

Date

Student Signature

Date