B01DBFN212 Database Fundamentals Assessment 3

ASSESSMENT BRIEF

ASSESSMENT DESCRIPTION:

This assessment is an individual Project. The actual scenario for carrying out the following tasks will be available on Moodle

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

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

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