STPM 2005

State the outcome of coding, testing and installation activities in systems development life cycle (SDLC). [3 Marks]

State and explain two methods of control user access to database system. [4 Marks]

State five methods involved in determining users’ requirements during the analysis phase. [5 Marks]

Explain the meaning and state one aim of each of the following in systems development.
(a) Systems analysis [3 Marks]
(b) Systems design [3 Marks]

A relation EMPLOYEE is given as follows.

EMPLOYEE (EmployeeNum, Name, DateOfBirth, ClubName, Fees)

The functional dependencies given below describe the relationship between the attributes in the relation EMPLOYEE. Assume that EmployeeNum is unique and ClubName is also unique. The primary key for the relation EMPLOYEE is a combination of EmployeeNum and ClubName.

EmployeeNum → Name, DateOfBirth
ClubName → Fees

(a) Give one reason why the relation EMPLOYEE is not in 2NF. [2 Marks]
(b) Decompose the relation EMPLOYEE to 2NF. [4 Marks]

Data is an important asset to an organization
(a) Draw a diagram to explain data hierarchy. [3 Marks]
(b) State three types of data operations [3 Marks]
(c) state four important characteristics of data to assist a manager in making decision. [4 Marks]

The following table consists of information concerning project supervision for the final year students in a university.

(a) Write SQL expressions for the following
i. List all the names of supervisors who supervise the multimedia project ( 3 marks)
ii. List the names of students and project fields for all the students supervised by Radziah binti Husin. (4 marks)

(b) State the output of the following query

FROM ProjectSupervision
WHERE Supervisor = ”Jamil bin Adnan”
ORDER BY ProjectField; (3 marks)

Encik Ali has just opened a video rental business. The types of videos rented are DVD and VCD. He has requested you to develop a database system that could assist him to manage his business. The business rules needed are as follows.

(a) Construct an entity relationship (E-R) diagram to model the above scenario as follows.
(i) Draw all the entities with their associated attributes. [4 marks]
(ii) Indicate the relationship between all the entities and draw the descriptive attributes. [2 marks]
(iii) Indicate the cardinalities of all the respective relationships. [2 marks]
(iv) identify and underline the primary key attribute for each entity [ 2 marks]

(b) Map the entity relationship (E-R) diagram constructed above to the corresponding relational schema (6 marks)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s