Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
CSE2DBF
Assignment
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.
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.
No extensions will be given: Penalties are applied to late assignments (5% of total assignment
mark given is deducted per day, accepted up to 5 days after the due date only). If there are
circumstances that prevent the assignment being submitted on time, an application for special
consideration may be made. See Student Handbook for details. 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:
The submission link can be found under “Assignment 1 – Part 1” on 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.
Page 2/7
______________________________________________________________________________________
PROBLEM DESCRIPTION:
** Use draw.io to draw your diagram, you cannot submit hand-drawn diagram **
House2Home Franchise Application Database System
House2Home is a retail chain that operates throughout Australia and some foreign countries. Their main
business revenue is generated from selling computers, home electronics and furniture. Originally, the central
operational team manages all of the House2Home retail shops. However, due to the business changes, the
company increasingly franchise out their departments to different franchisee teams. So far, the franchise
application process has been handled using a paper based system. With the continuous growth of the retail
chain, House2Home wants to automate the application and selection process in Australia. For the automated
web-based system to work, they need an underlying database that can cater for the relevant data. They have
asked for a solution that will work best to support their business process, which is described below.
The company has many stores spread across Australia. To keep track of each store, the company wants to
store information such as unique store identification number, store address (including street & number,
suburb, postcode and state), weekdays operating hours and weekend operating hours.
The departments of each store are autonomous. A department is the unit of operation that is managed by a
franchisee team. A store can have several departments such as computers, electronics, beddings, furniture
and so on. A department with a unique id belongs to exactly one store. Other information pertaining to a
department are title of the department (i.e. computers) and number of employees.
The franchise application database also needs to store information about employees of House2Home as some
of them are eligible to submit a team application for franchise of a department. Each employee has an
employee id. The name, phone number, email address, home address, date-of-birth and gender of an
employee are also recorded by the company for convenience. Based on the nature of employment, there are
three types of employees in House2Home, i.e. casual, part-time and full-time. Casual employees have a casual
hourly rate. Casual and part-time employees are both not eligible for paid annual leave. Only full-time
employees are eligible for paid annual leave and the number of days they are eligible for are recorded against
each employee along with their annual salary. For each part-time employee, the weekly working hours and
annual salary are recorded.