B01DBFN212 Database Fundamentals Assessment 1

ASSESSMENT BRIEF

COURSE: Bachelor of Business / Bachelor of IT
Unit:	Database Fundamentals
Unit Code:	B01DBFN212/ BIT 208
Type of Assessment:	Assessment 1 – In-Class Test
Length/Duration:	1 hour – Closed book Exam
Course Learning Outcomes addressed:	To gather, critically analyse, manage and present in meaningful ways information and data.
Unit Learning Outcomes addressed:	Describe the key aspects and critically evaluate uses of database technology and database management
Assessment Task:	Students will be given individual theory questions to complete in a class.
Total Mark:	10 marks
Weighting:	10 % of the unit total marks

ASSESSMENT DESCRIPTION:

Your In-Class Test will be a closed-book 1 hour individual exam. It will consist of theory questions. The questions will be designed from your class discussions, tutorials, covering all the contents starting from week 1 to week 3. It is very important to have a comprehensive idea on the unit activities to get a good score in this In-Class Test.

GENERAL NOTES FOR ASSIGNMENTS

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

B01DBFN212 Database Fundamentals Assessment 2

ASSESSMENT BRIEF

COURSE: Bachelor of Business / Bachelor of IT
Unit:	Database Fundamentals
Unit Code:	B01DBFN212/ BIT 208
Type of Assessment:	Task 2 - Workshops Series of workshops covering the practical elements of designing, testing and using relational databases and queries for data retrieval, and transaction processing and concurrency in multi-user databases.
Course Learning Outcomes addressed:	To gather, critically analyse, manage and present in meaningful ways information and data, and To devise risk assessments when solving complex problems in local and global business environments. 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.
Unit Learning Outcomes addressed:	Describe the key aspects and critically evaluate uses of database technology and database management. Design and build relational databases. Define views and formulate efficient queries using a query language. Apply transaction processing and concurrency in multi-user database systems. Be knowledgeable about issues relating to data access and retrieval, storage, ethics and privacy.
Assessment Task:	Series of workshops covering the practical elements of designing, testing and using relational databases and queries for data retrieval, and transaction processing and concurrency in multi-user databases.
Total Mark:	30
Weighting:	30 % of the total marks

ASSESSMENT DESCRIPTION:

Workshops throughout the trimester.

GENERAL NOTES FOR ASSIGNMENTS

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.

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?

B01DBFN212 Database Fundamentals Assessment 3

ASSESSMENT BRIEF

COURSE: Bachelor of Business / Bachelor of IT
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.

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:

Create a complete ERD with all entities and relationships.
Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.
Create a database using MS ACCESS - with primary keys, foreign keys and other attributes mentioned for each entity using proper constraints.
Create a form to input/update data.
Input some significant data in each table showing your understanding of the scenario.
Create three Queries.
Create a report.

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

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

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

B01DBFN212 Database Fundamentals Assessment 4

ASSESSMENT BRIEF

COURSE: Bachelor of Business / Bachelor of IT
Unit:	Database Fundamentals
Unit Code:	B01DBFN212/ BIT 208
Type of Assessment:	Assessment 4 – Final Exam
Length/Duration:	2 hours – Closed book Exam
Course Learning Outcomes addressed:	To gather, critically analyse, manage and present in meaningful ways information and data.
Unit Learning Outcomes addressed:	Describe the key aspects and critically evaluate uses of database technology and database management. Apply transaction processing and concurrency in multiuser database systems. Be knowledgeable about issues relating to data access and retrieval, storage, ethics and privacy.
Assessment Task:	A closed book comprehensive exam
Total Mark:	30 marks
Weighting:	30% of the unit total marks

ASSESSMENT DESCRIPTION:

A 2 hour invigilated closed book examination covering material from the whole trimester. Exam will cover entire course from week 1 to week 11. It will consist of short questions and answer and modelling questions. ASSESSMENT SUBMISSION:

The final exam will take place during the exam week at the end of the trimester. Specific exam date and time will be announced after week 11. Please read the exam instruction carefully when you will sit for the exam.

Students not able to participate in the exam may be allowed to sit for deferred exam. However, consideration will be offered only under severe medical condition or unanticipated extenuating circumstances. You must provide appropriate supporting paper for consideration.

GENERAL NOTES FOR ASSIGNMENTS

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

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.

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

Australia Universities

ACT

Australian Catholic University

Australian National University

Bond University

Central Queensland University

Charles Darwin University

Charles Sturt University

Curtin University of Technology

Deakin University

Edith Cowan University

Flinders University

Griffith University

Holmes Institute

James Cook University

La Trobe University

Macquarie University

Monash University

Murdoch University

Queensland University of Technology

RMIT University

Southern Cross University

Swinburne University of Technology

University of Adelaide

University of Ballarat

University of Canberra

University of Melbourne

University of Newcastle

University of New England

University of New South Wales

University of Notre Dame Australia

University of Queensland

University of South Australia

University of Southern Queensland

University of Sydney

University of Tasmania

University of Technology Sydney

University of the Sunshine Coast

University of Western Australia

University of Wollongong

Victoria University

Western Sydney University

Year 11 - 12 Certification Assignment

Australian Capital Territory Year 12 Certificate

HSC - Higher School Certificate

NTCE - Northern Territory Certificate of Education

QCE - Queensland Certificate of Education

SACE - South Australian Certificate of Education

TCE - Tasmanian Certificate of Education

VCE - Victorian Certificate of Education

WACE - Western Australia Certificate of Education

B01DBFN212 Database Fundamentals Assessment 1

B01DBFN212 Database Fundamentals Assessment 2

B01DBFN212 Database Fundamentals Assessment 3

B01DBFN212 Database Fundamentals Assessment 4

Diploma Universities Assignments