Introduction to Business Databases
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
INFS1603
Introduction to Business Databases
Team Assignment (Part B)
SDN Early Learning and Care Centres
1. Overview
For this project, you will be assessed on:
(1.) Two written reports (Part A and Part B)
(2.) Implement a database system using Oracle in Part B
(3.) Video presentation in Part B
• The individual assignment (Part A) is worth 20% of the marks of the course.
• The team assignment (Part B) is worth 25% of the mark of the course. Part B is
to be undertaken in groups of four (or three to fit) students, all of which must be
from the same tutorial class.
Team Assignment (Part B) is the focus of this document.
2. IMPORTANT NOTE on File-Sharing Websites – Please read
There are some file-sharing websites that specialise in buying and selling academic
work to and from university students.
You should be aware that you would be committing plagiarism if you download a
piece of work from these websites and present it as your own either wholly or
partially. For more information about Academic Integrity and Plagiarism, please click
here.
If you upload your original work to these websites, and if another student
downloads and presents it as their own either wholly or partially, you might be
found guilty of collusion — even years after graduation.
3. Key Dates
What? When?
Part A Released Week 2.
Assignment Part A Due: Submission
of assignment written report
Ms Word file submission via Moodle on or before
Monday 4 March 2024, 11.59am (Week 4)
Part B Group Formation Groups of 3 (or 4 to fit), Week 5 tutorial
Part B Progress Check 1 Week 8 Tutorial (1 Mark)
Part B Progress Check 2 Week 9 Tutorial (1 Mark)
Assignment Part B Due: Submission
of assignment written report
Ms Word and ZIP file submission via Moodle on or
before Monday 15 April 2024, 1.00 pm (Week 10)
Pitch video due Ms Word submission via Moodle on or before
Monday 15 April 2024, 1.00pm (Week 10)
Pitch video presentations Week 10 tutorials (pitch videos will be played in
class followed by Q/A)
These file-sharing websites may also accept purchase of course materials, such
as copies of lecture slides and tutorial handouts. By law, the copyright on course
materials (including this assignment brief), developed by UNSW staff in the
course of their employment, belongs to UNSW. It constitutes copyright
infringement, if not plagiarism, to trade these materials.
4 | P a g e
4. Aim of the Assignment
This course project (individual assignment + team assignment) addresses all the Learning
Outcomes of the course. By completing each requirement of this assignment, you will
demonstrate your mastery of the principles and practice of Business Databases:
▪ CLO1: Apply conceptual and relational database modelling methods.
▪ CLO2: Design and implement database systems.
▪ CLO3: Apply Structured Query Language to access and update databases.
▪ CLO4: Carry out professional teamwork.
▪ CLO5: Discuss professional responsibilities and ethical issues regarding databases.
The aim of the assignment is to design an Entity Relationship (ER) diagram for SDN
Early Learning and Care Centres at UNSW.
5 | P a g e
5. Case Study – SDN Early Learning and Care Centres
Consider the following scenario for SDN Early Learning and Care Centres at UNSW.
UNSW employs around 7,000 individuals, spanning academic and administrative roles. It's
worth mentioning that every employee of UNSW, including those in casual positions, has the
privilege of enrolling their children in the SDN Early Learning and Care Centres. This facility,
while situated within UNSW's premises and dedicated to addressing the childcare needs of
the university's working parent community, is managed by an external third-party. This setup
ensures that although the childcare centre is geographically located within UNSW, its daily
administration and operational tasks are the responsibility of the separate organization.
The SDN Early Learning and Care Centres stand out as a beacon of excellence in providing
top-tier childcare services to kids ranging from 6 months to 5 years of age. It is designed to
support UNSW’s working parents by offering a secure and enriching environment conducive
to children's learning, playing, and overall growth. To enhance its operational efficiency and
childcare management capabilities, the centre has embarked on the development of an
intricate database system. This initiative aims to refine and optimise the management of
various centre operations.
In your capacity as a database designer, you have been assigned the critical task of
developing the database schema to meet the comprehensive needs of the centre. The
envisioned database is expected to adeptly manage essential aspects of the childcare centre's
functionality, including but not limited to the enrolment of children, monitoring their attendance,
organising daily activities, overseeing billing and payment processes, and maintaining a
current inventory of necessary supplies. The goal of this advanced database system is to
facilitate seamless communication among parents, staff, and the management team, thereby
guaranteeing an orderly and effective childcare environment for the benefit of the children and
their families. This strategic enhancement is projected to elevate the quality of care and
streamline the operational framework of the Childcare Centre.
There are several key regulations and situations to bear in mind regarding the database for
the SDN Early Learning and Care Centres at UNSW:
- Priority for child enrolment at the SDN Early Learning and Care Centres is given to the
employees of the childcare centre. It is crucial to note that employees working for the
third-party organization managing the centre are not classified as employees of UNSW
and therefore do not possess a zID. SDN employees receive a 20% discount when
enrolling their children at the centre.
- Beyond the children of its employees, the Childcare Centre is also open to children
whose parents are part of the staff at UNSW. Starting from 2020, the centre expanded
its enrolment policy to include children of Postgraduate Research students, such as
those pursuing PhDs and Masters by research.
- The demand for spots at the Childcare Centre often exceeds availability, leading to a
lengthy waiting list. To secure a spot in advance, parents can fill out a pre-enrolment
form upon learning of the pregnancy. While UNSW employees are generally subjected
to a first-come, first-served basis on the waiting list, precedence is given to those
parents who already have a child enrolled at the centre, although they must still join
the waiting list and notify the centre upon pregnancy.
6 | P a g e
- Should an employee leave UNSW, they are presented with the option to continue their
child's enrolment at the Childcare Centre at an additional cost of $45 per day.
- In cases where both parents are employed by UNSW, the child's enrolment is
registered under the name of just one parent; there is no requirement for dual parental
enrolment in the database.
- The database must contain information about each child enrolled, including details of
their parents/guardians, emergency contacts, and any pertinent medical information
such as allergies or health conditions. UNSW is responsible for supplying the childcare
centre with an updated list of staff zIDs on a consistent basis.
- The childcare centre has the capacity to accommodate up to 227 children across 6
different classrooms, with each room having a set limit on the number of children it can
hold. For instance, the Koala room, designated for children aged 2-3, has a maximum
capacity of 40 children. The database is required to monitor the daily attendance of
both children and assigned staff members in each classroom, including time logs of
arrivals and departures. Additionally, it must detail the scheduled daily activities, meals,
and nap times for each room.
- Essential information about the childcare centre’s personnel must be stored in the
database, including the various qualifications a staff member may hold, ranging from
Certificate III to Diploma levels.
- Furthermore, the database is tasked with the management of billing and payment
records for the childcare services of each child, encapsulating details on billing cycles,
fees, and payment statuses.
- For parents who are eligible for the Australian Government Child Care Subsidy (CCS),
the subsidy is paid directly to the Childcare Centre in accordance with government
regulations. Parents are responsible for covering the remaining balance, often referred
to as the "gap fee," themselves.
- It is also important to keep an inventory of the centre's supplies, including toys and
childcare materials, ensuring each classroom is adequately equipped.
- In response to inflation and the escalating cost of living, the childcare fees have seen
an increment of $10 per day at the beginning of 2023, followed by an additional
increase of $10 per day at the onset of 2024. It is essential for the database to be
updated to reflect these changes accurately.
Consider these scenarios as examples of the varied situations that can arise in the context of
the SDN Early Learning and Care Centres at UNSW:
- Alex, a Research Assistant at UNSW since 2017, and Kim, a project coordinator at
UNSW, welcomed twins in 2018. Understanding the benefits offered by UNSW, they
were keen to enrol their twins at the Childcare Centre. Given the centre's policy and
the high demand for spots, Alex and Kim submitted pre-enrolment forms immediately
after discovering their expectancy. In 2020, they were delighted to have both children
accepted into the centre. In 2023, they found out that one of the twins has asthma,
while the other requires a gluten-free diet due to an allergy. The centre is committed
to accommodating the special needs of these children, ensuring their health and safety
are prioritized. Accordingly, these essential health and dietary requirements are
recorded in the database, enabling the centre to provide the necessary care and
support for each child. This ensures that all staff are aware of and can properly manage
the asthma care plan for the affected child, as well as adhere to the dietary needs of
the child who requires gluten-free options.