PART II 1. Use an appropriate database application to design a database for a school record. Name it School Record in the folder created. [1 mark] a) Create two tables as shown below, defining the fields appropriately: b) tbleRecord [1 mark] Year 2 4 SRecordld Student FName SRDI Julius davidson SRD2 Floyd George SRD3 George Ali SRD4 Martin Luther King SRDS Dubois W. Telephone 0244586788 0545996644 0485621234 0257987654 0302555555 Location Ghana Togo Congo Ghana Ghana 1 1 3 36 tblStudent StID SRecordid Age Program House St1 SRDI 20 LLB NADAA St2 SRD2 BCom. St3 SRD3 15 PhD MILLS St4 SRD4 50 BEcons. KUFFOUR St5 SRDS 20 FORENSICS RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: [1 mark] d) Save the form as GTUCStudentfrm. [1 mark] e) Produce the relationship report and save as GTUCONLINE_report in the database. [1 mark] PART II 1. Use an appropriate database application to design a database for a school record. Name it School Record in the folder created. a) Create two tables as shown below, defining the fields appropriately: [1 mark] b) tbleRecord [1 mark] Year 2 4 SRecordid Student FName SRD1 Julius davidson SRD2 Floyd George SRD3 George Ali SRD4 Martin Luther King SRDS Dubois W. Telephone 0244586788 0545996644 0485621234 0257987654 0302555555 Location Ghana Togo Congo Ghana Ghana 3 tblStudent StID St1 St2 St3 St4 St5 SRecordid SRD1 SRD2 SRD3 SRD4 SRDS Age 20 36 15 50 20 Program LLB BCom. PhD BEcons. FORENSICS House NADAA MAHAMA MILLS KUFFOUR RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: [1 mark] d) Save the form as GTUCStudentfrm. [1 mark] e) Produce the relationship report and save as GTUCONLINE_report in the database. [1 mark] PART II 1. Use an appropriate database application to design a database for a school record. Name it School Record in the folder created. [1 mark] a) Create two tables as shown below, defining the fields appropriately: b) tbleRecord [1 mark] Year 2 4 SRecordld Student FName SRDI Julius davidson SRD2 Floyd George SRD3 George Ali SRD4 Martin Luther King SRDS Dubois W. Telephone 0244586788 0545996644 0485621234 0257987654 0302555555 Location Ghana Togo Congo Ghana Ghana 1 1 3 36 tblStudent StID SRecordid Age Program House St1 SRDI 20 LLB NADAA St2 SRD2 BCom. St3 SRD3 15 PhD MILLS St4 SRD4 50 BEcons. KUFFOUR St5 SRDS 20 FORENSICS RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: [1 mark] d) Save the form as GTUCStudentfrm. [1 mark] e) Produce the relationship report and save as GTUCONLINE_report in the database. [1 mark] PART II 1. Use an appropriate database application to design a database for a school record. Name it School Record in the folder created. a) Create two tables as shown below, defining the fields appropriately: [1 mark] b) tbleRecord [1 mark] Year 2 4 SRecordid Student FName SRD1 Julius davidson SRD2 Floyd George SRD3 George Ali SRD4 Martin Luther King SRDS Dubois W. Telephone 0244586788 0545996644 0485621234 0257987654 0302555555 Location Ghana Togo Congo Ghana Ghana 3 tblStudent StID St1 St2 St3 St4 St5 SRecordid SRD1 SRD2 SRD3 SRD4 SRDS Age 20 36 15 50 20 Program LLB BCom. PhD BEcons. FORENSICS House NADAA MAHAMA MILLS KUFFOUR RAWLINGS c) Using the relations, create the relationships to enable a user to design a form to show the following Student Name: Age: Telephone: House: Location: [1 mark] d) Save the form as GTUCStudentfrm. [1 mark] e) Produce the relationship report and save as GTUCONLINE_report in the database. [1 mark]
