Document Preview:
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. Page 241 Lab Exercise #7.31 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. Page 243 Lab Exercise #7.35 Consider the ER diagram for the AIRLINE database shown in Figure 7.20. Build this design using a data modeling tool such as ERwin or Rational Rose. American Public University System Kageorgis 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. Page 241 Lab Exercise #7.31 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. Page 243 Lab Exercise #7.35 Consider the ER diagram for the AIRLINE database shown in Figure 7.20. Build this design using a data modeling tool such as ERwin or Rational Rose. American Public University System Kageorgis