Please complete all of the following details and then make this sheet the first page of each file of your assignment – do not send it as a separate document.

Your assignments must be submitted as either Word documents, text documents with .rtf extension or as .pdf documents. If you wish to submit in any other file format please discuss this with your lecturer well before the assignment submission date.

Student Name :
Student ID No. :
Unit Name : Database Systems
Unit Code : CSC72001
Tutor’s name :
Assignment No. : Assessment 2
Assignment Title :
Due date :
Date submitted :


Declaration :

I have read and understand the Rules Relating to Awards (Rule 3 Section 18 – Academic Misconduct Including Plagiarism) as contained in the SCU Policy Library. I understand the penalties that apply for plagiarism and agree to be bound by these rules. The work I am submitting electronically is entirely my own work.

Signed :
(please type your name)
Date :

Table of contents:

Contents

Table of contents :
Entity Relationship Diagram
Part A : Analysis
 1. Client Business Rules
 2. Assumptions Made
 3. Naming Conventions
 4. Data Types Chosen
Part B : Testing Queries
 B.6.1 Workshop Enrolment List
 B.6.2 Workshop Count List
 B.6.3 Student Transcripts
 B.6.4 Student Assessment Totals

Entity Relationship Diagram

Part A: Analysis

1. Client Business Rules < rule 1 > < rule 2 > < rule 3 > < rule 4 >
2. Assumptions Made < information about your assumptions goes here >
3. Naming Conventions To keep consistency, the database will use strict naming conventions that will allow easy implementation and maintenance of the database when completed. The following conventions apply: < convention 1 > < convention 2 > < Etc >
4. Data Types Chosen < Information about why you have chosen the data types you have chosen for your database. >

Part B : Testing Queries

B.6.1 Workshop Enrolment List
Query :
Paste your actual query here (not a screenshot)
Result :
Paste a screenshot of your query results here. (Hint: Snipping tool in Windows may help)

B.6.2 Workshop Count List
Query :
Result :

B.6.3 Student Transcripts
Query :
Result :

B.6.4 Student Assessment Totals
Query :
Result :

To Download Click Here > CSC72001 S1 Assessment 2 Report Template.pdf