Create a database schema, Database Management System

Consider a database schema consisting of four relations, whose schemas are:

Product (maker, model, type)

PC (model, speed, ram, hd, price)

Laptop (model, speed, ram, hd, screen, price)

Printer (model, color, type, price)

The Product relation gives the manufacturer, model number and type (PC, laptop, or printer) of various products. (We assume for convenience that model numbers are unique over all manufacturers and product types; note that in reality, we can include a code for the manufacturer and product type as part of the model number.) The PC relation gives for each model number that is a PC, the speed (of the processor in GHz), the amount of RAM (in megabytes), the size of the hard disk  (in gigabytes), and the price. The Laptop relation is similar, except that the screen size (in inches) is also included. The Printer relation records for each printer model whether the printer produces color output (true or false), the process type (laser or ink-jet, typically), and the price.

Write the SQL CREATE TABLE (SQL DDL) statements for the above schema, specifying any primary key and unique constraints.

(Note that referential integrity ("foreign key") must ideally specify that the model in Product must appear in one of the PC, Laptop and Printer tables; we will learn how to specify such constraints later in the course using triggers; they cannot be specified using foreign key constraints - for this problem, you NEED NOT specify these constraints).

Include the SQL statements and appropriate screen shots showing that your CREATE TABLE statements succeeded into your submission document.

Posted Date: 3/20/2013 1:52:54 AM | Location : United States

Related Discussions:- Create a database schema, Assignment Help, Ask Question on Create a database schema, Get Answer, Expert's Help, Create a database schema Discussions

Write discussion on Create a database schema
Your posts are moderated
Related Questions
List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?

Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?

Explain the main advantages of DBMS over File Oriented System ?

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te

Illustrate different types of Locks in SQL Server. There are three kinds of locks in SQL Server i.) Shared locks - These are used for operations which don't allow any update

Which method is used to key transformation ? A hash method is used to key transformation.