Database Systems (com116 – crn 32466 & 32467) Assignment Specification

Tasks
Task One: Noting any simplifying assumptions you make, design a relational database schema capable of supporting the given business scenario and storing the data provided in the sample data file.
Task Two: Write sql code to implement your database design. You should document your code and use constraints, default values, ON DELETE clauses, stored procedures, triggers, etc as appropriate for the business scenario.
Task Three: Implement your database using either SQL Server OR MySQL and populate it with the data provided in the sample data file.
Task Four: Develop sql code to test that your database supports each of the business processes given above.
Task Five: You are required to produce a vodcast, lasting no more than seven minutes, which provides a walkthrough demonstration of:

• 
  your database design accompanied by a review of the sql code base,
  
• 
  execution of your code to build and populate the database in SQL Server,
  
• 
  execution of the sql queries to demonstrate that your database supports each of the business processes given.
  

The vodcast is the primary element from which the main learning outcomes will be assessed. A detailed guide, outlining what the vodcast should contain, can be found in the Coursework Assignment folder in Blackboard. Vodcasts that go beyond seven minutes will be penalised. (My vodcast to be named as Klaus)
Submission Requirements
Two separate submission areas (1. Report Submission and 2. Vodcast Submission) are provided for the Assignment in the Coursework Assignment folder in Blackboard.
1. Report Submission
A template detailing the required content, structure and production of the report is provided in the Coursework Assignment folder in Blackboard. Please ensure the submitted report is in Word format (.docx file extension) with the filename given as Surname_BCode (e.g., ‘Corr_B00123456.docx’).