Argthtjtr

I've been reading on fd's for a worksheet. I've already found the schema c(n r cl l rn rt rl rid). But I'm struggling to and of the FD's in the information provided. My question is how do I find the FD's in the information sheet.

NOTE: this is not homework, this study for examination and is from a mock exam on https://moodle.curtincollege.edu.au/pluginfile.php/74765/mod_resource/content/2/2017%20S2%20DS%20Exam.pdf.

Question 3: FDs and Normalization (18 Marks) An update for the game
adds player pets (in this case, small robots) to the game. Players can
assign names to their robots and choose robots of a specific type.
Robots also gain levels. As with items, the game assigns robots a
unique id to better keep track of them. You are given the following
updated schema: Character( name, race, class, level, rname, rtype,
rlevel, rid) where attributes starting with ‘r’ pertain to the robot.
The idea is that each character has exactly one robot and each robot
is associated with exactly one character, so merging them makes sense.

1. List all FDs relating to characters and robots from the requirements shown in the information sheet and the information above.

This is the information they provided.

• The characters used by the players. A character has a unique name, a
race, a class and a level.

o Races are strings such as “human”,
“dwarf” or “construct”.

o Classes are strings such as “soldier”,
“engineer” or “mad scientist”.

o Levels are whole numbers up to 100.

• The items in the world. Each item has a unique item ID by which it
is described internally and may have a type, condition and/or price.

o The ID of a weapon is an alphanumerical string of up to 128
characters.

o The type of an item is a string such as ‘weapon’ or
‘container’.

o The condition is a whole number that will be treated as
a percentage.

o The price is the price in dollars (allow cents through
decimals as usual).

o Some items (of type ‘weapon’) also have maximum
and minimum damage fields (integers) while others (of type
‘container’) have a capacity (also an integer).

o Each character can
equip at most one weapon and can carry a large number of items
(possibly including more weapons).

o A sword is an item and a weapon
but not a container.

o A backpack is an item and a container but not a
weapon. o An apple is an item but neither a weapon nor a container.

• Powers are things that the character can do. Characters can learn
some of these based on their class.

o A power has a unique name of up
to 64 characters and a description of not more than 256 characters.

o
Powers to be used in combat have a cool-down (in seconds, up to 10
minutes’ worth) and may have a maximum and minimum damage (integers),
while non-combat powers have duration (in seconds, up to 100 minutes’
worth). All powers have a cost (an integer).