Write My Paper!

Don't Stress over approaching deadlines; an able team is ready 24/7 to assist you with your coursework assignments

We provide study solutions in all subjects. Students are matched with specialists in the various fields; Masters level graduates experts.

Place an Order today with us and live to tell a success story! No Lateness!!

Special offer! Get 20 - 30% discount on all orders - Check Coupons Section

Posted: February 1st, 2022

Database Fundamentals Unit Code: DBFN212/ BIT 208 Type of Assessment: Individual Projec

COURSE: Bachelor of Business / Bachelor of IT
Unit: Database Fundamentals
Unit Code: DBFN212/ 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.
A college is maintaining student progress through the course. The students are reading towards a
degree (e.g. BBA, BIT, etc.). Every student is identified with his student number. Other information
such as student address, phone number, degree towards which he is reading, is also stored. The
degree that student is enrolled is characterized by its code, title, elective and compulsory modules
to be completed in it.
A module is characterized by its code, title, credits, department, lecturers and unit coordinator. A
Module can generate many classes. Necessary information about class should be stored in the
system such as class code, module with which it is associated and lecturer responsible for
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
conducting the class. Each class will be taught by one lecturer only. All the lecturers teaching
classes of same module are coordinated by a unit coordinator who is also a Lecturer. Every
lecturer’s name, his employment code, his address, phone number, his qualifications must also be
stored in the system. A lecturer can have many Qualifications.
A student can choose any module from the available list. However, some Modules can have prerequisites (one or more than one modules) to be completed before a student can be enrolled for the
course. There are some extracurricular activity clubs available in the college too. Students can enroll
themselves into any extracurricular activities (such as debating club, sports club, reading club, etc.).
A club can have a code, its title, its description, its establishment date and current president. The
president of every club is an elected student.
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 of 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.
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. SELECT, JOIN and an AGGREGATE function QUERY. You can
use any table and fields for your 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
Lecturer’s Expectation Marks
Assigned
Comments
ERD 10 Right diagrammatic
representation of entities,
attributes, identifiers, and
relationships
Normalization
4 Reflect understanding of
dependencies and
normalization.
Database tables, keys,
other fields, and Data
5 Shows understanding of
Microsoft Access as a
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
Relational DBMS and how
it supports database design
and implementation for
Relational databases.
Form 3 Reflect understanding of
database applications using
Queries 5 MS Access tools.
Report 3
Total 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.

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

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

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 Assessment Brief Task Help, 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.