KOLEJ PROFESIONAL MARA SERI ISKANDAR

DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY

COURSE NAME : DATABASE MANAGEMENT SYSTEM

COURSE CODE : CSC 2663
ACADEMIC SESSION : 3 2023/2024
TYPE OF ASSESSMENT : FINAL PROJECT
DATE OUT : 19 FEBRUARY 2024
DATE IN : 11 MAC 2024
DURATION : 3 WEEKS

CLO3: Demonstrate the best practice of database management using DBMS (A3, PLO 6)

INSTRUCTION TO CANDIDATES:

1. Carefully check the submission date and the instructions given with the
assignment/project. Late submission will not be accepted.
2. If you are unable to submit your assignment/project on time and have valid reasons such
as illness, you may apply (in writing) for an extension.
3. If you use other people’s work or ideas in your assignment/project, kindly reference them
using APA system.

Personal Details Tasks Mark

Name 1 /8
I/D Number 2 /8
3 /8
Class DBIT 5____ 4 /8
Lecturer 5 /56
Sharifah Bt Yahya
6 /12
Sub-Total /100
Total /40

I hereby confirmed that this assignment is my own work and not copied or plagiarized from
any source. I have referenced the sources from which the information is obtained by me for
this assignment.

Signature_____________________ Date________________

CONFIDENTIAL 1 3/2023/FINAL PROJECT/CSC2663

SCENARIO

Perak Tengah is located at the center of Perak state, based in

the town of Seri Iskandar. It covers an area of 1282km2 with
a population of 97200. The region comprises 12 districts
including Blanja, Layang-layang, Bota, Lambor Kanan, Lambor
Kiri, Pulau Tiga, Kampung Gajah, Pasir Panjang Hulu, Pasir
Salak, Bandar, Kota Setia and Jaya Baru.
Numerous government agencies, shop lots, academic
institutions, and facilities are located in this area. Perak
Tengah’s communities have a strong presence in agriculture
such as paddy planting and palm oil. The potential of
aquaculture and eco-tourism is also in demand since Perak
Tengah is located along the Perak River.

(Source adapted from: https://www.perak.gov.my/index.php/kerajaan-negeri/data/my-local-

stats/negeri-perak)

YOUR ROLE

You have been hired as a database developer for Perak IT Development Berhad. The company
has been tasked to propose a database system to be used in an integrated system in Perak
Tengah. To achieve the goal, each team member at the company is required to prepare a
simple database proposal, including queries, as one of the idea contributions for the project.
You are allowed to choose any topic and scope but must be able to support management
processes that might give benefits to the government or non-government agencies, and local
communities (Perak Tengah). Some database ideas that might help are databases that are
related to culture and festival events, flood information, agriculture management, tourism
management, vacancy management, night market management, service application, survey
on feedback, volunteering activities, restaurant management, tournament management, and
many more.

CONFIDENTIAL 2 3/2023/FINAL PROJECT/CSC2663

TASK

This is an individual project. You need to design and implement a database system for the
chosen idea using MySQL. Demonstrate the best practices by applying your knowledge in
database management systems with appropriate table design and queries. Prepare a report
with the following requirements:

Task 1: Problem Background (Gather) - A1

Describe an overview of the topic including the following details:
a) Introduction on the chosen topic/agencies/scope. (*make citation where appropriate)
b) Problems with manual record keeping (related to the chosen topic).
c) Purpose of the proposed database.

Task 2: Entity Relationship Diagram (Design) - A3

Propose an ERD using Crows Foot notation.
a) Ensure the design clearly reflects project aims and problems with complete design
rules.
b) You may use software to draw the ERD.

Task 3: Database Specification (Design) - A2

Present data dictionary specifications for all tables.
a) Use an appropriate database name and table names (at least five 5 tables, and
maximum 10 tables).
b) Assign accurate field’s data types, sizes, keys, and data constraints (where
appropriate).
c) Create tables with records. Use data from the selected case study. Ensure to apply
a variety of sample data to show the relationships.

Task 4: Implementation (Articulation) - A3

Demonstrate SQL commands to:
a) Create the database, tables, and insert records with at least 10 records (where
appropriate).
b) Take screenshots of all codes and output from MySQL.
c) Show relationship between tables using MySQL designer.

CONFIDENTIAL 3 3/2023/FINAL PROJECT/CSC2663

Task 5: Data manipulation (Articulation) - A3
Demonstrate the use of various SQL commands to make useful queries to the selected
problem or case.
a) Make use of calculations, built-in functions, grouping, joining tables, and union where
appropriate.
b) Ensure that the queries are aligned with the objectives stated in Task 1.
c) Take screenshots of the SQL code and output from MySQL.
d) Provide a clear explanation of the use of all queries to users.
e) Make sure to neatly organize and label all figures.

Task 6: Presentation (Collaborate) - A3

Demonstrate the findings to the instructor, explaining tasks 1 to 5.
a) Provide introduction to the topic.
b) Demonstrate the use of SQL code for 3 useful queries.

SUBMISSION FORMAT

Prepare a report detailing the problems and recommendations for solutions. All explanations
must be clear and neat. All pictures and figures should be labelled clearly. The content of the
report should contain the followings:

1. Table of contents
2. Findings (Task 1- 5)
3. Summary

Note:
- Presentations and Q&A sessions will be conducted from 6 March until 11 March 2024.
- The work progress will also be evaluated.
- Make an appointment for a consultation with your instructor to show the progress from
design to implementation.

CONFIDENTIAL 4 3/2023/FINAL PROJECT/CSC2663

The marks will be allocated as below:

Tasks Sub attribute Details Mark

1 Gather Problems background 8

2 Entity Relationship Diagram (ERD) 8

Design
Database specification 8

3 Implementation 8
Articulation
Data manipulation 56
4 Collaborate Presentation 12

Sub- Total 100

Total 40

**Refer to the rubric attached for more details.

The following portals are list of government agencies that might help you to find ideas for the
project:
https://www.perak.gov.my/index.php/kerajaan-negeri/data/my-local-stats/negeri-perak
https://ptg.perak.gov.my/portal/web/seri-iskandar
https://jkrperak.gov.my/index.php/bahagian/daerah/perak-tengah
https://myrela.moha.gov.my/myrelamobile/rela/index
https://jpnperak.moe.gov.my/pejabatpendidikandaerah/8090-pejabat-pendidikan-daerah-perak-tengah
https://www.maiamp.gov.my/index.php
http://www.pertanianperak.gov.my/index.php
https://www.jakoa.gov.my/hubungi-kami/
https://i-kariah.perak.my/index.php

END OF QUESTION PAPER

CONFIDENTIAL 5 3/2023/FINAL PROJECT/CSC2663