Computer Science homework help. 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)