Time: Oct. 1, 2016 from 1:00 P.M. to 10:00 P.M.
Name: Teyona Sprinkle-Rorey
Q3 (35 points)(Mapping E-R Model to relations): Map the following ER diagram to
relations by writing SQL statements to capture as many of the co
Due Date: Sept. 28, 2016, at midnight
Note: Please type your solution, otherwise it will not be graded.
This assignment is designed to let you practice writing Relational Algebra. After studying
the lecture notes and Chapter 8, you should be ab
Due Date: Sept. 17, 2016 at 11:59 PM
Consider the scenario from homework 1, where we designed an E-R diagram
as represented in the following figure for an art gallery in Greensboro. Task
1 (70 points): Write SQL statements to create the corresp