数据库基础教程CH1 答案.pdf

Exercises2.3.1

Inthisexerciseweintroduceoneofourrunningexamplesofarelationaldatabase

schema.Thedatabaseschemaconsistsoffourrelations,whoseschemasare:

Product(maker,model,type)

PC(model,speed,ram.hd,price)

Laptop(model,speed,ram,hd,screen,price)

Printer(model,color,type,price)

TheProductrelationgivesthemanufacturer,modelnumberandtype(PC,laptop,or

printer)ofvariousproducts.Weassumeforconveniencethatmodelnumbersare

uniqueoverallmanufacturersandproducttypes;thatassumptionisnotrealistic,anda

realdatabasewouldincludeacodeforthemanufactureraspartofthemodelnumber.

ThePCrelationgivesforeachmodelnumberthatisaPCthespeed(oftheprocessor,

ingigahertz),theamountofRAM(inmegabytes),thesizeoftheharddisk(in

gigabytes),andtheprice.TheLaptoprelationissimilar,exceptthatthescreensize(in

inches)isalsoincluded.ThePrinterrelationrecordsforeachprintermodelwhether

theprinterproducescoloroutput(true,ifso),theprocesstype(laserorink-jet,

typically),andtheprice.

Writethefollowingdeclarations:

a)AsuitableschemaforrelationProduct.

b)AsuitableschemaforrelationPC.

c)AsuitableschemaforrelationLaptop.

d)AsuitableschemaforrelationPrinter.

e)AnalterationtoyourPrinterschemafrom(d)todeletetheattributecolor.

f)AnalterationtoyourLaptopschemafrom(c)toaddtheattributeod

(optical-disktype,e.g.,cdordvd).Letthedefaultvalueforthisattributebe

noneifthelaptopdoesnothaveanopticaldisk.

Exercise2.3.1aExercise2.3.1b

CREATETABLEProduct(CREATETABLEPC(

makerCHAR(30),modelCHAR(30),

modelCHAR(10)PRIMARYKEY,