SOLVED: Database Fundamentals

Posted on June 23, 2021
SOLVED: Database Fundamentals

ASSESSMENT BRIEF

COURSE:     Bachelor of Business / Bachelor of IT

 

 

 

Unit:

Database Fundamentals

 

 

 

Unit Code:

DBFN212/ BIT 208

 

 

 

Type of Assessment:

Individual Project

 

 

 

Length/Duration:

N.A.

 

 

 

 

 

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

Course Learning

 

in data analysis, database design, system design, web

Outcomes addressed:

c)

design and software development and testing.

 

To implement and document user experience analysis,

 

 

design and testing.
   

 

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:

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.

 

Disclaimer

The assignment sample provided by Assignments Consultancy is a previously completed work for another student and contains plagiarism. It is being shared only as a reference or guideline to help you understand how to structure and approach your own assignment. We do not recommend submitting it directly as your own work. You are solely responsible for ensuring the originality and integrity of the assignment you submit, and we advise using this sample only as inspiration while adhering to your institution's academic policies.

Solution

LEAVE A COMMENT

Comment Box is loading comments...