1. State the project title
2. State the project objective
3. Create all the required table
4. Name each table
5. State the filed names for each table
7. State the primary key
8. Draw the line to show the relationship
9. Create a form for each table
10. Enter data into the tables
11. Create the querry from two table
12. Create the report base on the querry created
13. Submit the report form an a softcopy of the developed database project
Questions LA6.S12.1
SITUATION 1
Pn. Saripah has problem in preparing a list of students who are taking part in the sports day events based on their houses and age categories. As an ICT student, you are asked by Pn. Saripah to develop an Annual Sports Day Information System (ASDIS) to assist her in preparing the list.
In the system, your are required to :
(a) create a database that consist of two tables, namely table STUDENT and table SPORTS_HOUSE. The database should store student ID, name, gender, sports house and age category.
(b) enter at least four sports houses into the HOUSE table.
(c) enter at least two participants’ data for each age category of different houses.
(d) create a query that links the two tables.
(e) create a form based on the query in (d). The form must show the title given and descriptive labels.
(f) create a report based on the query in (d). The report must show the participants for each category of different sports houses.
Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the softcopy of the information system to your teacher at the end of the assessment session.
SITUATION 2
The form teachers of your school are required to submit a report on the monthly test results of each student to the school administration. As an ICT student, you are asked to develop a Test Marks Information System (TMIS) to assist the teachers in recording the subject marks obtained by each student. TIMS should generate a report to show the subject marks, total marks and average marks of the students from each class.
In the system, your are required to :
(a) create a database that consist of two tables, namely table STUDENT and table CLASS. The database should store student ID, name, class, form teacher and marks for each subject taken.
(b) enter at least four classes into the CLASS table.
(c) enter at least two students’ data for each class.
(d) create a query that links the two tables. The query should be able to calculate the total marks and average marks for each student automatically.
(e) create a form based on the query in (d). The form must show the title given and descriptive labels.
(f) create a report based on the query in (d). The report must show the subject marks, total marks and average marks of the students from each class.
Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the softcopy of the information system to your teacher at the end of the assessment session.
SITUATION 3
Bestari Computer Center (BCC) deals with computer sales and services. The BCC owner faces difficulties in tracking its business services. You are asked to help the owner to develop a computerized management system called Bestari Information System (BIS).
In the system, your are required to :
(a) create a database that consist of two tables, namely table CUSTOMER and table SERVICE The database should store customer ID, customer name, customer address, customer telephone number, date of service, description of service.
(b) enter at least four records into the CUSTOMER table.
(c) Enter at least six records into the SERVICE table.
(d) create a query that links the two tables.
(e) create a form based on the query in (d). The form must show the title given and descriptive labels.
(f) create a report based on the query in (d). The report must show the service record for each customer.
Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the softcopy of the information system to your teacher at the end of the assessment session.
