M/J/15 ucles 2015 9



Download 47,29 Kb.
Pdf ko'rish
Sana30.12.2021
Hajmi47,29 Kb.
#87500
Bog'liq
worksheet 4



14

9608/11/M/J/15

© UCLES 2015

A database has been designed to store data about salespersons and the products they have sold.



 

The following facts help to define the structure of the database:



 

 

• 

each salesperson works in a particular shop



 

 

• 

each salesperson has a unique first name



 

 

• 

each shop has one or more salespersons



 

 

• 

each product which is sold is manufactured by one company only



 

 

• 

each salesperson can sell any of the products



 

 

• 

the number of products that each salesperson has sold is recorded



 

The table 

ShopSales was the first attempt at designing the database.

FirstName

Shop

ProductName



NoOfProducts Manufacturer

Nick


TX

television set

refrigerator

digital camera

3

2

6



SKC

WP

HKC



Sean

BH

hair dryer



electric shaver

1

8



WG

BG

John



TX

television set

mobile phone

digital camera

toaster

2

8



4

3

SKC



ARC

HKC


GK

 (a) 

State why the table is not in First Normal Form (1NF).

 ...................................................................................................................................................

 ...............................................................................................................................................[1]




15

9608/11/M/J/15

© UCLES 2015

[Turn over

 (b) 

The database design is changed to:



 

 

SalesPerson (FirstName, Shop)



 

 

SalesProducts (FirstName, ProductName, NoOfProducts, Manufacturer)



 

 

Using the data given in the first attempt table (

ShopSales), show how these data are now 

stored in the revised table designs.



 

 

Table: 


SalesPerson

FirstName

Shop

 

 

Table: 


SalesProducts

FirstName

ProductName

NoOfProducts

Manufacturer

 

[3]



Nick

Sean


John

TX

BH



TX

Nick


Television set

Refrigerator

Digital camera

3

SKC



2

WP

6



HKC

Sean


hair dryer

1

SKC



electric shaver

8

BG



John

Television set

2

SKC


Mobile phone

8

ARC



Digital camera

4

HKC



Toaster

3

GK



Nick

Nick


Sean

John


John

John



16

9608/11/M/J/15

© UCLES 2015

Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every reasonable 

effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the publisher will 

be pleased to make amends at the earliest possible opportunity.

To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge International 

Examinations Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at www.cie.org.uk after 

the live examination series.

Cambridge International Examinations is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of University of Cambridge Local 

Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge.

 (c) 

(i) 

A relationship between the two tables has been implemented.



 

 

  Explain how this has been done.

 ...........................................................................................................................................

 ...........................................................................................................................................

 ...........................................................................................................................................

 ...........................................................................................................................................

 .......................................................................................................................................[2]



  (ii) 

Explain why the 

SalesProducts table is not in Third Normal Form (3NF).

 ...........................................................................................................................................

 ...........................................................................................................................................

 ...........................................................................................................................................

 .......................................................................................................................................[2]

  

(iii) 

Write the table definitions to give the database in 3NF.

 ...........................................................................................................................................

 ...........................................................................................................................................

 ...........................................................................................................................................

 .......................................................................................................................................[2]

The primary key called FirstName is used to connect SalesProducts and 

SalesPerson tables.



Download 47,29 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish