Write DML
Write comprehensive insertion scripts (and deletion or updating scripts if needed) for adding records to the tables in your database.
Each table should have at least 10 records, representing realistic and meaningful data relevant to your chosen variant.
Your DML scripts should demonstrate the ability to populate the database, test constraints, and support the core functionality of your application. Use realistic and, if possible, anonymized data.
If deletion and update scripts are not relevant for a table, briefly explain why in your documentation.
Include comments to clarify the purpose of each section and ensure your scripts are easy to understand and execute. Submit your DML as a single SQL file unless otherwise instructed. Scripts should be executable in PostgreSQL.
On top of the code and documentation deliverables, each team member must record a short video (approximately 2 minutes per person) describing the part of the solution they were responsible for. The video should briefly explain your contribution, the challenges you faced, and how you addressed them. The free version of Zoom allows recording of videos during a conference call, making it easy for teams to collaborate and record together. Once recorded, the video can be uploaded to Google Drive or YouTube (as an unlisted video), and the link should be provided as part of the graded material.