Kent Institute Australia Pty. Ltd. Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 XXXXXXXXXXPage 1 of 3 XXXXXXXXXXTEQSA Provider Number:...

1 answer below »
Kent Institute Australia Pty. Ltd.
Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO Code: 90458
Version 2: 11th October, 2019 XXXXXXXXXXPage 1 of 3 XXXXXXXXXXTEQSA Provider Number: PRV12051
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

XXXXXXXXXXKent Institute Australia Pty. Ltd.
Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO Code: 90458
Version 2: 11th October, 2019 XXXXXXXXXXPage 2 of 3 XXXXXXXXXXTEQSA Provider Number: PRV12051
ASSESSMENT DESCRIPTION:
This assessment is an individual Project. The actual scenario for carrying out the following tasks will be available
on Moodle (in assessment section) by week 8.

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.

ASSESSMENT SUBMISSION:
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 one folder.

MARKING GUIDE (RUBRIC):

Marking Criteria Lecturer Expectation Marks Comments
ERD Right diagrammatic representation of
entities, attributes, identifiers, and
relationships
10
Normalisation Reflect understanding of dependencies
and normalization.
4
Database, tables,
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.
8
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.

http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606

XXXXXXXXXXKent Institute Australia Pty. Ltd.
Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO Code: 90458
Version 2: 11th October, 2019 XXXXXXXXXXPage 3 of 3 XXXXXXXXXXTEQSA Provider Number: PRV12051
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:
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
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://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606
https://www.youtube.com/watch?v=N39mnu1Pkgw
http://www.youtube.com/watch?v=hqjJyqfceLw
Answered 6 days AfterMay 16, 2021

Solution

Shweta Jain answered on May 22 2021
19 Votes

84293Solution/ER_RelationalSchema.docx
Assignment – Managing Consultant Database
ER Diagram Description
· In this database there will be 5 Entities:
1. Client
2....

Submit New Assignment

Copy and Paste Your Assignment Here