IPT - A Virtual Approach IPT A Virtual Approach by Peter Whitehouse
Quick Links:
 
 
back
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.

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

2.
(a)
(b)
(c)
(d)
(e)


flattened form

nested solution


(f)
(g) probably ok
(h) definitely ok
(i)
(j)

3.
[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

4.
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)

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