Description

UNIVERSITY0f
TASMANIA
KIT102
INTRODUCTION TO DATA SCIENCE
Assignment

Ageing with Style Home Care
All submissions . tre through MyLO.
The m, rking rubric is av. ilable on MyLO, You shoula read the rubric before submitting your assignment
This assignment will take a lot 0T time. You have weeks to corng lete the work, but you need to start early
Task
You have been presented with the case study below. You need to turn tnis into a MySQL database. are the requirements.
Read the case study and develop an Entity-n elationship “iagram using the conventions for this nit This diagram needs to describe all of the business rules in the case study.
2. using this unit’s Entity-Relationship to Relational Schema Agorithm, convert your Entity- Relationship Diagram into a relational schema.
3. using MySQL create the database based upon your relational schema.
4. Enter fivo records into each of the relations that you have created in your MySQL database.
5. Correctly and appropriately comment your code so that it can be maintained by your client.
Submission Requirements
KIT102 Intl . duction
In a Word Document or PDF, submit your Entity-Relationship Diagram and relational schema
INCLUDING all of the steps involved in the conversion algorithm to MyLO. using Visio is recommended for the E-R Diagram, but any diagramming package, or a hand-drawn diagram includea as an image in your Word Document or PDF is acceptable.
2. In a separate text document, submit your file called Assignment.sql to MyLO in which you have recorded all of the MySQL code to create and populate your database.
Case Study
Ageing with Style Home Care provides personal care, gardening services and domestic cleaning services. Clients can access the services after receiving a diagnosis from their medical practitioner.
Diagnoses are identified with a diagnosis code, the medical practitioner ID and a description of the diagnosis.
Each medical practitioner provides one or more diagnoses, and each diagnosis is provided by one and only one medical practitioner. Medical practitioners are given a unique ID and the database also holds their name.
Each diagnosis accesses one or more services from this business, and each service is used for one and only one diagnosis.
Each service must be approved by the one and only one funding body. The funding body must approve one or more services. The funding body is identified with the funder ID, and some details are collected about the funding body.
The mobility testing facility generates zero or more mobility test results and mobility test results are generated by one and only one mobility testing facility.
KIT102 Introduction
Ageing with Style Home Care hopes that these business rules will help you design and implement a database that includes some sample data that is appropriately commented so that Ageing with Style’s in- house staff can further implement and develop the database.
a. seeks to gain, for themselves or for any other person, any academic advantage or advancement to which they or that other person are not entitled; or
b. improperly disadvantages any other student.
KIT102 Introduction