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
To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Define identify relationship? Identifying relationship: An identifying relationship means in which the child table cannot be uniquely recognize without the parent. For exampl

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p


Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used


Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

Need 2 projects completed in 3NF format.