15 Krazy Karts is a company which organises go-kart driver training and races. Customers can book a course of training sessions with a trainer. At the end of each session each customer in the session races against the others and the trainer records the finishing positions each week. All the information for the company is held in a database with the following tables and fields. (see paper) a Using the information above create an entity relationship diagram of the Krazy 1 mark for four entities correctly named Karts database system. 1 mark for 1:M (League to Customer) 1 mark for 1:M (Customer to CustomerCourse) 1 mark for 1:M (Course to CustomerCourse) Max 4 marks (naming of the relationships is not required for the marks) 4 b The following report is produced for the Create a query with the following fields and system. (see paper) criteria: Describe how the company would use Customer Name = (accept “C.Burton” the database software to produce this Customer Number = 621) report. Course.Course Title = cc Karts” “100 Fields included: CustomerCourse.Date, Course.Course Code (accept CustomerCourse.Course Code, Course.Course Title Requires link/relationship between Customer/CustomerCourse and Course to be implemented. Ordered by Date Ascending 1 mark each bullet, max 5 marks 5 c The following form is used to enter the Add checkbox/selector for male/female for details of customers enrolling. gender (see paper) Add Combo/Lookup for League Title. Add a Submit button to provide clarity on Describe two ways of improving the how to update/add customer details. usability of this form. Auto-complete address based on address database. 1 mark each bullet, max 2 marks 2
15 Krazy Karts is a company which organises go-kart driver training and races. Customers can book a course of training sessions with a trainer. At the end of each session each customer in the session races against the others and the trainer records the finishing positions each week. All the information for the company is held in a database with the following tables and fields. (see paper) a Using the information above create an entity relationship diagram of the Krazy Karts database system. 1 mark for four entities correctly named 1 mark for 1:M (League to Customer) 1 mark for 1:M (Customer to CustomerCourse) 1 mark for 1:M (Course to CustomerCourse) Max 4 marks (naming of the relationships is not required for the marks) 4 b The following report is produced for the system. (see paper) Describe how the company would use the database software to produce this report. Create a query with the following fields and criteria: Customer Name = “C.Burton” (accept Customer Number = 621) Course.Course Title = “100 cc Karts” Fields included: CustomerCourse.Date, Course.Course Code (accept CustomerCourse.Course Code, Course.Course Title Requires link/relationship between Customer/CustomerCourse and Course to be implemented. Ordered by Date Ascending 1 mark each bullet, max 5 marks 5 c The following form is used to enter the details of customers enrolling. (see paper) Describe two ways of improving the usability of this form. Add checkbox/selector for male/female for gender Add Combo/Lookup for League Title. Add a Submit button to provide clarity on how to update/add customer details. Auto-complete address based on address database. 1 mark each bullet, max 2 marks 2
Perfect-Papers-2015A-Marking-Scheme.docx