Module Info
DSA8002 – Database & Programming Fundamentals
2021/22
DSA8002 Assignment
Coursework: Object-Oriented Programming meets Database
1. Coursework Brief
Please download the given dataset (DSA8002 (2021-2022)-dataset) which is available on the Canvas through Module/ Assignments/ Coursework: Object-Oriented Programming meets Database-All files/ Download the Coursework Dataset Here: [DSA8002 (2021-2022) -dataset.csv ]
Requirements
a. According to the information in the dataset, define at least three or more classes with essential members and methods. You should design classes with possible inheritance relationship with other classes in mind and at least implement one meaningful inheritance relationship between main classes.
b. For several specific classes, design a proper relational database to store and process the relevant data.
c. Python implementation. That includes:
i. Import the dataset into the programme as a data frame.
ii. Classes implementation
iii. Proper SQL operation wrapper (either function or class) for database operations
iv. Create a database file and table and populate a portion of the data from data frame based on a condition.
v. At least one demo function to show how to use defined classes and SQL operations (i.e., read/update/delete records).
vi. Testing code snippets with proper testing cases
vii. A readme file to describe source code and how to use it.
3. Technical Project report. That includes:
It should contain step by step explanation about why you have done implementation of above criteria’s such as class design, database design, SQL operations, essential key code snippets for illustration etc. Also, For the above course implementation that you have done, create a draft plan to migrate this to QUB’s Azure HDInsight. You should discuss what resources will you be using for the task, and what instructions you need to follow.
4. Guidelines and Submission: A successful submission should at least contain:
a. Project report with source code copied into report.
b. Python source code
c. Database file
d. Readme file
And must be submitted on Canvas (DSA8002 module, Assignments section, Coursework: Object-Oriented Programming meets Database-All files), by 23:59 Sunday, 26 November 2021.
Good Luck!
Coursework
Page 1 of 2