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

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

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:

  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.

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

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

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