UML Solutions

1. 
(a) Books: minimum 3, maximum 18; Readers: minimum 0, maximum 72
(b) Books: minimum 2, maximum unlimited; Authors: minimum 1, maximum unlimited

2. 

3.  Overlapping (e.g., Fiction and and Children) and complete (all books are Fiction or Nonfiction).

4.  (a),(e),(f) are true; the rest are false

5. 
(a) minimum: 1, maximum: 5
(b) Professor minimum/maximum: 0/1, Assistant minimum/maximum: 3/6,
(c) Professor(name,office,rank,course#,rating)
     Assistant(name,office,years)
     Course(course#,dept)
    ATeach(name,course#)
(d) Professor: name
     Assistant: name
     Course: course#
     Lteach: (name,course#)
(e) Professor.course# and Professor.rating must permit nulls

Scroll to Top