SCHOOL OF ACCOUNTANCY
COLLEGE OF BUSINESS
BKAS3053 DATABASE MANAGEMENT SYSTEMS (A & C)
MDSUHAIMI MD SALEH
EXERCISE FOR TOPIC 1 DATABASE CONCEPTS
QUESTION 1
“Database management systems were developed to address the file system’s inherit weaknesses. Rather than depositing data within independent files, a DBMS presents the database to the end user as a single data repository.”
(Rob and Coronel, 2007)
REQUIRED:
(a) Briefly explain why database design is important in order to produce a good database.
(b) Explain what data redundancy is and discuss TWO (2) implications of having data redundancy. Give examples for each implication.
QUESTION 2
You work as an accountant in K&R Enterprise that still uses manual filing system in managing its data. As an accountant with information system knowledge, you want to introduce Database Management Systems (DBMS) to K&R Enterprise. But the management hesitate to accept your idea because they believe that introduction of a new system is likely to have a profound impact to organization; it might be positive or negative, depending on how it is administered..
REQUIRED:
(a) State TWO (2) problems that K&R Enterprise might encounter with the current filing system.
(b) Briefly explain to K&R Enterprise what database is, and convince the management to adopt database system by explaining TWO (2) advantages that a database system will offer over current manual file system in K&R Enterprise.
QUESTION 3
(a) Explain why Database Management Systems are important in information-based society.
(b) Briefly explain THREE (3) reasons of studying file system before database can be designed.
(c) Briefly discuss TWO (2) considerations when designing a database.
QUESTION 4
(a) Database management system (DBMS) is a collection of program that manages the database structure and control access to the data stored in the database. Briefly explain THREE (3) advantages of DBMS.
(b) Based on Figure...