ICT103 Database Systems
Semester 1, 2024
Assignment 1
Due Date : 23 October 2024.
Release Date : 2 October 2024.
Value : 25% of final total.
Assessment Type : Group Assignment.
Requirements
You are to create a database design specification including conceptual data model, relational
data model, and physical database from a given business description. You should present this
in both report and class presentation which also includes a short discussion of the role of a
database administrator. This assignment is to be carried out and reported as a group.
1. You will need to submit the report with headings according to the required tasks below.
2. You will need to present all tasks in this assignment.
Case Study: GreenWaste Recycling Initiative
In response to the increasing environmental challenges posed by waste management and
pollution, many communities worldwide are striving to adopt sustainable practices. Initiatives
like the "Waste Warriors" and "Recycle Right" campaigns aim to promote recycling, reduce
landfill waste, and encourage community participation in sustainability efforts.
The GreenWaste Recycling Initiative is an information system designed to facilitate the
management of recycling programs and to track contributions from community members and
local businesses. This system connects donors who want to contribute materials for recycling
with organizations dedicated to environmental sustainability. Donors can offer recyclable
goods or financial support to help with recycling efforts. While donor identities remain
confidential, the contributions made are recorded, enabling organizations to track what
materials they receive and how they are utilized.
Key Data Captured:
Contribution Details: Each contribution is assigned a unique Contribution ID. For recyclable
goods, information such as the type of material (plastic, paper, metal), quantity, and estimated
value are captured. For financial donations, details such as amount, payment method, and
transaction reference number are recorded.
Organization Details: Each recycling organization is identified with a unique Organization
ID. Their name, address, and a description of their recycling initiatives are recorded.
Organizations can create multiple appeals for recyclable materials or funding, tracked by a
unique Appeal ID. Information such as the start and end dates, a detailed description of the
appeal, and the outcome of each appeal are maintained.
Appeals and Disbursements: Appeals can receive multiple contributions, leading to various
disbursements for different recycling projects. Some appeals may receive substantial
contributions, while others may not yield any materials or funding. Each appeal's effectiveness
can be measured by the amount of materials processed or financial resources allocated to
specific projects.
User Details: The primary users of the system include community members wishing to donate
recyclable materials or funds, as well as representatives from recycling organizations. User
information includes username, password, full name, address, email, and mobile number. Each
community member is assigned a unique Donor ID, and their address and previous donation
history are recorded to encourage further participation.
Donation Records: Community members and organizations can track their past contributions
through a record system that captures Donation ID, type of contribution (goods or cash), date
of contribution, and any associated project or initiative.
The GreenWaste Recycling Initiative empowers communities to engage in sustainable
practices by connecting donors with organizations focused on recycling and environmental
preservation. The system ensures that contributions are effectively managed and utilized,
fostering a collaborative effort towards a cleaner and greener environment.
TASK 1: Strategy and Analysis (20 marks)
Based on the above Case Study,
a) Identify 4 or more entities and attributes of the entities including key attributes. Identify
3 relationships involving the above 4 or more entities.
b) Give FIVE (5) examples of data that need to be stored in the database.
c) Give FIVE (5) examples of information that can be obtained from the database once it
has been created.
d) List up to FIVE (5) assumptions and/or business rules that you make about the system
and database.
TASK 2 Conceptual Data Model (20 marks)
Develop the Conceptual Data Models showing entities, attributes, data constraints, and
relationships.
Marking Rubric:
MARKS
REQUIREMENT CRITERIA
ALLOCATED
TASK 1 Correct required data listed 10
Strategy and Suitable information identified
6
Analysis from data
(20 marks) Assumptions discussed
4
TASK 2 Suitable entities, relationships,
10
Conceptual Data cardinalities, optionality identified
Model Suitable intersection entities
(20 marks) 10
identified
TOTAL 40
