ITICT107A Introduction to Databases Individual Assignment – Database Report & Presentation Assessment Weighting: 15% Final Report Structure: Your final report must comprise the following parts: Title Page o Report title o Names and Student IDs for team members Table of Contents o Should be autogenerated from Heading Styles in MS Word. Background o Requirements / Business Rules o Mission Statement / System Definition o DBMS Selection ERD x2 Use Gliffy.com or draw.io or Visio or any other tool to create the Conceptual model. This is to show your design.Include a screen capture of Designer tab to show table relationships in MySQL. Database Schema o Show each table designForeign Key Constraints o Show as screen captures for all tables with foreign keys.X12 SQL Statements o Show statement and output formatted using Courier New o Statements should be similar to the examples given and may include any of the following elements:WHERE clause with examples of various conditions (Like, Between, =, AND / OR, IN, etc.)ORDER BY clauseConcatenation to combine values including aliasExpressions to calculate results2 or 3 table joins using either new or old syntaxSubqueryFunctions to aggregate data (SUM, MIN, MAX, AVERAGE, COUNT) including sub-totals (GROUP BY)Report o Challenges & SolutionsReferences o Harvard Style o If you do not have any just reference the prescribed text. Introduction to Databases Individual Project (Assignment 5) 2020S2 Introduction to Databases – Development Project Marking Guide Student Name: _______________________________ Student ID#: ___________ I acknowledge that this project is my own work, that there is no collusion with other students, past or present, and that any work used from another source has been correctly cited and referenced (using the Harvard style). Signed: _________________________________ Date: ____________________ Marking Guide for Assignment 2 PARTMARKSA:ER Diagram (entities, attributes, relationships, keys)______ / 5Schema matches ERD Database Design (appropriate data types, field size), Data Integrity (keys), Constraints (FKs)_______ / 2 _______ / 3 _______ / 3Sufficient data / + additional records shown_______ / 2B:SQL & OutputQ1/2Q2/2Q3/2Q4/2Q5/2Q6/2Q7/2Q8/2Q9/2Q10/2Q11/2Q12/2______ / 24C:Normalization of Tables_______ / 4D:Report Layout & Presentation_______ / 7Late Penalties 5% each day lateTotal:_______ / 50 Comments: End of the document Last Modified: 26/07/2018 13 | P a g e
