Kids R Us is a national crèche chain that has numerous crèches throughout London
ID: 3813679 • Letter: K
Question
Kids R Us is a national crèche chain that has numerous crèches throughout London. They provide child-minding facilities for children from the age of 6 months until they’re ready to go to national school. Currently, they use a manual file system to store and manage their data but due to their expansion plans and the number of children they now have on their books, they have decided to invest in a RDBMS to store their information.
You, the experienced database consultant, have been chosen to design and implement this new relational database. Your first meeting with the Managing Director has provided you with the following business rules:
(1) There are currently 18 crèches situated in various parts of London. The company is looking to open more crèches in towns and cities that they aren’t located in. They predict that they will have a total of 24 crèches nationwide by the end of 2010.
(2) The first crèche the company opened was in Church Street, London.
(3) There are over 200 child-minders employed by the company.
(4) Each crèche has distinct areas, all based on the children’s age. The areas include babies, toddlers and montessori’s. Some crèches have 4 or 5 areas, depending on their size. A unique number identifies each crèche area.
(5) Each crèche has one manager. At times, managers may be asked to fill in at other crèches whilst that manager is on leave. The company will want to know who managed a particular crèche on each day.
(6) Each child-minder is attached to one particular area i.e. they normally look after babies, toddlers or montessori’s. The database must be able to show what minders are in each crèche area at any time.
(7) Child minders don’t move between crèches but can move between areas within a crèche i.e. they can work in a different area within their crèche if required.
(8) Children can move from one area to another i.e. when they become one year old, they move from the baby area to the toddler area. When they reach two and a half years of age, they move from the toddler area to the montessori area. It is important to capture when a child was in an area and how much their parents were charged per day during this time.
Based on the above information, you should complete the following:
(a) Draw an entity diagram for each entity identified.
(b) Draw a relationship matrix, which will depict the relationships between these entities.
(c) Draw an E-R diagram.
(d) List any assumptions you have made.
Explanation / Answer
.ent exc_pulse
exc_pulse:
la t0, time
la t1, x_q
la t2, light
lw t3, 0(t0) //Load time (t3)
lw t4, 0(t1) //Load x_q (t4)
lw t5, 0(t2) //Load lightweight (t5)
addi t6, t3, one //Increment time by one
sw t6, 0(t0)
addi t7,zero,10 //Time before lightchangage
blt t6, t7, ls //If time < ten - long skipout
move t3, zero //time = 0;
sw t3, 0(t0)
beq t4, zero, ls //If x_q == zero - long skipout
bne t5, zero, ss //If lightweight == one - short skipout
addi t5, zero, one //light == one
sw t5, 0(t2)
lui t8, LEDZ
addi t9, zero, a hundred thirty //Turn on some lights!
sb t9, 0(t8)
j ls
ss:
move t5, zero //light = zero
sw t5, 0(t2)
addi t9, zero, 65
sb t9, 0(t8) //Turn on/off lights!
move t4,zero //empty queue
sw t4, 0(t1)
ls:
.end exc_pulse
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.