Create a database schema, Database Management System

Assignment Help:

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.


Related Discussions:- Create a database schema

Create a new user-data control, Create a new user : CREATE USER IDENTI...

Create a new user : CREATE USER IDENTIFIED BY Example: //CREATE USER MCA12 IDENTIFIED BY W123 Grant: It is used to give database access permission to users. It is of

Database errors, Database Errors: An error is said to have occurred if the ...

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

Relational algebra and calculus, Q.  What is relational algebra and calcul...

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

What is an index, What is an index? An index is a structure that helps ...

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

What is a database graph, What is a database graph? The partial orderin...

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

What are object interaction diagrams, What are object interaction diagrams?...

What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

Describe the algorithm for updating indices, Describe the algorithm for upd...

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

Illustrate the cardinality of relationship, Cardinality of Relationship ...

Cardinality of Relationship One-to-One Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher

Access, I have to solve a problem using access

I have to solve a problem using access

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd