DatabaseReport.EC3119

Bachelor of Information Technology (Hons)

Database Report

(Group/Individual Assignment)

February 2025

Module: EC3119 (Database Systems)

Lecturer: Mr. Yubaraj Rai

__________________________________________________________________________

INSTRUCTIONS:

Total marks: 100

Start Date: 17^th February 2025

End Date: 25^th March 2025

Feedback Date: 11^th March 2025

COURSEWORK WEIGHTAGE:

(i) Design Report : 30%

__________________________________________

Total : 30%

__________________________________________

EC3119 DATABASE SYSTEMS

PART A: DATABASE LOGICAL MODEL

To develop a logical model of the proposed unique database system for any organization chosen by you or your team using MySQL DBMS or any MySQL environment. Based on the proposed system, complete the assigned task.

THE TASK:

You have to produce documentation in the following format:

1) BACKGROUND (5 Marks) – Background should include the following:

(i) Introduction to current system

(ii) Problem with the existing system

(iii) Significance of proposed system

2) OBJECTIVE (5 Marks) – The objective of current system should not be more than five and less than three and it should be listed in bullet form. Example:

Objectives:

• To enable working process easier for the clients

• To make the system make the process easier

• To generate related report on proposed system

3) PROBLEM STATEMENT (5 Marks) – State what’s new with the proposed system than that of existing system.

4) SCOPE (5 Marks) – Define scope for your proposed system, example:

* Once you created your system, make sure all the said scope is available.

5) HARDWARE & SOFTWARE SPECIFICATION (5 Marks) – Identify the hardware and software requirements to develop the system

6) ENTITY RELATIONSHIP DIAGRAM (15 Marks) – Draw entity relationship diagram with its attributes of proposed system

7) RELATIONAL SCHEMA (10 Marks) – Provide the data schema for the proposed system. Data schema should be documented using the entity relationship diagram.

– Identify the primary and foreign key.

8) NORMALIZATION (10 Marks) – Normalize the table into 3NF

PART B (DATABASE DESIGN) (15 Marks) Based on the proposal in Part A, develop the proposed system. You most develop database for the proposed system in XAMPP or other MySQL platform.

PART C (DOCUMENTATION) (15 Marks) You need to prepare a document with the following contents:

• All components listed in Part A

• Print screen of system user interface

• Conclusions

– Must consist of brief introduction of your system

– Advantage of your developed system

– Limitations of your system

– Future work / Suggestion

PART D (PRESENTATION) (10 Marks) You are required to prepare slides according to the components listed in Part C (Documentation). You are required to do presentation for 15 minutes.

SUBMISSION

1. Softcopy of documentation with proper inclusion of process and result of system screenshot.

2. Marks are only given upon demonstrating your prepared database system and documentation.

3. Format of the report:

a. Font size: 14 point for title/heading. 12 point for contents and 8 – 9 point for headers/footers.

b. 1 inch margins on all sides.

c. Font face: Times New Roman

d. Line spacing: 1.5

e. Proper header and footer

f. Caption for the diagram and screenshot.

MARKING SCHEME

Student Id: ____________________ Subject Code: ________ Student Name: _________________

PART A – DATABASE LOGICAL MODEL
Marking Criteria	Maximum Marks	Student’s Marks
1. Background Background should include the following: Introduction to current system Problem with the existing system How the problem could be solve using the proposed system 2. Objective The objective of current system SHOULD NOT BE MORE THAN FIVE AND LESS THAN THREE and it should be listed in bullet form. 3. Problem Statement State what the problems with current process / system are. 4. Scope Define scope for your proposed system. 5. Hardware & Software specification Identify the hardware and software requirements to develop the system 6. Entity Relationship Diagram Draw entity relationship diagram with its attributes. 7. Relational Schema Provide the data schema for the proposed system. Data schema should be documented using the entity relationship diagram. Identify the primary and foreign key. 8. Normalization Normalize the table into 3NF	5 5 5 5 5 15 10 10
Part A – Total	60

PART B – DATABASE DESIGN
Marking Criteria	Maximum Marks	Student’s Marks
1. Achieve the scope mentioned in Part A 2. Able to run with free of errors 3. Has data validation 4. Enable Entity integrity and referential integrity 5. Overall design of the system / creativity	3 3 3 3 3
Part B – Total	15
PART C – DOCUMENTATION
Marking Criteria	Maximum Marks	Student’s Marks
1. All components listed in Part A 2. Print screen of result 3. Conclusions Must consist of brief introduction of your system Advantage of your developed system Limitations of your system Future work / Suggestion	5 5 5
Part C – Total	15
PART D – DESCRIPTION (PRESENTATION)
Marking Criteria	Maximum Marks	Student’s Marks
1. Presentation contained a brief and effective introduction 2. Explanation of the System design was clear and logical 3. Recommendations for expansion plan were helpful 4. Conclusions was satisfying and gave a sense of closure 5. Demonstration of the system 6. Able to answer question 7. Attire and cooperation of the group	2 2 1 1 2 1 1
Part D – Total	10
Total – Part (A + B + C + D)	100

***All the Best***