EXERCISE 2.3.1: create table Product ( maker char(255), model number, typex char

Question

EXERCISE 2.3.1:

create table Product (

maker char(255),

model number,

typex char(255)

);

create table PC (

model number,

speed number,

ram number,

hd number,

price number

);

create table Laptop (

Model number,

speed number,

ram number,

hd number,

screen number,

price number

);

create table Printer (

Model number,

color number,

typex char(255)

price number

);

Exercise 7.1.3: Suggest suitable keys and foreign keys for the relations of the PC database Product (maker, mode1, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer (model, color. type, price) of Exercise 2.4.1. Modify your SQL schema from Exercise 2.3.1 to include declarations of these keys

Explanation / Answer

Add suitable primary and foreign keys.

create table Product (
maker char(255),
model number,
typex char(255),
PRIMARY KEY (model)
);

create table PC (
model number,
speed number,
ram number,
hd number,
price number,
PRIMARY KEY (model)
);

create table Laptop (
Model number,
speed number,
ram number,
hd number,
screen number,
price number,
PRIMARY KEY (model)
);

create table Printer (
Model number,
color number,
typex char(255),
price number,
PRIMARY KEY (model),

FOREIGN KEY (typex) REFERENCES Product(typex)
);

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.