1.

a)

What is a DBMS?

1

b)

i) A part of the Microsoft Office suite that is used to create and manage databases ii) The view in which we can define each field in the table, associated data types and their input masks.

1

c)

What do you understand by “Enforce Referential Integrity” given in the following diagram

2

D

Study the following data and answer the questions given below:

(i)What is the cardinality and degree of the following table tbl_cust?

1

tbl_cust

CUST

_ID

CUST_ FNAM E

CUST_LN AME

CUST_ADD RESS

CUST_PHON E

CUST_EMAIL

1

Gaurav

Sharma

143, Sanjay

Gram,Sector

-16, Chandigarh

8800937124

fantasticgaurav

@gmail.com

2

Harsh

Singh

12,Officer's Colony, Sector-

60,Ludhiana

9807652719

harsh.singh@g mail.com

3

Srotos wini

Singh

13,Iffco Colony, Near Iffco Office , Ooty

7980678968

singh.smart@g mail.com

(ii) What type of relationship exists between table tbl_car and the table

tbl_cust?

1

(e)

What is the impact of changing Frame Rate of a movie?

1

(f)

Rita is trying to make change in the movie. Though the content of layer on stage is visible but no changes can be done to it.What should she do so that she can make changes.

1

(g)

Ms. Reena Sharma is planning to gift an animated digital card to her father on fathers day.She wants to include vector graphics, sound and video. But the size of the movie should be small even if it requires additional plug-in to play

the movie. Which of the following formats are best suited for this purpose:

(i)      GIF

(ii)     JPEG

(iii)     SWF

2

2.

Answer the following questions based on Macromedia Flash:

a)

What is an Animation? Names two types of Tweening.

2

b)

Explain the term stacking order of layers

2

c)

What is a difference between Publishing and Exporting of a movie ?

2

d)

Consider the figure given below and do as directed:

The image on the right hand side shows the position and size of the image for frame 1.

The image on the left hand side shows the position and size of the image for frame 25.

4

3.

Answer the following questions based on HTML:

a)

Fill in the blanks in the HTML code to create a framed web page in the following format:

2

b)

Write the HTML code to generate a Web Page in the format given below :

Consider the following while writing the HTML code

1. Title of the page should be “Save Girl Child”

2. Link colour should be “Maroon”, visited link colour should be “Red” .

3. Heading of page is “violet”

4. Picture used in the page is the file “savegirl.jpg”

5. Table should have a border of width 1, border of table should be “green”.

6. Background of first row is “yellow” and of second row is “cyan”

7. Pages linked to :

At the National level as “national.html” At the State level as “state.html”

At the District level as “district.html

8. Bottom message is of size 2 is linked to email-id savegirl@abc.com

8

4.

Answer the following questions based on ASP: