IPT - A Virtual Approach IPT A Virtual Approach by Peter Whitehouse
Quick Links:
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 Design eXercises #4

Further Constraints (some solutions)


  1. definitely splittable
  2. probably unsplittable
  3. definitely splittable
  4. definitely splittable
  5. definitely unsplittable
  6. definitely splittable


flattened form

nested solution

(g) probably ok
(h) definitely ok

[Course(coursecode) offered in Year(adcode)] = offering
offering had enrollment of Tally(studentcount)
offering was lectured by Lecturer(lecturername)
offering in Rating(ratingcode) had Tally(studentcount)
offering in Rating(ratingcode) had Percent(%) *derived

schema is trivial

PostalCategory(categorycode)'B' has lower limit of Weight(kg)1
PostalCategory(categorycode) has upperlimit of Weight(kg)
PostalCategory(categorycode) sent to Zone(zonenum) costs Money(dollars)
Country(countryname) belongs to Zone(zonenum)

5. invent codes for employee, department, project, label types for them, then chart their relationships

6. ... more to come (hopefully)

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