1

) - 2013

:- II

:-

:

B

(1)

(a) (i) (Data processing)

(ALU) (CU)

(ii) (Manual)

(b) ,

* 400o C

* 1.5 MPa

4000

1 400o C A

(ON)

2

2 1.5MPa B

(ON)

3 4000 C

/ /

/

A B C A B C

400 o C 1.5MPa 4000 400 o C 1.5MPa 4000

1 1 1

0 0 0

(i) AND, OR NOT

(ii)

(iii)

(iv) (iii)

(v) A, B C

( )

3

(2). (a) HTML hr paragraph , (Browser)

(b) HTML ?

Thiththawella Tank

Thiththawella tank is located in the North Western Province

Birds

Forty two bird species were observed at the tank

(c)

HTML

turtle.jpg (Young Zoologists Association),

(Kosgoda turtle hatchery), click

http://www.yza.com, http://www.Kturtle.com

http://www.yza.com/http://www.kturtle.com/

4

(3)

(Entity relationship)

(a) (Entity)

(b) ER - , - , -

(c)

(d) (Unique keys)

(e) Name (Composite attributes) 2

(f) COURSE SQL

M

1 N

N

SECTION

COURSE STUDENT

INSTRUCTOR

TpNo

attach

enroll

teach

SectCode

CourseID

Title

Fee RegNo

Name

Name ID

offer

SectName

1

1 M M

5

(4) (a)

A 28

B 16

C 9

D 6

E 25

192.168.10.10 IP ,

(i)

(ii)

(b)

192.168.10.65 192 168 10 97 IP

(i)

(ii)

(iii) (b i) (Device)

IP

6

(5)

def amoutClac(item_no): fo3=open('sales.txt') data1=fo3.readline() item_amount=[] while(data1): data3=data1.strip().split("\t") if item_no==data3[0]: item_amount.append(int(data3[2])) data1=fo3.readline() fo3.close() return(sum(item_amount)) fo=open('confec.txt') line=fo.readline() head=line item_no=input(" ) : ") while (line): line=fo.readline() data=line.strip().split("\t") if data[0]==item_no: avb_amount=int(data[2])-amoutClac(data[0]) if abv_amount>0:

print("'%s' ...!! %d "%(data[1],avb_amount)) amu=int(input(" ) : ")) fo2=open('sales.txt','a') if amu

7

confec.txt

sales.txt

(a) amoutClac

(b) avb_amount=int(data[2] -amoutClac(data[0]

3

(c) amoutClac (

3 )

(d) sales.txt confec.txt

(i) 1007

(ii) 1005 120

(iii) 1004 120

(e) sales.txt Collection dailyCollection .

Item_no Item Amount Unit_Price 1003 Chewing_gum 150 5.00 1004 Toffee 200 2.00 1005 Chocolate 100 10.00 1006 Jelly 200 5.00 1007 Candy_bar 100 6.00

Item_no Item Amount Collection 1004 Toffee 12 24.00 1004 Toffee 8 16.00 1005 Chocolate 20 200.00 1006 Jelly 14 70.00 1003 Chewing_gum 16 80.00 1003 Chewing_gum 4 20.00 1007 Candy_bar 100 600.00

8

(6) (a) e-

(i) (Business to Business (B2B))

(ii) (Business to Consumer (B2C))

(iii) (Government to Consumer (G2C))

(b) iphone 1

(Payment Gateway)

(c) (i) - (Multi-agent)

(ii) - .

(iii) -