Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an ERD using Lucid Chart ( Please give me a snap of diagram which will help me for drawing it not just the theory
Create an ERD using Lucid Chart Please give me a snap of diagram which will help me for drawing it not just the theoryfor the following description. Be sure to include
all necessary entities, attributes, and correct cardinality in relationships between
entities. Dont forget foreign keys.
Specifications
You have been asked to build a database for a daycare center called Little Ones
Daycare. The university database administrator needs to keep track of the
parentsguardians and children that attend the daycare center, the daycare center
employees, the rooms and computers at the centers facility, and the various
activities the center offers.
Little Ones tracks the first and last name of each guardian, as well as their phone
number, email address, and mailing address. The children at Little Ones are
dependents of their respective guardian. Each guardian may enroll several children
at the daycare center, although each child is dependent on only one guardian. Little
Ones tracks the first and last name of each child, as well as their date of birth.
Older children may be given special designations at the daycare center, including
room monitor and peer mentor. The task assignment of each room monitor and
the badge color of each peer mentor are tracked. If they would like, a child can be
both a room monitor and a peer mentor. Each room monitor is assigned one room
in which they perform their designated task. Each room might have one room
monitor that cleans whiteboards, puts toys away, or picks up stray litter.
Each child at the center is assigned to a room. Little Ones keeps track of each unique
room number, room name, and room capacity. Some rooms may not be used, but
every room can accommodate at least ten children.
The daycare center keeps records of its two types of computers, desktop
computers and tablets. Each computers unique serial number and purchase date
is tracked. Additionally, Little Ones tracks whether or not each tablet comes with a
keyboard. For each desktop computer, the center tracks whether or not it is
connected to the internet and if it has any age restrictions.
A room may have at most one desktop computer and each desktop computer has
a unique room assignment.
The daycare center keeps track of the data of its employees, including their first
and last name and email address. Little Ones hires employees as either teachers or
support staff and tracks teachers preferred age group and highest level of
education obtained. Support staff licenses are also recorded. Support staff are each
given a unique room assignment and if a room requires support staff it is assigned
at most two staff to work the room.
Each employee is assigned a tablet for individual use at the center. Some tablets
are left unassigned in case there are technical difficulties.
Finally, Little Ones has sessions that it tracks as a combination of teacher, activity,
and room designations. The type of each activity is recorded. An activity that takes
place in a particular room may have multiple teachers taking part. Furthermore, if
a particular teacher is serving a particular room, they can be running multiple
activities simultaneously. When a teacher is involved with a specific activity,
however, they may run the activity in only one room
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started