Computer Science · Paper n° 3 · GCE · Advanced Level · June 2020
Préparation du PDF…
Quiz Flash
Testez vos connaissances avec un quiz généré par IA basé sur cette épreuve.
Connexion requise
Connectez-vous pour lancer les quiz Flash IA et garder votre progression.
Exercices, méthodes & corrigés (2)
Chaque exercice de l’épreuve est isolé par l’IA : lisez l’énoncé, ouvrez la méthode pour être guidé sans réponse, ou le corrigé pour la résolution complète.
Méthodes et corrigés
Créez un compte gratuit puis passez en Premium pour débloquer la méthode guidée et le corrigé de chaque exercice.
Task 1
Database Management
The Cameroon Ministry of Transport has an agency that stores information about vehicles and their owners. Ea vehicle is registered with this agency and must be insured before it can be driven. Details of the vehicles, owners a insurance policies are stored in a relational database using the following three relations: Vehicle(RegistrationNumber, OwnerID, Manufacturer, Model, Colour, EngineSize, DateRegistered) Owner(OwnerID, Title, Name, Surname, HouseNumber, Street, Town, Postcode) Insurance(PolicyNumber, Registration Number, DateStarted, PolicyType, ExcessAmount) In this system, the following restrictions apply to some attributes: • Registration Number: a mixture of exactly 7 letters and numbers, eg; MA11FXB. • EngineSize: a whole number representing the capacity of the engine, eg; 1597. • Policy Type: The type of insurance policy. It is either 'Comprehensive' or 'Third Party. • ExcessAmount: a monetary value, eg, 100. (i) In your answer booklet use the Data Definition Language (DDL) of SQL to create the Insurance, Owner a Vehicle relational tables. Identify the primary key for each. (3, 3, 3 mark) (ii) The owner of the vehicle with registration number DF24JUT repainted his car to pink. Write an SQL statement to update the Vehicle table so that it reflects this change. (2 marks) (iii) A police officer checks out some details about the car with registration number AB72XHC and its owner. Write an SQL query to obtain the Model and Colour of the car, and the Name and Surname of the car's owner. (3 marks) The database is to be extended to store information about vehicle safety certificates. Vehicles do a yearly roadworthine test. A vehicle that passes the test is issued a roadworthiness certificate that has a unique certificate number and is val for 12 months from the date the certificate is issued. The certificate also has the name of the garage that issued it. database is used to hold the details of certificates as well as the record of all certificates ever issued to each vehicle. F a particular vehicle, the record includes its current certificate together with all certificates issued to it in the past. (iv) Using the SQL DDL create a table that holds information about safety certificates. (3 marks) (v) Implement a relational database for the tables in (i) and (iv) above using DBMS of your choice. (4 marks) (vi) Implement the relationship graph between entities in (v) above and print a copy. (4 marks)
Task 2
Programming Concepts
Task 2-Council data The local council in your area has decided to record information about all its inhabitants. It started this activity b recording the names of all the people in the council area. You have been contracted to propose a computer application carry out this task. Bert Jeff Gary Neba Chang | Olga Nora Mary Vera Rani Neil Jill Cain Lara Bart Table 1. Instructions: In your answer booklet caly write down which of the C or Pascal programming language you will u throughout the following programming exercise. The algorithms given in the Figures are in a pseudocode based on and Pascal and where ← is for assignment and // starts a comment.
Note ma copiePremium
Photographiez votre copie et recevez une correction détaillée avec une note sur 20. Jusqu’à 5 copies par jour.
Connexion requise
Connectez-vous pour envoyer une copie et recevoir une correction IA détaillée.