CSE2/4DBF (2025) – Assignment 1 Page 1/3

CSE2/4DBF 2025
Assignment 1 (20%)
Due date: this week

AIMS AND OBJECTIVES:
✓ to represent a problem description given in natural language as an (Enhanced) EntityRelationship model
This is an individual Assignment. You are not permitted to work as a group when writing
this assignment. The use of generative AI to produce the solution (or part of it) is prohibited.
Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives
the impression that the work is your own. The Department of Computer Science and Information
Technology treats plagiarism very seriously. When it is detected, penalties are strictly imposed.
Late Submissions and Extensions:
Penalties are applied to late submissions (5% of total assignment mark is deducted per day,
accepted up to 5 days after the due date only).
If you are unable to submit an assignment by the due date due to unexpected or difficult
circumstances that affected your ability to prepare, you can apply for a Short Extension of Time
and request an extension by selecting the “3-day extension request” option in Assessment 1 section.
If you have experienced acute, significant and unexpected circumstances that substantially affect
your ability to complete an assessment to the best of your potential, you may be eligible to apply
for Special Consideration.
See subject learning guide for policies surrounding extension applications. Note that delays caused
by computer downtime cannot be accepted as a valid reason for a late submission without penalty.
Students must plan their work to allow for both scheduled and unscheduled downtime.
SUBMISSION GUIDELINES:
This assignment is to be submitted in soft-copy (either PDF or JPEG) format using
the CSE2/4DBF submission link on LMS, by 11.59PM Sunday, August 24th 2025.
The submission link can be found under “Assignment 1” component in the
“Assessment” section of the subject’s LMS page.
SUBMISSION CHECKLIST:
✓ Your (Enhanced) Entity-Relationship Model (EER) for the proposed database
Students are referred to the Department of Computer Science and Information Technology’s
Handbook and policy documents with regard to plagiarism and assignment return, and also to the
section of ‘Academic Integrity’ on the subject learning guide.
CSE2/4DBF (2025) – Assignment 1 Page 2/3

PROBLEM DESCRIPTION:
Community Garden Initiative
One city of council is broadening its Community Garden Initiative to create a network of green
spaces that not only encourage sustainable living but also foster education, health, and community
engagement. These gardens serve as shared hubs for gardening, workshops, volunteering, and
public events, and a new centralised database is required to manage all operations.
Each Garden has a unique name, street address, contact phone number, and a general email account.
Every garden is overseen by exactly one garden manager, who must be a member of the staff
assigned to that garden. The city employs a variety of staff members. Each staff member has a
unique employee number, a Working With Children Check (WWCC) number, and their own phone
number and email address. A staff member is assigned to exactly one garden and exactly one staff
member in each garden must hold the manager role at any given time.
In addition to staff, the initiative works with professionals such as horticulturists, permaculture
experts, and sustainability educators. Each professional has their own unique professional ID,
contact phone, email, and multiple qualifications. A professional may be affiliated with more than
one garden but can only supervise events at gardens where they are formally affiliated.
Any member of the public can join the initiative by registering as a member of one or more gardens.
Members have a unique membership ID, along with their name, address, phone number, email, and
date of birth. Each membership is linked to a single garden and records the start date and (if
applicable) an end date. A member can have multiple memberships over time, but no more than
one active membership per garden.
Each garden contains multiple plots, each identified by a plot number unique within that garden.
Plots may be used for different purposes and have different features. They are classified into one
of three types: “Vegetable”, “Herb”, or “Flower”. A plot may or may not have an irrigation system,
and some plots have a seating capacity because they are suitable for group activities. Plots can be
either private plots, which are rentable to members for a season, or shared plots, which cannot be
rented and are used for community activities such as training sessions or workshops.
Private plots are rented per season (e.g., “Spring” or “Autumn”) and year. Only members with
active membership in a garden can rent a private plot there, and a plot can be rented to only one
member per season. Rentals have a status (active, completed, or cancelled) and may have
maintenance notes such as “Overgrown” or “Needs irrigation repair”.
Gardens host a variety of community events, including composting tutorials, planting workshops,
organic farming classes, and sustainability talks. An event has a unique title and description, start
and end dates, a weekly time slot, and a target age range. Every event is linked to exactly one
garden and takes place in a plot suitable for group activities. Some events are one-off, while others
are part of a recurring series. Recurring events consist of multiple event sessions, each with its own
date, time, and (if necessary) a different plot location from the main event’s assigned plot.
Every event is supervised by one professional and may have multiple staff members assisting.
Event assistance and professional supervision are recorded so that reports can show all contributors.
CSE2/4DBF (2025) – Assignment 1 Page 3/3

Members can sign up for event sessions either as participants or as volunteers. Volunteers may be
assigned one or more specific tasks (e.g., “Set up chairs”, “Manage registration desk”). Only
members who meet the event’s age requirement and have an active membership at the hosting
garden on the session date can participate or volunteer. Attendance is recorded for each session,
showing whether the member attended, missed, or cancelled.
After attending an event, a member may submit feedback containing a rating (1-5), optional
comments, and whether they would recommend the event. A member can only give feedback for
an event they actually attended and may submit only one feedback per event.
The database must also respect important rules:

• A plot can be either private or shared, never both.
• A staff member is always assigned to exactly one garden, but a professional may be
  affiliated with multiple gardens.
• A private plot can be rented by only one member in any given season and year.
• Event supervision is restricted to professionals affiliated with the event’s garden.
  City planners have indicated that the system should be ready for future expansions, including:
• Tracking training certifications for members, staff, and professionals.
• Managing a borrowing system for gardening tools.
• Recording harvest yields from plots.
  TASKS:
  You are required to develop an EER model for the above problem description. The EER should
  contain all necessary information such as entities, attributes, primary keys, relationships (including
  specialisation/union if any), cardinalities, and participation (including (min, max)). Any
  assumptions should also be stated clearly. If assumptions are made, it is important to make sure
  that the assumptions reflect possible real practice for a similar business and do not contradict with
  the problem description above.
  Note: The diagram must not be drawn by hand. Please use the attached EER template to start
  your design with the online tool https://app.diagrams.net/ (draw.io)
  You also can use any software to draw figures in your assignment. However, you must follow the
  notations introduced in the lectures and labs of this subject. Any alternative notations of EER
  modelling are NOT considered as a valid submission for this assignment. You are NOT required
  to transform your EER diagram into a set of tables for this assignment.
  [100%]