📄️ Overview
This section breaks down the project into six main tasks, detailing the specific deliverables for each. The tasks cover database design, data definition and manipulation, creating views, database administration, and developing functions and stored procedures.
📄️ Database Design
As a team, choose one of the 3 variants that you will implement throughout the project. This initial step is crucial as it will define the context for all subsequent tasks. Discuss as a team and select the variant that best matches your interests and learning goals.
📄️ Write DDL
Write a detailed script for creating all necessary database objects according to your finalized DB schema.
📄️ Write DML
Write comprehensive insertion scripts (and deletion or updating scripts if needed) for adding records to the tables in your database.
📄️ Views
Write a script for creating a variety of database views to demonstrate your understanding of different view types and their use cases. Your script should include:
📄️ Database Administration
Write a script that creates:
📄️ Functions & Stored Procedures
Write a script that creates: