IPT home IPT A Virtual Approach by Peter Whitehouse
Quick Links:
exercise source
Information and Intelligent Systems Social and Ethical Implications Human Computer Interaction Software and Systems Engineering eXercise Files Course Outline and Assessment A-Z of Geeky Acronyms Terrace Work Program 2004 Sillybus FAQ = Frequently Asked Questions Help
Database Languages eXercises #1

The Relational Model - Solutions

1. and 2.
table (a) is NOT relationally acceptable - the medals column contains 
repeating groups.  table (b) is fine relationally, but could be difficult 
to use for things like medal tallies.  table (c) is the preferred one 
for most transactions.

table (a) states that the tigers have scored NO wins, whereas table(b) 
states that the number of wins for the tigers is un-recorded

(a) Name, assuming name uniquely identifies a person
(b) Name+Subject (a person can study many subjects, a subject can be studied by many students)
(c) Language (is there a choice?)
(d) Language (as a language is either recursive or not)
(e) Manufacturer + Model + Year
(f) Day + Subject + Period

1. if ties are allowed, then School+Event could be a key if a school is allowed 
to enter maximum one entrant per event
2. if ties are NOT allowed, then School = Event could be a key for the same 
reasons as above, in addition, Place + Event would be a key.

©Copyright t 1992..2017+. Edition 25.150117
Creative Commons License
This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.1 Australia License