Laura Bellini
Classification: Paper 2
Page count: 4
Viewed: 243
Last update: 4 months ago
Crash report
Information Technology 9626/02 May June 2024
You can download the full PDF file at the beginning of the description.
### Key and Important Tasks:
1. Database Design and Entity Relationship Diagram (ERD) – Create a conceptual ERD for Jenna’s Jewellery using j24customer.csv, j24order.csv, and j24stock.csv.
2. Data Dictionary Creation – Develop a data dictionary based on j24stock.csv, defining field names, data types, and constraints.
3. Database Normalization and Implementation – Construct a relational database (3NF) with referential integrity enforced, normalizing data from the given CSV files.
4. Data Entry Form – Design a form to facilitate new stock entry into the database.
5. Audio Editing and Processing – Modify j24audio.mp3 by removing silence, changing speed, creating a monophonic mixdown, and exporting in MP3 and OGG formats.
6. Voice Editing and Reverb Application – Edit j24voice.mp3 to add reverb, delay voice start by 10 seconds, and export as MP3.
7. Final Audio Compilation and Mixing – Fade in/out, mute, add voice track, mix into stereo, and export final 27-second audio clip as MP3.
### Key and Important Tasks:
1. Database Design and Entity Relationship Diagram (ERD) – Create a conceptual ERD for Jenna’s Jewellery using j24customer.csv, j24order.csv, and j24stock.csv.
2. Data Dictionary Creation – Develop a data dictionary based on j24stock.csv, defining field names, data types, and constraints.
3. Database Normalization and Implementation – Construct a relational database (3NF) with referential integrity enforced, normalizing data from the given CSV files.
4. Data Entry Form – Design a form to facilitate new stock entry into the database.
5. Audio Editing and Processing – Modify j24audio.mp3 by removing silence, changing speed, creating a monophonic mixdown, and exporting in MP3 and OGG formats.
6. Voice Editing and Reverb Application – Edit j24voice.mp3 to add reverb, delay voice start by 10 seconds, and export as MP3.
7. Final Audio Compilation and Mixing – Fade in/out, mute, add voice track, mix into stereo, and export final 27-second audio clip as MP3.