ASSESSMENT BRIEF
COURSE: Bachelor of Business/ Bachelor of IT
Unit Code: DBFN212
Unit Title: Database Fundamentals
Type of Assessment: Task 3- Individual Project
Length/Duration: N/A
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
Assessment Task:
The design, building, and querying of a relational database.
Total Mark: 30 Marks
Weighting: 30%
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)
https://kentinstituteaustralia.sharepoint.com/sites/Policies%26Forms/SitePages/Home.aspx?RootFolder=%2Fsites%2FPolicies%26Forms%2FPolicies%20and%20Forms%2FStudent&FolderCTID=0x012000E6C01ECDB12ACE448B94EB84A9F93758&View=%7B148054E0%2D0936%2D4517%2D8B3E%2DD0CCDC7CD88F%7D
https://kentinstituteaustralia.sharepoint.com/sites/Policies%26Forms/SitePages/Home.aspx?RootFolder=%2Fsites%2FPolicies%26Forms%2FPolicies%20and%20Forms%2FStudent&FolderCTID=0x012000E6C01ECDB12ACE448B94EB84A9F93758&View=%7B148054E0%2D0936%2D4517%2D8B3E%2DD0CCDC7CD88F%7D
Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 2 of 4 TEQSA Provider Number: PRV12051
ASSESSMENT DESCRIPTION: This assessment is an individual Project. An Australian owned business specialist about rental properties requires to efficiently record and track all of
their listed properties, customers, staff, rental activities, and maintenance of the properties.
The property managers accept entrusted rental management of the real estate from property owners. The
property could be a house or apartment. Each property should be recorded with the information including
property type, address, the number of bedrooms and bathrooms, listed weekly rental, as well as available date.
When a customer wishes to rent a property, he/she is required to make an application which will be recorded. A
customer can make many applications for different properties. However, only one application will be approved.
If the application is approved, the contract start date, end date, and weekly rental must be recorded. A property
is managed by one property manager and a manager could take care of multiple listed properties.
From time to time the property under management may need some maintenance service or minor repair jobs
(for example broken window, electrical fault, water pipe leaking etc). The company has contracted the
maintenance tasks to qualified external employee who will undertake the repair job as required. The external
employee could be an electrician, plumber, or handyman. Details of repair job and complete date must be
entered.
The people that system needs to record include property managers, the owners of property, the customers, and
the contracted external employees. Their name, address, contact and phone are essential data in the database
system. In addition, you should consider one or two extra attributes to describe property manager and external
employer.
Tasks to be completed: a. Create a complete ERD with entities and relationships using given scenario.
Make sure that relationship types, participation and cardinality is shown in
ERD.
b. Convert the ERD to a set of relational tables in at least 3NF and draw a
dependency diagram
c. Create a database using MICROSOFT ACCESS- with primary keys, foreign keys,
and other attributes mentioned for each entity using proper constraints.
d. Create a form to input/update data
e. Input some significant data in each table showing your understanding of the
scenario.
f. Create three queries.
g. Create a report.
ASSESSMENT SUBMISSION: The assignment must be submitted online in Moodle. All materials MUST be submitted electronically in Microsoft Word format. Other formats (e.g., pdf or MAC file) may not be readable by markers. Please be aware that any assessments submitted in other formats will be considered LATE and will lose marks until it is presented in MS Word. No paper based or hardcopy submission will be accepted.
MARKING GUIDE (RUBRIC):
Marking Criteria Lecturer Expectation Marks Comments
ERD Right diagrammatic representation of entities, attributes, and relationships
10
Normalization Reflect understanding of dependencies and normalization.
4
Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 3 of 4 TEQSA Provider Number: PRV12051
Database, tables, keys, fields, and data
Shows understanding of Microsoft Access as a relational DBMS and how it supports database design and implementation for relational databases.
5
Form Reflect understanding of database applications using MS Access tools.
3
Queries 5
Report 3
Total 30
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 students 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: http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606
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
http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606
http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606
Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 4 of 4 TEQSA Provider Number: PRV12051
very current. The content of the following link explains why it is not acceptable to use non-peer reviewed websites (Why can’t I just Google?): https://www.youtube.com/watch?v=N39mnu1Pkgw (thank you to La Trobe University for access to this video).
http://www.youtube.com/watch?v=hqjJyqfceLw
Applied Sciences
Architecture and Design
Biology
Business & Finance
Chemistry
Computer Science
Geography
Geology
Education
Engineering
English
Environmental science
Spanish
Government
History
Human Resource Management
Information Systems
Law
Literature
Mathematics
Nursing
Physics
Political Science
Psychology
Reading
Science
Social Science
Home
Blog
Archive
Essay
Reviews
Contact
google+twitterfacebook
Copyright © 2019 HomeworkMarket.com
