PART II 4. Use an appropriate database application to design a database for a school record. Name it SchoolRecord in the folder created. a) Create two tables as shown below, defining the fields...

Please help solve

Extracted text: PART II 4. Use an appropriate database application to design a database for a school record. Name it SchoolRecord in the folder created. a) Create two tables as shown below, defining the fields appropriately: b) tbleRecord SRecordld Student FName Year Telephone Location SRD1 SRD2 Julius davidson 2 0244586788 Ghana Floyd George George Ali Martin Luther King Dubois W. 4 0545996644 Togo Congo Ghana SRD3 1 0485621234 SRD4 1 0257987654 SRD5 3 0302555555 Ghana tblStudent STID SRecordId Program LLB House Age 20 St1 SRD1 NADAA St2 SRD2 36 BCom. МАНАМА St3 SRD3 15 PhD MILLS St4 SRD4 50 BEcons. KUFFOUR St5 SRD5 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: d) Save the form as GCTUStudentfrm. e) Produce the relationship report and save as GCTUONLINE_report in the database.