Back to Syllabus
Sample Mid Term Fall 99
1. Get the total quantity of parts supplied to each job.
2. Get the total number of shipments where the quantity is null.
3. Get job numbers for jobs using at least one part shipped to J1.
4. Get supplier numbers for suppliers with status lower than that of any supplier in Paris.
5. Get job numbers for jobs supplied with part P1 in an average quantity greater than the smallest quantity in which any part is supplied to project J3.
6. Get supplier names that begin with 'S' an 'e' inside and ends with a 'y'.
7. Delete all suppliers that never supplied a red part.
8. State the referential integrity constraint so that an insertion of a new shipment record
into SPJ table would not allow this record to be an orphan record.
9. State all possible referential integrity constraints that would prevent orphan records in
SPJ when a part record is deleted from table P.
10. If we delete 'P1' row from table P and 'J3' row from table J and 'S4' from table S, and we use cascade policy, describe which rows in SPJ will be deleted?
11. Given the following table that keeps track of student clubs memberships: StuentClub( StudentId, ClubName, StudentMajor, DateJoined, StudentGender, ClubHadquarters)
Which attribute(s) is/are Primary Key..
12. Which Normal Forms are violated in the StudentClub table, if any and normalize, if necessary.