Web Tech Xii

HOLIDAYS HOMEWORK CLASS XII Multimedia and Web Technology Q1)Write the Html code for creating the form given below and also write the embedded VBscript code for the click event of the submit button, such that it display message with the name entered by the user and amount of his bill. The cost are given below REGULAR PIZZA:RS.100 THE TOPPING COST EXTRA: CHEES TOPPING:RS.20 CAPSICUM TOPPING:RS.25 If the user enter name as”Utsav” and selects “pan” and topping a cheese then it should display the message: “DEAR UTSAV!YOUR BILL AMOUNT IS RS 170” In a messagebox. PIZA CORNER customer name

UTSAV

select pizzatype:

regular

select topping:

pan

cheese capsicum Submit

Q2) What is DBMS write the advantages of the DBMS. Q3)Create a table named Teacher consisting of the following fields and enter 10 records in to the table: FIELD NAME DATA TYPE DESCRIPTION T_code Autonumber Primary key T_name Text Teacher’name Designation Text Teacher’s designation Dob Date Date of birth Address Text Residential address Basic_sal Number Basic salary Qualification text Education qualification

Q3)Create the two table given below and set up the a relationship between them write the datatype of each of the fields and the primary key field of the table: TABLE:CUSTOMER FIELD NAME ACC_NO Acc_typa Full_name address

DESCRIPTION Id of customer Type of account Fullname Customer address

TABLE:LOAN FIELD NAME LOAN_ID Loan_date Acc_no Loan_type Loan_amount Int_rate

DESCRIPTION Id of loan Date when loan processed Customer account Type of loan Loan amount Interest rate to be paid

Q4) Write the different fields in which virtual reality is being used. Q5) What do you understand by the open source software. Write any five criteria in which an open source software should comply with according to OSI. Q6) PROJECT WORK: Make a simple website for the jewelry showroom which display it’s ornaments according to it’s class such as(ring, bangle etc) by using different links.It should contain almost all the tags of the html. Q7)Collect the requirement for the website “INCREDIBLE INDIA” which will make India incredible and represent the India in the world. Q8)Define the following terms: a)Primary Key b)Candidate Key c)Alternate Key Q9)What is the significance of having a primary key in a relation? Q10)What is the Data Type?Metion the different type of the Access. Q11)Go through the following websites of the open Source and write the detail facilities and resources which have been available on these sites: a)www.openrdf.org b)www.sourceforge.net c)www.opensource.org d)www.linux.com

Q12)Name any five website which provide information about the open source software. Q13) Diffrentiate between the following: a)circuit switch and packet switch b)Star topology and bus topology c)Twisted pair cable and Co-axial cable d)LAN and WAN e) GSM and CDMA Q14)Write short note on the following: a)WLL b)E-mail c)SMS d)Cookies

e)Cyber Law

d)ARPANET

Q15)What are repeaters and routers? Q16)What are the bridges? how do they differ from repeater? Q17)What is HUB?What are its type? Q18)What do you understand by the protocols?What is ISO-OSI standard for the network? Q19)Fantastics computer Inc. cater to many high profile client and has 5 building where it runs its operation:

B5 B1

B4

B2

B3

The distance between different buildings are given below: a)Between 1 and 2 50mts. b) Between 2 and 3 30mts. c) Between 3and 4 35mts. d) Between 4 and 5 40mts. e) Between 3 and 5 30mts. f) Between 1 and 5 120mts. g) Between 2 and 5 45mts. h) Between 2 and 4 65mts.

Each building contains following number of computers: Building no. of computer 1 55 2 185 3 60 4 70 5 55 Answer the following based on the above given information: 1)Suggest cable layout for connecting the buildings 2)Where do you think the server should be placed. 3)The company also has another office in the same city but at the distant location of about 25-30 kms away. How can link be establish with this building. Q20)The great brain Org. has set up its new Branch at Srinagar fot its office and web based activities it has 4 wings of building as shown in the diagram: center to center distances between various blocks:

WingX

WingY

Wing Z

Wing U

Distance: Wing X to Wing Z Wing Z to Wing Y Wing Y to Wing X Wing Y to Wing U Wing X to Wing U Wing Z to Wing U

50m 70m 125m 80m 175m 90m

Number of the computers: Wing X Wing Z Wing Y Wing U

50 30 150 15

a)Suggest a most suitable cable layout of connection between the wings and topology. b)Suggest the most suitable place (i.e wing)to house the server of this organization with suitable reason. c)Suggest the replacement of the following devices with justification: i)repeater ii)Hub/Switch d)The orgnisation is planning to link its head office situated in Delhi with the offices at Srinagar.Suggest a way to connect it with high speed;the company is ready to compromise on the cost.Justify your answer.