AS & A Level Information Technology (9626) — May–June 2024, Paper 02

Task 1: Create a conceptual entity-relationship diagram (ERD) for the Jenna's Jewellery database. Save evidence of your ERD in the evidence file.

Task 2: Create a data dictionary for the Stock table. Save evidence of your data dictionary in the evidence file.

Task 3: Create a relational database for Jenna's Jewellery with Stock, Order and Customer tables. Save your database as jewel.

Task 4: Create a data entry form for the Stock table. Save your form in the jewel database file.

Task 5: Edit the audio file j24audio.mp3 to create two tracks: left and right. Save the edited files as left and right in mp3 and ogg format respectively.

Task 6: Edit the voice file j24voice.mp3 to create a voice track with reverb added and the voice starting after 10 seconds. Save the file as voice in mp3 format.

Task 7: Create a final audio mix jewel using the left, voice and right tracks. Save the file as jewel in mp3 format.