For lab assignments you must use an actual database - Database systems such as Oracle, MS SQL, DB2, or Access are all acceptable if they can handle the capability to handle these questions. Do the exercises in the actual database then copy and paste the results or an image of the results here in the respective question part. ER Diagrams and Schemas can be created with MS Visio templates.
Consider the UNIVERSITY database described in Exercise 7.16. Build the ER schema for this database using a data modeling tool such as ERwin or Rational Rose.