BIT208 - IT - Bachelor of IT - Database Fundamentals - The Design, Building, Querying and Testing of a Relational Database - Report Writing - Assessment Answer

Assessment Task:

BIT208: Bachelor of IT Database Fundamentals The Design, Building, Querying and Testing of a Relational Database Report Writing Assessment Answer

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.
• 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 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 the 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 in 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.

This BIT208: IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.