• Universiti Teknologi Mara

• CSC ICT200

COURSE : INTRODUCTION TO DATABASE DESIGN

COURSE CODE : ICT200/ITS232

DATE : JUNE 2022

TIME : 2 HOURS

SEMESTER : MAC 2022 – JUL 2022

STUDENT DETAILS:

NAME : Muhammad Afiq Azami Bin Sabar

STUDENT ID : 2021204524

GROUP : JCS1103F

INSTRUCTIONS TO CANDIDATES:

1. This question paper consists of three (3) parts:PART A (15 Marks)

PART B (25 marks)

PART C (20 marks)

2. Answer ALL questions in English.

3.

Make sure save your answer file as

ICT200_Test_FullName_StudentID.

Example: ICT200_Test_NikRuslawati_1234567890

4. Please submit ONLY ONE (1) answer file using PDF format.

1

CS/DIS2021/ICT200/ITS232

SELF DECLARATION

1. I know that plagiarism is wrong. Plagiarism is to use another’s work and

pretend that it is one’s own.

2. This Test is my own work.

3. I have not involved, and will not allow, anyone to copy my work with the

intention of passing it off as their own work.

4. I acknowledge that copying someone else’s work (or part of it) is wrong

and declare that my test is my own work.

© Hak Cipta Universiti Teknologi MARA CONFIDENTIAL

MARK INFORMATION

PART A /15

PART B /25

TOTAL /40

PART C (SQL) /20

PART A (15 MARKS)

1. Which of the following is TRUE about metadata?

A. It is raw facts of data.

B. It is a basic building blocks of information

2

CS/DIS2021/ICT200/ITS232

C. It contains data resources

D. It contains the characteristics of data.

2. ________ refers to a process that yields the description of the database structure and

determines the database components.

A. Database

B. Database system

C. Database design

D. Database Management System (DBMS)

3. The followings are the things that need to be considered when an organization need to

choose a database product EXCEPT

A. Number of users

B. Number of files

C. Database locations

D. Extend of use

4. Which of the following DOES NOT describe about function of DBMS?

A. Creates a security system that enforces user security and data privacy

B. Provides backup and data recovery to ensure data safety and integrity

C. Creates and manages complex structures required for data storage.

D. Enforce data integrity and does not eliminate data redudancy.

5. Which of the following is TRUE about business rules?

A. They allow the designer to set company policies while ignoring to data.

B. They allow the designer to develop business processes.

C. They can serve as a communication tool between the users and designers.

D. They provide a framework for the company’s self-actualization.

6. Which of the following BEST describes about conceptual Model?

A. Depend on the DBMS software used to implement the model

B. Changes in hardware or software do affect the database design

C. Represents end-user view

D. Provides a relatively easily understood macro level view of data environment