Final Project

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.

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.

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.

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

Final Project

Uploaded by

Copyright:

Available Formats

Final Project

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Final Project

Uploaded by

Copyright:

Available Formats

KOLEJ PROFESIONAL MARA SERI ISKANDAR

DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY

COURSE NAME : DATABASE MANAGEMENT SYSTEM

Personal Details Tasks Mark

CONFIDENTIAL 1 3/2023/FINAL PROJECT/CSC2663

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

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

CONFIDENTIAL 2 3/2023/FINAL PROJECT/CSC2663

Task 1: Problem Background (Gather) - A1

Task 2: Entity Relationship Diagram (Design) - A3

Task 3: Database Specification (Design) - A2

Task 4: Implementation (Articulation) - A3

CONFIDENTIAL 3 3/2023/FINAL PROJECT/CSC2663

Task 6: Presentation (Collaborate) - A3

CONFIDENTIAL 4 3/2023/FINAL PROJECT/CSC2663

Tasks Sub attribute Details Mark

2 Entity Relationship Diagram (ERD) 8

Sub- Total 100

**Refer to the rubric attached for more details.

END OF QUESTION PAPER

CONFIDENTIAL 5 3/2023/FINAL PROJECT/CSC2663

You might also like