Write the following assertions. The database schema is from the PC example: Product(maker, model, type) PC(model, speed,
Fantastic news! We've Found the answer you've been seeking!
Question:
Write the following assertions. The database schema is from the "PC" example:
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price
b) A manufacturer of a PC must also make a laptop with at least as great a processor speed.
c) If a laptop has a larger main memory than a PC, then the laptop must also have a higher price than the PC.
d) If the relation Product mentions a model and its type, then this model must appear in the relation appropriate to that type.
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date: