Posted: February 1st, 2022

B01DBFN212/ BIT 208 Assessment Project Database Fundamentals

Unit: Database Fundamentals
Unit Code: B01DBFN212/ BIT 208
Type of Assessment: Individual Project
Length/Duration: N.A.
Course Learning
Outcomes addressed:
a)
b)
c)

To gather, critically analyse, manage and present in
meaningful ways information and data, and
To act as an ethical practitioner while demonstrating skills
in data analysis, database design, system design, web
design and software development and testing.
To implement and document user experience analysis,
design and testing.

Kent Institute Australia Pty. Ltd.
Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458
Version: as at 9th November, 2017 TEQSA Provider Number: PRV12051
Unit Learning
Outcomes addressed:
a)
b)
c)

Design and build relational databases.
Define views and formulate efficient queries using a query
language, and
Be knowledgeable about issues relating to data access and
retrieval, storage, ethics and privacy.

Submission Date: Week 11
Assessment Task:

The design, building, querying and testing of a relational
database

ASSESSMENT DESCRIPTION:
This assessment is an individual Project. The actual scenario for carrying out the following tasks
will be available on Moodle by week 8.
Tasks to be completed
Given the above information:
1. Create a complete ERD with all entities and relationships.
2. Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.
3. Create a database using MS ACCESS – with primary keys, foreign keys and other attributes
mentioned for each entity using proper constraints.
E.g. a task marked out of 40 will incur a 2 mark penalty .
Student Policies and Forms
Kent Institute Australia Pty. Ltd.
Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458
Version: as at 9th November, 2017 TEQSA Provider Number: PRV12051
4. Create a form to input/update data.
5. Input some significant data in each table showing your understanding of the scenario.
6. Create three Queries.
7. 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 Criteria Max Marks
ERD 10
Normalization 4
Database tables, keys, other fields, and Data 5
Form 3
Queries 5
Report 3
Total Max 30 30

GENERAL NOTES FOR ASSIGNMENTS
Assignments should usually incorporate a formal introduction, main points and conclusion, and will
be fully referenced including a reference list.

The work must be fully referenced with in-text citations and a reference list at the end. We
strongly recommend you to refer to the Academic Learning Skills materials available in the
Moodle. For details please click the link
http://moodle.kent.edu.au/kentmoodle/course/view.php?id=5 and download the file “Harvard
Referencing Workbook”. Appropriate academic writing and referencing are inevitable academic
skills that you must develop and demonstrate.

We recommend a minimum of FIVE references, unless instructed differently by your lecturer.
Unless specifically instructed otherwise by your lecturer, any paper with less than FIVE references
may be failed. Work that includes sources that are not properly referenced according to the
“Harvard Referencing Workbook” will be penalised.

Kent Institute Australia Pty. Ltd.
Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458
Version: as at 9th November, 2017 TEQSA Provider Number: PRV12051
Marks will be deducted for failure to adhere to the word count – as a general rule you may go over
or under by 10% than the stated length.

GENERAL NOTES FOR REFERENCING
High quality work must be fully referenced with in-text citations and a reference list at the end. We
recommend you work with your Academic Learning Support (ALS) site
(http://moodle.kent.edu.au/kentmoodle/course/view.php?id=5) available in Moodle to ensure that
you reference correctly.

References are assessed for their quality. You should draw on quality academic sources, such as
books, chapters from edited books, journals etc. Your textbook can be used as a reference, but not
the lecturer notes. We want to see evidence that you are capable of conducting your own research.
Also, in order to help markers determine 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 assignment or own contribution, please review this ‘YouTube’ video by
clicking on the following link: Plagiarism: How to avoid it

PLAGIARISM: HOW TO AVOID IT

You can search for peer-reviewed journal articles, which you can find in the online journal
databases and which can be accessed from the library homepage. Wikipedia, online dictionaries
and online encyclopaedias are acceptable as a starting point to gain knowledge about a topic, but
should not be overused – 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 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 nonpeer reviewed websites: Why can’t I just Google? (thanks to La Trobe
University for this video).

Check Price Discount

More Assignment Samples: Assessment Task – NAPLAN Exercise – Word count: 500 words »