W1 P2 Advanced UML Q

Data Driven Web Technologies
Week One Practical Two

Practical One Pt 2 – Advanced UML
So now with more knowledge on database creation and the conventions around it all. Can you now create
some databases that follow the rules set out in the normalisation readings?
Question One - Cheese Chasing

Cheese Chasing is a fascinating sporting event that takes place every May in Gloucester, England on
Cooper's Hill. (https://en.wikipedia.org/wiki/Cooper%27s_Hill_Cheese-Rolling_and_Wake)
A wheel of cheese weighing about eight pounds is rolled down a very steep hill, and dozens of contestants
go scrambling after it so fast that broken limbs and other injuries are common. Whoever nabs the cheese is
the champion and they win 15 or so minutes of fame (and the cheese.)
Your task is to create a database that will record:
 The contestant details (name, age, address)

 If the participant has handed in both their Accident Waiver and Release of Liability Forms
 Details of the cheese being chased (weight, a categorised type would be handy in case some flavours
result in more injuries)
 The number of resulting injuries of specific types
 The winner of the chase
Question Two – Toy Voyages
Hobbies are for everyone and of the most fun

hobbies to have (other than relocating garden
gnomes) is to participate in toy voyaging
(https://en.wikipedia.org/wiki/ToyVoyagers)
Your task is to create a database that tracks
members, their toys and the locations their have
visited whilst on holiday!
The detail:
Members have a unique username in addition to their name, unique email address and their country of
location.
Members own specific toys which they upload pictures of when on holiday to the database. Members toys
are described by their name, the type of toy (teddy bear, plush puppy, cabbage patch kid – whatever!). If
the member’s toy type is not in the list of options they can add it when detailing their toy. The approximate
age of the toy can also be entered.
Members can create links between locations (towns/cities) located in a country that their toys have visited.
This includes the ability to record the period (dateFrom, dateTo) the toy was visiting and one or more
photos of the toy at that destination. Photos need to the ability to be tagged if they contain people (not only
the toy) in the photo. Members can vote to like other member’s toy voyage photos.
Create a UML diagram that will help record the relevant information.
Question Three – Playschool

Play School is the beloved Australian children’s educational tv
show that’s been running since the 60's
Have a quick look at the available data on Wikipedia. Your

task is to design a database to capture each episode of the
series, including all the presenters and producers of an
episode and the running theme for the week.
Finally, there are a host of toys that have appeared over the
years, so you will need to capture this important information
about the toy and what episodes they have appeared in.
https://en.wikipedia.org/wiki/Play_School_(Australian_TV_series)
Question Four – Pokédex
Professor Oak is going spare! All these new Pokémon and their variants!
You've been tasked with building the database for the all new complete, absolutely everything Pokédex.
You need to capture the Pokémon data with possible variants (Assuming for this that mega evolution and
gigantamax are variants). Store data for the type that Pokémon can be, with type weaknesses and
strengths. Finally, the regions where the Pokémon are found and the specific locations you can find them.
https://en.wikipedia.org/wiki/Pok%C3%A9mon
https://www.serebii.net/pokemon/
Question Five – Avatar the Last Airbender

The world of Avatar needs a digital census.
(https://avatar.fandom.com/wiki/Geography_of_the_World_of_Avatar)
You are to capture the people of this world,
and the nation that they come from. These
nations have at least one city in them and at
least one of those cities are the nations
capital. Nations have all been at war with
each other throughout the ages, be sure to
capture all that information.
What makes the world truly unique is that a
person may have the ability to bend elements
to their will. Some elements have a
subcategory (Example blood bending is a
type of water bending, lightning is a type of
fire bending, steel is a type of earth bending)
Finally, there are truly unique individuals who are the embodiment of the Avatar spirit the peacekeeper of
the world and the bridge between the spirit and living worlds. There is only ever one Avatar alive at once,
when the old one dies their spirit is reincarnated into a newborn. Only the Avatar can master and bend all
four elements.

W1 P2 Advanced UML Q

Uploaded by

Copyright:

Available Formats

W1 P2 Advanced UML Q

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

W1 P2 Advanced UML Q

Uploaded by

Copyright:

Available Formats

Data Driven Web Technologies

Week One Practical Two

Question One - Cheese Chasing

Your task is to create a database that will record:

 The contestant details (name, age, address)

Hobbies are for everyone and of the most fun

Question Three – Playschool

Have a quick look at the available data on Wikipedia. Your

Question Five – Avatar the Last Airbender

You might also like