Computing Revision 6

COMPUTING 958 PAPER 2 REVISION 6 1. What is meant by virtual reality ?

[3]

2. During the process of planning Phase, system analysts might have to pay attention upon hardware requirement. What are the requirements ? [4] 3. What is an authoring tools ? Support your answer with 2 examples.

[4]

4. In the process of developing a multimedia presentation, many considerations have to be taken into account, such as the focus, the objective and the impressiveness. How do you play with the multimedia elements for a multimedia presentation for the ANTI SMOKING campaign ? [5] 5. The computerized system in the school library has a record of the borrowers with all theirs personal particular, the books they borrowed, the date of borrowing and the records of all material in the library. Write the SQL expressions for each of the situation below. (a) search the title of the books with the code “401”. (b) search those books with the due date of today.

[6]

6. State briefly the following format that is used for a multimedia creation. (a) Mpeg (b) Jpeg (c) mp3 (d) html

[8]

7. At the end of the month, the attendance of the employees is electronically sent to the account department. In the computer system of the account department, the payroll data is called from the record, verified and validated, producing a new file of valid transaction. This file is used to update the employee master file, payslips are printed and funds are electronically transferred to the employees’ bank accounts. Complete the DFD for the description above. Attendance

[10]

2

TBH…

COMPUTING 958 PAPER 2 REVISION 6 8

In Implementation Phase for the process of a DBMS development, Coding, Evaluation and Training are some of the steps. Briefly explain each of these steps. [9]

9. A water purifier company has a database system to help manage it service to tits clients. The database has the water purifier table, service table and the client table as follows. WATER PURIFIER WaterPurifier_id Capacity Price Date_Purchase Colour_Code

SERVICE Client_ID Service_ID WaterPurifier_id Technician_ID Last_service_Dat e Service_charge

CLIENT Client_ID Client_Name I_C_Num Address Contact_Num

(a) Draw an entity relationship (E-R) diagram to show the relationships and the cardinalities between the files. [6] (b) Map the E-R diagram that you have drawn to a relational database schema.

[4]

10. The data requirements for a booking system are defined as follows. An agency arranges hourly working maids/workers for households and office. Each maid/worker is registered with the agency and has her/his name recorded together with the skill, identity card number, address, contact number and rate. Every client that calls up the agency will has its person-in-charge, contact number, address and task, duration, time, date and day recorded. Each task is managed by a supervisor cum van driver. Each supervisor is assigned with a van. The supervisor has his name, address, contact number and van registration number recorded. The agency records details of each assignment. A maid/ worker will never have more than ONE assignment per day. (a) In database modeling, what is (i) an attribute (ii) a relationship

[2] [2]

(b) Write a schema for the assignment relationship and determine the primary key. [6] (c) Draw a functional dependency diagram for the ASSIGNMENT relationship. [4] (d) Show the normalization steps in ASSIGNMENT up to third normal form.

3

[7]

TBH…