a) i) The first table DATA is given as below:
Student Number Name Address Contact Number
PS001 nick Jalan gegr 03-31482202
PS002 alice Jalan rgrgrg 03-31418901
PS003 simon Jalan efef 03-31248900
PS004 andy Jalan ykytk
03-34216781
PS005 calvin Jalan ykt76k 03-3307654
ii) The second table PERSONAL is given as below:
Student Number Form Stream
PS001 3 SCIENCE
PS002 5 SCIENCE
PS003 3 IT
PS004 4 ACCOUNTS
PS005 3 SCIENCE
iii) The third database FEE is given as below:
Stream No of subjects Fee per subject (RM)
ARTS 12 45
SCIENCE 9 55
ACCOUNT 11 65
IT 10 125
b) Answer all questions :
i) Create all the three tables above. List each table with appropriate
field names and
field types
ii) By using appropriate formula, get and calculate the total fee for all
the students
based on their streams.
ii) Create relationships between all the three tables DATA, PERSONAL and
FEE
iii) Create a creative and appropriate form to key in data for table DATA.
iv) Create a report to display Student Number, Name, Contact Number , Form
and
Total Fee.
v) Create a report to display all field names for all the three tables
