SQL Relational Database Implementation and Analyses

Assessment Cover Sheet and Feedback Form 2019/2020

Course Code:

UC1PR2101

Course Title:

Programming & Databases

Lecturer:

Johan van Niekerk and

Rayne Reid

Assignment No: N/A

Total number of pages, including this page: 3 + Jupyter Notebook template

Maximum Word Count: Not specified

Assignment Title:

Assignment 3 of 3: Relational Database Implementation and Analyses

Date Set:

30.04.2020

Submission Date:

22.05.2020 (14:00)

Feedback Date:

12.06.2020

Section 1: Submission

Record of Submission and Plagiarism Declaration

In submitting this work you declare that this assignment is your own work and that any collaborative work or existing material has been specifically indicated in the text. In submitting this assignment you agree that this work may be submitted for plagiarism testing. Work should be submitted:

• Electronically Via Moodle in all cases. • If problems are encountered you may email the course staff for assistance.

However, it remains the student’s responsibility to ensure the submission to the LMS was made.

Assignments submitted in digital form MUST use the following file naming convention: COURSECODE_SURNAME_ITEMNUMBER , where ‘item number’ refers to the number order of each file begin submitted for this assessment. For example, UC1PR2101_ENGELAND_1 Digital assignments must be handed in as a Jupyter Notebook .ipynb file. Please refer to the provided tenplate. Late submissions will result in zero grade, unless agreed with course leader in advance.

IT IS YOUR RESPONSIBILITY TO KEEP A COPY OF ALL SUBMITTED WORK.

2

Section 2: Assignment Details Consider the following scenario. You will be required to complete the provided Jupyter notebook file in order to produce a report to answer each of the subsequent questions. You will need to make some assumptions in order to complete your solution, please state clearly any assumptions you make in the provided reflection section after each of the tasks. Solutions must be appropriately formatted and professional looking. Only the Jupyter notebook file (.IPYNB) will be submitted for grading. Scenario

“Academic Booksellers Inc is a new online book retailer. They specialise in selling academic textbooks and ship orders worldwide at no additional charge. All their books are sourced from specialised academic publishers. Customers often order multiple books, or even multiple copies of each book, in the same order.” A design team has already produced the following ERD for the business database. Primary keys of all tables should be autoincrement integers. All currency values should be stored as real numbers, quantities as integers, and other fields, including phone numbers, should by stored as text.

3

NOTE: This is an individual assignment. You are therefore required to work

independently on your solutions. Group work will not be accepted.

Section 3: Marking and Assessment This assignment will be marked out of: Task 1 – DDL and Database Creation DDL SQL Statements Reflection Task 2 – Database Schema Exploration Task 3 – Business Logic and DML Stored Procedure 1 Stored Procedure 2 Stored Procedure 3 Reflection and additional information Task 4 – Queries and Data Exploration Report 1 Report 2 Report 3 Report 4 Report 5 Reflection and Assumptions

100%

20% 15% 5%

10%

40% 10% 10% 15% 5%

30%

5% 5% 5% 5% 5% 5%

Contribution to the final course mark: 50% Estimated number of hours to be spent on this assignment: 35

The pass grade for this assignment is 40% Feedback for this assignment and a breakdown of the final grade will be provided via the LMS (Moodle). The final course grade composed of this and any other assignment(s) will be awarded in the range A-F and recorded in the primary student information system (e.g. ECS)