INF3707: Database Design and Implementation Assignment 03: Memo Guide

Description

Master INF3707 Database Design & SQL with Confidence!

Struggling to connect database theory with practical SQL execution? The INF3707 Assignment 03 Comprehensive Exemplar Guide (2026 Edition) is designed to turn complex database requirements into clear, step-by-step solutions.

Whether you are working with MySQL Workbench for the first time or refining your advanced programming logic, this 8-page executive guide walks you through every single requirement with clean, tested code and detailed theoretical breakdowns.

What’s Covered Inside This Guide?

• Question 1: Using the UNION Operator
  Learn how to merge multiple SELECT statements and generate calculated status columns (ship_status) from your Orders table.
• Question 2: Aggregate Functions & GROUP BY
  Master database summarization by grouping product categories to calculate catalog depth (COUNT) and peak pricing (MAX).
• Question 3: Subqueries with IN
  Filter database sets cleanly using independent subqueries without relying on unnecessary multi-table joins.
• Question 4: Creating Tables & ERD Schema Design
  A complete script to build a relational schema (users, products, downloads) from scratch—including PRIMARY KEY and FOREIGN KEY constraints, InnoDB engine setup, and utf8mb4 character encoding.
• Question 5: Creating Virtual Views
  Simplify complex reporting by building reusable dual-join views (customer_addresses) for billing and shipping records.
• Question 6: Stored Procedures with Control Flow Logic
  Write procedural programming logic using IF...ELSE statements and declared variables to validate table data.
• Question 7: Stored Procedures with Input Parameters
  Build parameterized procedures (IN parameters) to insert records dynamically, complete with success and duplicate-key error testing workflows.

Why Choose This Study Guide?

• The #1 Guide for Beginners: We don’t just give you the code—every question starts with a Key Concept breakdown explaining why the SQL commands work.
• Step-by-Step Execution Instructions: Follow a clear, bulleted workflow for MySQL Workbench from opening query tabs to capturing output logs.
• 100% Tested & Formatted SQL Scripts: Clean, professionally indented code that is easy to read, analyze, and practice.
• Screenshot Verification Checklists: Built-in guidance on what your Action Output window and Result Grids should display so you can verify your work immediately.

Product Specifications

• Format: Digital PDF Download (8 Pages, Executive High-Resolution Layout)
• Edition: 2026 Academic Year
• Author: Decksh Dalosha | Dalosha Academy
• Compatibility: MySQL Server & MySQL Workbench

Academic Integrity Disclaimer: This document is an exemplar guide created exclusively for educational and study purposes. It is designed to assist students in understanding database design principles and SQL syntax. It is not intended for direct submission.