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:

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:

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

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.
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

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 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.

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
( 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


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: »

Order for this Paper or Similar Assignment Help

Fill a form in 3 easy steps - less than 5 mins.

Why choose us

You Want Quality and That’s What We Deliver

Top Essay Writers

We select the finest writers to join our team. They each have expertise in specific topic fields and background in academic writing.

Affordable Prices

We offer the lowest possible pricing while still providing the best writers. Our costs are fair and reasonable compared to other writing services.

100% Plagiarism-Free

You will never receive a product that contains any plagiarism. We scan every final draft before releasing it to be delivered to a customer.

How it works

When you decide to place an order with Study Pro Essay, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: