SCHOOL OF ACCOUNTANCY
COLLEGE OF BUSINESSBKAS3053 DATABASE MANAGEMENT SYSTEMS (A & C)MDSUHAIMI MD SALEHEXERCISE FOR TOPIC 1 DATABASE CONCEPTSQUESTION 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.
(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…