Then transform your diagram into a relational schema. Each diagram and each schema is worth 10 points. Departments, identified by name and having an office address, house a number of research groups, each with their own name and specialty. The college library maintains an archive of all technical reports written by members of research groups, tracking the title, release date and affiliation of the authors. Internal courses have some number of continuing education credits.
External courses don t, but the names and phone numbers of enrolling patrons are logged.