Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    Skaa4412 15-16 1

    Uploaded by

    lakeli6035
    Civil Engineering Information System 3

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Skaa4412 15-16 1

    Uploaded by

    lakeli6035
    2 views4 pages
    Civil Engineering Information System 3

    Original Title

    SKAA4412 15-16 1

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Civil Engineering Information System 3

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2 views4 pages

    Skaa4412 15-16 1

    Uploaded by

    lakeli6035
    Civil Engineering Information System 3

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    SAB 4412 / SKAA 4412 1

    FINAL EXAMINATION
    SEMESTER 1, SESSION 2015/2016

    COURSE CODE : SAB 4412 / SKAA 4412

    COURSE : CIVIL ENGINEERING INFORMATION SYSTEM

    PROGRAMME : SAW / SKAW

    DURATION : 2 HOURS

    DATE : DECEMBER 2015

    INSTRUCTION TO CANDIDATES:
    1. ANSWER ALL QUESTIONS.

    WARNING!
    Students caught copying/cheating during the examination will be liable for disciplinary
    actions and the faculty may recommend the student to be expelled from the study.

    This examination question consists of ( 4 ) printed pages only.


    SAB 4412 / SKAA 4412 2

    Q1. (a)

    FIGURE Q1

    Based on Figure Q1, explain how Data evolve to become Wisdom. Give an
    example related to any Civil Engineering disciplines to show your
    understanding of Figure Q1.
    (9 marks)

    (b) The first stage of the System Development Life Cycle (SDLC) is ‘planning’
    where it involves the planning of several management activities, which are
    divided into parts.

    (i) List four (4) important parts in planning.


    (ii) Discuss how these four in (i) can affect the planning of a system
    development.
    (16 marks)
    (25 marks)

    Q2. (a) There are rules to follow when drawing the Data Flow Diagram (DFD).
    Explain five (5) rules of DFD with the help of related diagrams.
    (10 marks)

    (b) Table Q2 lists the components of the Level 2 DFD of an information system.
    By referring to this table, draw the DFDs for levels 2, 1 and 0 (context
    diagram).
    SAB 4412 / SKAA 4412 3

    Table Q2
    Process Flow Terminator Data Store
    A11 Data a A – Source
    Data b D – Source
    Data l
    Data m
    A12 Data m
    Data C E – Source
    Data n
    A13 Data l
    Data n
    Data e
    Data d
    B21 Data d
    Data f D – Sink
    Data p
    B22 Data p
    Data g
    C31 Data e
    Data s
    Data i B – Source
    Data t
    C32 Data s
    Data t
    Data h
    D41 Data g
    Data h
    Data w
    Data x
    D42 Data w
    Data j B – Sink
    Data v
    D43 Data x
    Data y
    Data k C – Sink
    (15 marks)
    (25 marks)
    SAB 4412 / SKAA 4412 4

    Q3. (a) By using the database, many problems that occur from the usage of traditional
    methods to manage data can be reduced or eliminated. Give examples on how
    database can solve the problems in traditional methods.
    (10 marks)

    (b) What is a prototype? List and explain three (3) advantages of prototype in
    developing new civil engineering system.
    (15 marks)
    (25 marks)

    Q4. (a) What are the differences between primary key and foreign key in Entity
    Relationship Diagram (ERD)?. Briefly discuss the use of both keys in
    Database Management System (DBMS).
    (8marks)

    (b) Figure Q4 shows an incomplete ERD.

    (i) Redraw and complete the ERD.


    (ii) Develop table for each entity in the ERD and include at least two (2)
    sample records for later development of a database system using
    Microsoft Access.

    CONTRACTOR
    CLASS

    TENDER CONTRACTOR SUPPLIER

    DRAWING QUANTITY
    SURVEYOR

    FIGURE Q4
    (17marks)
    (25 marks)

    You might also like