06. paper 2007-08[1] (11.29)

Upload: kasun-costa

Post on 05-Apr-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    1/19

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    2/19

    Index No .

    2 of 19

    (1) i) Expand the following abbreviations giving their full names (eg.- SL Sri Lanka)

    XML

    UML

    OOAD

    JSP

    ASP

    PHP

    SQL

    OLE

    DSDM

    SWAT

    (20 marks)

    ii) Consider the following statements:-

    (a)A group of researchers study and document the design of the eye of a cat.

    (b)Another group uses that design to create a robot eye which functions like a cats eye.

    The combination of the functionalities given in the above statements (a) and (b) is called

    __________________________engineering, while the functionality of the statement (a)

    alone is called ____________________________ engineering.

    (4 marks)

    iii) Name 2 methods of multitasking/timesharing.

    a.-------------------------------------------

    b.

    -------------------------------------------(4 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    3/19

    Index No .

    3 of 19

    iv) Name 3 methods of multithreading.

    a.

    -------------------------------------------

    b.

    -------------------------------------------

    c.

    -------------------------------------------(6 marks)

    v) Fill in the blanks using the figures (1.1, 1.2, 1.3 and 1.4) as given below.

    figure 1.1 figure 1.2 figure 1.3

    figure 1.4

    Figure 1.3 shows a ___________________________ relationship.

    The relationship shown in figure 1.4 is called a _______________________.

    Figure 1.2 is a notation for _____________________.

    The notation used for _____________________ is given by figure 1.1.(8 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    4/19

    Index No .

    4 of 19

    vi) Fill in the blanks relevant to UML diagrams and to figure 1.5.

    figure 1.5

    The figure 1.5 is referred to in UML as __________________________ diagram.

    Give the UML terms for what you find in the following areas of figure 1.5.

    X : - ____________________

    Y : - ____________________

    Z : - ____________________

    The 3 types of classes in UML are :-

    a. ____________________

    b. ____________________

    c. ____________________

    (21 marks)

    X

    Y

    Z

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    5/19

    Index No .

    5 of 19

    vii) The following is a flow of events in a restaurant. Read it and draw a sequence diagram to

    represent the flow of events.

    Client orders food from the waiter

    Waiter places the order with the cook

    Cook prepares the foodCook informs the waiter

    Waiter picks up the food from the cookWaiter brings the food to the client

    Waiter informs the cook if client wants to order more food

    If client does not want any more food

    Waiter informs cashier to print invoice

    Cashier prints invoiceCashier gives invoice to waiter

    Waiter brings invoice to clientClient makes paymentIf there is a balance

    Waiter gets balance cash from Cashier

    Waiter hands over balance to client

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    6/19

    Index No .

    6 of 19

    (37 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    7/19

    Index No .

    7 of 19

    (2) i) Rajarata Foods Ltd. is a Supermarket chain. Each of its branches has a manager and a

    pharmacist. There is a central store in Colombo. Each week, delivery staff takes needed stocks tothe branches in other cities in delivery vans.

    Stocks are classified as items.

    Each day, there are transactions involving the sale of items.

    Customers come to the branches. Customers, who want to purchase a large amount of goods, canget baskets or carts from the counter.

    Sales people are at the counters of the supermarket branches. Customer relations people are thereto help customers to look for items and to look into their complaints.

    Customers select items they need, and pay the cashier. Some pay by cash, while there are also

    facilities for making payments through credit cards and over mobile phones. The sales assistantspack the goods into shopping bags (marked ABC), and hand them over to the customers.

    Discounts maybe given for various goods, depending on the amount purchased. There is acomplementary gift voucher of Rs. 500/= for each purchase above Rs. 20,000.

    Unsold goods which are past their expiry dates, are sent back to the central store throughdelivery staff, to be given back to the vendors.

    a) Draw a usecase diagram for the above system (state assumptions made).

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    8/19

    Index No .

    8 of 19

    (30 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    9/19

    Index No .

    9 of 19

    b) Fill in the classes given below with the appropriate attributes and methods.

    (28 marks)

    CustomerSalesItem

    BranchPayment

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    10/19

    Index No .

    10 of 19

    ii) Give the names of the Visual Basic 6 tools in the diagram below (figure 2.1).

    figure 2.1

    (21 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    11/19

    Index No .

    11 of 19

    iii) Give the names of the Visual Basic .Net tools in the diagram below (figure 2.2)

    figure 2.2

    (21 Marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    12/19

    Index No .

    12 of 19

    3) i) List 5 advantages of re-usability in the computer software domain.

    a.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    b.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    c.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    d.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    e.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -(9 marks)

    ii) List 7 advantages of the Rapid Application Development lifecycle over the Waterfalllifecycle.

    a.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    b.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    c.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    d.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    e.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    f. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    g.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    (21 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    13/19

    Index No .

    13 of 19

    iii) List 3 Data controls, 3 Components, 2 Containers, 2 Dialogs, 2 Menus and Toolbars and 2

    Printing controls found in VB.Net in the relevant spaces given below: -

    Data controls

    Components

    Containers

    Dialogs

    Menus and Toolbars

    Printing

    (28 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    14/19

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    15/19

    Index No .

    15 of 19

    v) The (VB 6) code given below allows an output value to be calculated and displayed in the

    txtPressure textbox, based on the values input to the textboxes txtArea and

    txtForce.Text

    Calculate the relevant values in the txtPressure textbox for the relevant input values, and

    complete the grid given below: -

    Value

    entered to

    txtArea

    7.000 0.3 49.00 0.100 10.00 120 30.0

    Value

    Entered to

    txtForce

    35 0.900 98 0.2000 100 60 15.0

    Value

    produced

    at

    txtPressure

    (14 marks)

    Private Sub txtArea_Change()

    Dim A, F, P As Double

    A = txtArea.Text

    F = txtForce.Text

    P = F / A

    txtPressure.Text = PEnd Sub

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    16/19

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    17/19

    Index No .

    17 of 19

    iv) Select and list the VB 6 controls the VB 6 interfaces from the following list, and fill in the

    relevant blanks provided.

    Data, OLE, Shape, DirListBox, FileListBox, Picturebox, Image, Form, MDIForm,Data Environment, Data Report, Module, Class Module, DHTML page, Property Page.

    VB 6 controls: -

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------(14 marks)

    VB 6 interfaces: -

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    (14 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    18/19

    Index No .

    18 of 19

    v) Assume that you are given an MS Access database called Northwind.mdb on a Windows

    (2000 or XP) machine. Beginning from the start button, give the relevant steps required to create

    an ODBC driver that connects to this database.

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------------------------------------------(24 marks)

  • 7/31/2019 06. Paper 2007-08[1] (11.29)

    19/19

    Index No .

    19 of 19

    Answer parts vi) and vii) based on the text box given below: -

    vi) Write down 3 lines of the coding given, which indicates that the code in the above text box isfrom an Object Oriented programming language.

    a.-------------------------------------------------------------------------------

    b.

    --------------------------------------------------------------------------------

    c.

    --------------------------------------------------------------------------------(12 marks)

    vii) Write down the names of 3 of the GUI objects / controls in the coding given.

    a.-------------------------------------------------------------------------------

    b.

    --------------------------------------------------------------------------------

    c.

    --------------------------------------------------------------------------------(12 marks)

    PublicClass Form1

    PrivateSub Button1_Click _

    (ByVal sender As System.Object, ByVal e As

    System.EventArgs) _

    Handles Button1.Click

    TextBox1.Text = "Faculty of Science"

    EndSub

    EndClass