hw6 - CIS 4301 (Information & Database Systems I)...

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

View Full Document Right Arrow Icon
Homework 6 - Programming Assignment Due date: 04 / 19 / 2010 Submit a soft copy through course tools by midnight No late submissions accepted for this assignment! This homework covers Grouping, Aggregation, Database Modifications, Constraints, and Trigger. Assume that we have a relational database with the following relations. Data is same as chapter 2.4.14, p53~p54 in textbook. Product(maker, model , type) PC(model , speed, ram, hd, price) Laptop(model , speed, ram, hd, screen, price) Printer(model , color, type, price) For each schema, model attribute is a key. Write answers the following questions. A. Modify your SQL schema from Exercise 2.3.1 to include following constraints to the relations above. For each schema, key should not be NULL. A model of a PC, Laptop, or a Printer must also be the model of Product. B. Write an ALTER TABLE statement for the following constraint. The only types of Product relation are
Background image of page 1

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

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

This note was uploaded on 01/22/2012 for the course CIS 4301 taught by Professor Schneider during the Fall '08 term at University of Florida.

Page1 / 2

hw6 - CIS 4301 (Information & Database Systems I)...

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

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