ICDL Using Databases case studies
ICDL Using Databases · Put your knowledge to work in context.
ICDL Using Databases (also listed as Databases, and offered within ICDL Professional) is a certification module that sets out essential concepts and skills relating to understanding the concept of a database and demonstrating competence in using a database application. It is aimed at people who deal with large sets of data and who need to be able to carry out common tasks using a standalone database, from vendor packages to freeware. The ICDL Using Databases case studies are 5 cases and about 2,388 words.
1The Volunteer Rota That Refuses to Sort
A community centre stores its volunteer rota in a single table. Each row is one shift, with fields: ShiftDate (entered as text like 05/03/2024 ), VolunteerName, Role, and HoursWorked.
513 words, about 3 min2The Query That Returns Nothing
A small library database has a Loans table with fields LoanID , MemberID , BookTitle , DateBorrowed , and DateReturned . DateReturned is left blank (empty) while a book is still out.
493 words, about 2 min3The Report That Counts People Twice
A training company has a Bookings table: BookingID , DelegateName , CourseCode , and FeePaid . One delegate can book several courses, so a person appears on multiple rows.
437 words, about 2 min4The Import That Broke the Postcodes
A charity imports a 2,000-row spreadsheet of donors into a new Donors table. The Postcode column in the source mixes formats: SW1A 1AA , sw1a1aa , and a few entries with a leading apostrophe ( 'EC1A 1BB ).
488 words, about 2 min5The Relationship That Multiplied the Totals
A club has two tables: Members(MemberID primary key, MemberName, SubscriptionPaid) with 150 rows, and Payments(PaymentID primary key, MemberID foreign key, Amount, PaymentDate) with 900 rows - members pay in instalments, so several payments per member. A staff member creates a query joining the two tables on MemberID and includes SubscriptionPaid and Amount .
457 words, about 2 min