Solutions to "SAMPLE MIDTERM QUESTIONS"

Note:

· For questions 1 and 2, I assumed that the do_id is enough to be a primary key for a DRAWING OBJECT entity.  One can always create a primary key for any object that is unique.  I am assuming when the do_id is created it incorporates enough information to make it a unique key.  This, in turn, simplifies the schema in problem 2 as a composite key does not have to be created.

· For question 3d I did not give a solution since a solution would have to include the SYSDATE built in function and some date arithmetic which is beyond what we had covered in this class.  I got carried away and really gave you a 276 problem!  My apologies.