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 : 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. Unit Learning Outcomes addressed : 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. Assessment Task : The design, building, querying and testing of a relational database
Total Mark : 30 marks
Weighting : Total 30%

Students are advised that any submissions past due date without an approved extension or without aproved extenauting circumstances incures a 5% penalty per calendar day,calculated from the total mark
E.g a task marked out of 40 will incure a 2 mark penalty per calendar day.

More information please refer to( Documents >student policies and Forms > POLICY -- Assessment Policy & Procedure -- Login Required)

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 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 pre-requisites (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:
Create a complete ERD with all entities and relationships. Convert the ERD to a set of 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. SELECT, JOIN and an AGGREGATE function QUERY. You can use any table and fields for your Queries. 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.

To Continue Click Here > DBFN212 - BIT 208 Database Fundamentals.pdf