Write sql statements to create the corresponding relations

Assignment Help Database Management System

Reference no: EM13509195

1.Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

2.Consider the following schema:

Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, cost: real)

The Catalog relation lists the prices charged for parts by Suppliers. Answer the fol-lowing questions:

Give an example of an updatable view involving one relation.

Give an example of an updatable view involving two relations.

Give an example of an insertable-into view that is updatable.

Give an example of an insertable-into view that is not updatable.

3.Given two relations R1 and R2, where R1 contains N1 tuples, R2 con-tains N2 tuples, and N2 > N1 > 0, give the minimum and maximum possible sizes (in tuples) for the resulting relation produced by each of the following relational algebra expressions. In each case, state any assumptions about the schemas for R1 and R2 needed to make the expression meaningful:

(1) R1∪R2, (2) R1∩R2, (3) R1−R2, (4) R1×R2, (5) σa=5(R1), (6) πa(R1), and (7) R1/R2

Reference no: EM13509195

Questions Cloud

Construct company manufacturing overhead budget : Company C's variable manufacturing overhead rate is $2.00 per direct labor-hour and the company's fixed manufacturing overhead is $40,250 per quarter. The only non-cash expense included in the fixed overhead is depreciation of $12,000 per quarter.

How many pennies must be added to the water : Copper pennies weighing 2.5 g have been placed in boiling water at 100 degree Celsius. How many pennies must be added to the water to raise the temperature to 31 degree Celsius

What is the final temperature of iron : After placing the iron (0.750 kg) in the fire and shaping it, it is still at 200 C. He puts the piece in 8 L bucket of water at 25 degree celsius. What is the final temperature of iron

Compute the weight of the sand and box in that situation : An initially stationary box of sand is to be pulled across a floor by means of a cable in which the tension should not exceed 754 N. what is the weight of the sand and box in that situation

Write sql statements to create the corresponding relations : Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

Identification and analysis of the market for the product : Product or service definition - identification and analysis of the market for the product

Compute how many revolutions per minute is the sample making : A centrifuge is a device in which a small container of material is rotated at a high speed on a circular path. How many revolutions per minute is the sample making

Compute uniteds total 2012 payroll expense for welch : Compute Welch's gross pay, payroll deductions, and net pay for the full year 2012. Round all amounts to the nearest dollar and compute United's total 2012 payroll expense for Welch.

Calculate its speed at aphelion : Halleys comet, which passes around the sun every 76 years, has an elliptical orbit. When closest to the sun (perihelion) it is a distance of 8.823 x 10^10m, calculate its speed at aphelion

User Account

All Pages