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




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. Refer to your Lab Manual located under Resources > Assignments folder.


  1. Page 241 Lab Exercise #7.31 [1% point]


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.


Answer:






  1. Page 243 Lab Exercise #7.35 [1% point]


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.


Answer:






Document Preview:

Name: Tadros Nabil Date: 6/22/14 Week 3 – Lab #2: Chapter 7Grade: 2% of Class Grade 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. Refer to your Lab Manual located under Resources > Assignments folder. Page 241 Lab Exercise #7.31 [1% point] 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. Answer: Page 243 Lab Exercise #7.35 [1% point] 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. Answer:



May 24, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here