A soft drink company wishes to offer an advertisement project to a few advertising companies. Bids
from advertising companies would be evaluated according to the following condition.
If the value of the advertisement project is less then RM10,000 and the client has a good credit records, the bid will be accepted without a deposit. If the value of the projects is less than RM 10,000 and the client does not have a good credit record, the bid will be accepted with a deposit.
If the value of the project is RM10,000 and above and the client has a good credit record, the bid will be accepted without a deposit. If the value of the project is RM 10,000 and above and the client does not have a good credit record, the bid will be rejected.
(a) What is the decision table? Explain the use of a decision table in the analysis phase. (2 marks)
(b) Construct a decision table based on the information above. (5 marks)
The planning phase is the first phase in the system development life cycle. State the purpose of the planning phase and describe two activities that are performed in the phase. (8 marks)
Before a system can be designed, information needs to be obtained to determine user’ requirements. Explain methods of collecting information.
The following is a relational table schema of a database for the students’ unit in a school.
STUDENT (RegisterNum, Name, DateOfBirth, Gender, Stream, Form, Address)
DISCIPLINE (DiscplineCode, Category, Description)
ACTON (RegisterNum, DiscipCode, DataOccured, DataPunished, PunishType, FineAmount)
The STUDENT table contains information about the students who are studying in the school. The DICPLINE table contains information concerning the code, category, and description of a disciplinary offence. The ACTION table contains information concerning board against the student.
a. Write a SQL expressions which satisfy the following queries.
i. List RegisterNum, Name, and Address for all science stream students ( 3 marks)
ii. List the category and description of the disciplinary offence with the code K215 (3 marks)
iii. the fine fo truancy is increased from Rm50.00 to RM100.00 (3 marks)
A Table is a representation for a relational database model
(a) State Four characteristics of a relation
(b) Explain what is meant by a null value of a relational attribute
(c) explain the meaning and guve one example of each of the following types of keys.
i. Candidate Key
ii. Primary Key
iii. Foreign Key ( 6 marks)