COURSE: Bachelor of Business/ Bachelor of IT
Unit Code: DBFN212
Unit Title: Database Fundamentals
Type of Assessment: Task 3- Individual Project
Unit Learning Outcomes addressed: a) Design and build relational databases
b) Define views and formulate efficient queries using a query language and
c) Be knowledgeable about issues relating to data access and retrieval, storage, ethics and privacy
Submission Date: To be submitted in week 11
The design, building, and querying of a relational database.
Total Mark: 30 Marks
Students are advised that submission of an Assessment Task past the due date without a formally signed
approved Assignment Extension Form (Kent Website MyKent Student Link FORM – Assignment Extension
Application Form – Student Login Required) or previously approved application for other extenuating
circumstances impacting course of study, incurs a 5% penalty per calendar day, calculated by deduction from
the total mark.
For example. An Assessment Task marked out of 40 will incur a 2 mark penalty for each calendar day.
More information, please refer to (Kent Website MyKent Student Link POLICY – Assessment Policy &
Procedures – Student Login Required)
This assessment is an individual Project.
A tours operator company wants to get its database developed. They have provided the following
The system needs to keep track of people. For each person, it records his/her address. Each address consists
of country, province/state, city, street, street number, zip code/post code, and a list (possible empty) of phone
numbers and a list of email address.
Each person in the database can be an old customer (have taken a tour of the company), a current customer
(is booked to take a tour or is on a tour right now), a tour guide, an employee (works for the tour company),
or any mixture of these (for instance an employee can take a tour and so can be a customer as well). The sex
and age of each person must also be recorded.
The system also keeps track of all tours, past and future. Each tour has a unique number, itinerary, guide (at
least one, but may be more than one), its status (completed, in-progress, in-the-future), and the list of
participants. The amount paid by each person for the tour is also recorded. Each person is provided with an
itinerary that consists of list of the dates the tour covers and for each date it includes the place of breakfast,
the place of lunch, the place of dinner, and the accommodation and room. The type of room whether shared
or private should also be mentioned on the itinerary. Each day in the itinerary also includes a simple English
description of the activities during that day.
Tasks to be completed:
a. Create a complete ERD with entities and relationships using given scenario.
b. Convert the ERD to a set of relational tables in at least 3NF and draw a dependency diagram
c. Create a database using MySQL- with primary keys, foreign keys, and other attributes mentioned for each
entity using proper constraints.
d. Input some significant data in each table showing your understanding of the scenario.
e. Create FOUR queries. (One SELECT, one Numeric function and two JOIN)
The assignment must be submitted online in Moodle. The ERD and dependency diagram must be in MS
WORD and assignment submission should contain both MS WORD file and the actual database contained in
MARKING GUIDE (RUBRIC):
Marking Criteria Lecturer Expectation Marks Comments
ERD Right diagrammatic representation of entities, attributes, identifiers, and relationships 10
Normalization Reflect understanding of dependencies and normalization. 4
keys, fields, and data Shows understanding of MySQL as a relational DBMS and how it supports database
design and implementation for relational databases. 8
Queries Reflect understanding SQL using MYSQL. 2×4
GENERAL NOTES FOR ASSESSMENT TASKS
Content for Assessment Task papers should incorporate a formal introduction, main points and conclusion.
Appropriate academic writing and referencing are inevitable academic skills that you must develop and
demonstrate in work being presented for assessment. The content of high quality work presented by a student
must be fully referenced within-text citations and a Reference List at the end. Kent strongly recommends you
refer to the Academic Learning Support Workshop materials available on the Kent Learning Management
System (Moodle). For details please click the link
http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606 and download the file titled “Harvard
Referencing Workbook”. This Moodle Site is the location for Workbooks and information that are presented
to Kent Students in the ALS Workshops conducted at the beginning of each Trimester.
Kent recommends a minimum of FIVE (5) references in work being presented for assessment. Unless
otherwise specifically instructed by your Lecturer or as detailed in the Unit Outline for the specific
Assessment Task, any paper with less than five (5) references may be deemed not meeting a satisfactory
standard and possibly be failed.
Content in Assessment tasks that includes sources that are not properly referenced according to the “Harvard
Referencing Workbook” will be penalised.
Marks will be deducted for failure to adhere to the word count if this is specifically stated for the Assessment
Task in the Unit Outline. As a general rule there is an allowable discretionary variance to the word count in
that it is generally accepted that a student may go over or under by 10% than the stated length.
GENERAL NOTES FOR REFERENCING
References are assessed for their quality. Students should draw on quality academic sources, such as books,
chapters from edited books, journals etc. The textbook for the Unit of study can be used as a reference, but
not the Lecturer Notes. The Assessor will want to see evidence that a student is capable of conducting their
own research. Also, in order to help Assessors determine a student’s understanding of the work they cite, all
in-text references (not just direct quotes) must include the specific page number(s) if shown in the original.
Before preparing your Assessment Task or own contribution, please review this ‘YouTube’ video (Avoiding
Plagiarism through Referencing) by clicking on the following link: link:
A search for peer-reviewed journal articles may also assist students. These type of journal articles can be
located in the online journal databases and can be accessed from the Kent Library homepage. Wikipedia,
online dictionaries and online encyclopaedias are acceptable as a starting point to gain knowledge about a
topic, but should not be over-used – these should constitute no more than 10% of your total list of
references/sources. Additional information and literature can be used where these are produced by legitimate
sources, such as government departments, research institutes such as the National Health and Medical
Research Council (NHMRC), or international organisations such as the World Health Organisation (WHO).
Legitimate organisations and government departments produce peer reviewed reports and articles and are
therefore very useful and mostly very current. The content of the following link explains why it is not
acceptable to use non-peer reviewed websites (Why cant I just Google?): https://www.youtube.com/watch?
v=N39mnu1Pkgw (thank you to La Trobe University for access to this video).