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
Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Prepare a gantt chart for the stock control project: Scenario Lucas-TVS is the Leader in Auto Electricals in India today with 50 years experience in desig

Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

Explain the shadow paging recovery technique.  Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i

What are composite objects? Objects that have other objects are known as complex objects or composite objects.

What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

how the string works as keyword?

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for