Page 58 - IP

PREBOARD
EXAMINATION

CompID CompName CompHO Cont Person

1 Tit Okh BC.Jos
an la hi
2 Ajan Najafgarh V.P.Gupta
ta
3 Maxima Shahdara R.Kum
ar

Model

ModelID CompID ModelCost

T020 1 20
00
M059 2 70
00
M032 3 25
00

(i) Identify the foreign Key column in the table model. 1
(ii) Check every value in CompID column of both the tables. Do you find any discrepancy? 1

(c) Consider the tables product and client give
below – Product

PI ProdName Manufactures Price
D
T P01 P Cel 5
e lo
n
T P02 Gel pen Lux 1
ar 0
T P03 Ink pen Lux 1
ar 0
T P04 Pencil Natr 2
aj
T P05 Sketch Cam 2
el

CID CliName City PI
D
01 Rakesh Delhi TP01
02 Prakash Mumbai TP05
03 Suresh Delhi TP03
04 Dinesh Delhi TP02
05 Pravesh Banglore TP04
Client

i. To Display the details of products whose Price is in the range of 6 to 10 [2]