anta Claus is working to upgrade his list from a handwritten one to a more modern, digital solution. As you likely already know, he must keep track of each child, their naughty/nice status, their location, position on his route, the toys they asked for, the elves assigned to make those toys, the elves’ working schdule, their favorite payment methods, and keep track of their production as the year progresses, to make sure nobody will be left out this Christmas. Keep in mind, he also needs a way to check his list twice. The following bulleted list reiterates what we’ve already discussed as requirements. • Children, their naughty/nice status (two of these for checking the list twice), locatio
Santa Claus is working to upgrade his list from a handwritten one to a more modern, digital solution. As you
likely already know, he must keep track of each child, their naughty/nice status, their location, position on his
route, the toys they asked for, the elves assigned to make those toys, the elves’ working schdule, their favorite
payment methods, and keep track of their production as the year progresses, to make sure nobody will be left
out this Christmas. Keep in mind, he also needs a way to check his list twice. The following bulleted list
reiterates what we’ve already discussed as requirements.
• Children, their naughty/nice status (two of these for checking the list twice), location, route position (i.e.
what order their presents are delivered in), requested toys.
• List of elves, production assignments (which toys for which children), preferred payment methods (candy,
candy-canes, candy corn, syrup), their work schdedules (assume 3, 8 hour shifts).
• List of presents, whether or not the presents have been produced yet, whether or not they will be delivered
(depending on whether the child is naughty or nice).
1. Using any flowchat software of your choice (we suggest lucid chart or LaTeX+TiKz, the latter
of which doesn’t have object limits), construct an ERD using crow’s foot notation that encapuslates this
problem, while being sure to follow the normal form guidelines of 3NF. Be sure to include any keys, weak
entities, relationship constraints, cardinalities, etc. You can make realistic assumptions about any of the
variables mentioned above.
Step by step
Solved in 2 steps with 1 images
