Thai Sikh International School
E-Learning Programme – Online
Assignment – 01/09/2014
Name
: Subject : ICT
Year : 10
A/B Week No. : 1
1.
The manager of a bookshop uses a database to store
data about the books she sells. This
is part of the database.
|
Title of Book
|
Fiction(Y/N)
|
Number in Stock
|
Next Order Due
|
|
Fill Circle
|
N
|
15
|
20/06/11
|
|
Sandition
|
Y
|
18
|
08/07/11
|
|
Vanity Fair
|
Y
|
23
|
16/10/11
|
|
The Old
Curiosity Shop
|
Y
|
10
|
23/06/11
|
|
Pride and
Prejudice
|
Y
|
12
|
23/06/11
|
|
Sense and
Sensibility
|
Y
|
26
|
02/10/11
|
|
The Moon’s a
Balloon
|
N
|
12
|
21/08/11
|
a)
How
many fields are there in this part of the database?
b)
How
many records are there in this part of the database?
c)
The
records shown are to be sorted in ascending order of Number in Stock. What will be the title of the book which will be
the first record in the database after it has been sorted?
d) What
is the title of the book which has no more than 12 copies in stock and is no
Fiction?
No comments:
Post a Comment