COURSE: Bachelor of Business / Bachelor of IT
Unit: Database Fundamentals
Unit Code: DBFN212/ BIT 208
Type of Assessment: Individual Project
a) To gather, critically analyse, manage and present in meaningful ways information and data, and
b) To act as an ethical practitioner while demonstrating skills in data analysis, database design, system design, web design and software development and testing.
c) To implement and document user experience analysis, design and testing.
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 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.
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
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
Relational DBMS and how it supports database design and implementation for Relational databases.
Form 3 Reflect understanding of database applications using MS Access tools.
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? (thanks to La Trobe University for this video).