mtExamfa03 - CSE 412/598 Database Management Systems...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CSE 412/598 Database Management Systems Mid-Term Exam Fall 2003 NAME_______________________________ ASU ID: ________________________ [10 pts.] 1. Use the ER approach to model the operations of your local community library. The library has books, CD’s, tapes and so forth, which are lent to library patrons. Patrons have accounts, addresses, and so forth. If a loaned item is overdue, it accumulates penalty. However, some patrons are minors, so they must have sponsoring patrons who are responsible for paying penalties (or replacing a book in case of a loss). 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
[10 pts.] 2. Convert the ER Diagram to a relational database schema. 2
Background image of page 2
[20 pts.] 3. Relational algebra. The database schema for a computer shop contains the following schema. type is either pc, labtop or printer. Product (manufacturer , model , type). PC (model , speed, ram, hard_disk, removeable_disk, price). Labtop (model , speed, ram, hard_ddisk, removeable_disk, screen, price). Printer
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/12/2010 for the course CSE 41412 taught by Professor Hassan during the Fall '10 term at University of Arizona- Tucson.

Page1 / 6

mtExamfa03 - CSE 412/598 Database Management Systems...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online