Comp2016 Data Management Demonstration Instructions Demo 2016

User Manual: Pdf

Open the PDF directly: View PDF .
Page Count: 3

Download
Open PDF In Browser	View PDF

Comp2016 Data Management

Demonstration Instructions

Please follow the instructions below to prepare the demo (each demo will be given 10
minutes).
1. Hand in a hard-copy paper that describes the definitions of the tables in your
database.
2. Use the following command to list the tables:
select table_name from user_tables;
3. Add some student, book and borrow data into the database (some sample data are
shown below, yet your tables may not follow exactly the structures below)
insert into table_name values(…);
Student-number
12345678
11111111
22222222
33333333
44444444
55555555
66666666
77777777

Name
A
B
C
D
E
F
G
H

Gender
M
M
F
F
M
M
F
M

Department
Comp
Math
COMM
COMM
Comp
COMM
Math
Comp

If your table doesn’t have field “Book-number”, you can consider the
this field as ISBN
Book-number ISBN
Tittle
Author
Amount
A0000
0-306-40615-1
AA
XX
0
B0000
0-306-40615-2
BB
YY
0
C1111
0-306-40615-3
CC
ZZ
2
B0001
0-306-40615-4
DD
UU
2
A1111
0-306-40615-5
EE
VV
2
D0101
0-306-40615-6
FF
WW
1
E0000
0-306-40615-7
GG
PP
0
E0100
0-306-40615-8
HH
QQ
2
E0111
0-306-40615-9
II
RR
0
Borrower
11111111
22222222
33333333
11111111
44444444

Book
A0000
B0000
A0000
B0000
C1111

Borrow date
30/Mar/2016
15/Mar/2016
26/Mar/2016
15/Mar/2016
18/Mar/2016

values in
Location
S1E01
S2E02
D1E11
G1E00
B1E00
B2E11
X0E22
X0E21
X0E44

Due date
27/Apr/2016
26/Apr/2016
23/Apr/2016
26/Apr/2016
29/Apr/2016

Comp2016 Data Management
44444444
44444444
33333333
44444444
44444444
55555555
55555555
11111111
33333333
33333333
33333333
11111111
22222222

B0001
A0000
C1111
D0101
A1111
A1111
C1111
E0000
A1111
B0001
D0101
D0101
E0111

Student-number
12345678
66666666

Reserved book-number
A0000
E0000

Student-number

Renewed
number
B0000
B0000
C1111

22222222
11111111
44444444

Demonstration Instructions

10/Apr/2016
25/Mar/2016
25/Mar/2016
26/Mar/2016
27/Mar/2016
15/Mar/2016
25/Mar/2016
18/Mar/2016
25/Mar/2016
25/Mar/2016
28/Mar/2016
04/Mar/2016
26/Mar/2016

8/May/2016
22/Apr/2016
22/Apr/2016
23/Apr/2016
24/Apr/2016
12/Apr/2016
22/Apr/2016
15/Apr/2016
22/Apr/2016
22/Apr/2016
25/Apr/2016
01/Apr/2016
23/Apr/2016

book-

4. Test the function for searching a book.
5. Test the function for borrowing/returning a book (Assuming today is April 21,
2016):
a) Student “22222222” wants to borrow book “B0001”. Should response like:
“Borrow succeed”. (The amount of B0001 should be updated by trigger)
b) Student “66666666” wants to borrow book “B0000”. Should response like:
“No book available at present.”
c) Student “44444444” wants to borrow book “E0100”. Should response like:
“You have already borrowed 5 books.”
d) Student “55555555” wants to borrow book “D0101”. Should response like:
“You have borrowed book overdue.”
e) Student “11111111” returns book “E0000”. (The amount of E0000 should be
updated by trigger)
f) Student “12345678” wants to borrow book “E0000”. Should response like:
“The book has already been reserved by another student.”

Comp2016 Data Management

Demonstration Instructions

g) (Note: the following tests should been put in the end, after the
renew/reserve test) Student “66666666” wants to borrow book “E0000”.
Should response like: “Borrow succeed.” Next, Student “77777777” wants to
borrow book “E0000”. Should response like: “No book available at present.”

6. Test the function for renewing a book (Assuming today is April 21, 2016):
a) Student “22222222” wants to renew book “B0000”. Should response like: “The
book has already been renewed”.
b) Student “11111111” wants to renew book “D0101”. Should response like:
“You have borrowed book overdue.”
c) Student “12345678” wants to renew book “E0000”. Should response like: “The
book has already been reserved by another student”.
d) Student “44444444” wants to renew book “B0001”. Should response like:
“Please wait until the second half of the borrow period”.
a) Student “33333333” wants to renew book “C1111”. Should response like:
“renew succeed”. (Check the content of renew table)
7. Test the function for reserving a book:
b) Student “22222222” wants to reserve book “C1111”.
“There is book available, no need to reserve”.
c) Student “44444444” wants to reserve book “A0000”.
“You have already borrowed this book”.
d) Student “12345678” wants to reserve book “B0000”.
“You have already reserved a book”.
e) Student “77777777” wants to reserve book “B0000”.
“Reserve succeed”. (Check the content of reserve table)

Should response like:
Should response like:
Should response like:
Should response like:



---

Source Exif Data:

File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.5
Linearized                      : Yes
Author                          : test1
Comments                        : 
Company                         : HKBU
Create Date                     : 2016:04:18 17:08:44+08:00
Modify Date                     : 2016:04:18 17:08:45+08:00
Source Modified                 : D:20160418090757
Subject                         : 
Language                        : EN-US
Tagged PDF                      : Yes
XMP Toolkit                     : Adobe XMP Core 5.4-c005 78.147326, 2012/08/23-13:03:03
Metadata Date                   : 2016:04:18 17:08:45+08:00
Creator Tool                    : Acrobat PDFMaker 11 for Word
Document ID                     : uuid:07115ea1-6a2e-4994-8f6a-c143dfba90a7
Instance ID                     : uuid:78516b54-3314-4afc-ba06-2f5037fd0112
Format                          : application/pdf
Title                           : Comp2016 Data Management                Demonstration Instructions
Description                     : 
Creator                         : test1
Producer                        : Adobe PDF Library 11.0
Keywords                        : 
Page Layout                     : OneColumn
Page Count                      : 3

EXIF Metadata provided by EXIF.tools