Write DDL
Write a detailed script for creating all necessary database objects according to your finalized DB schema.
This includes the creation of tables, primary and foreign keys, indexes, constraints, and any other structural elements required for your database.
Ensure that your DDL script is well-organized, commented, and follows best practices for database design (e.g., meaningful names, modular structure, and clear comments).
The script should be executable in PostgreSQL and should result in a fully functional schema that matches your ER diagram and conceptual schema. Submit your DDL as a single SQL file unless otherwise instructed.
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.