WorksheetsDBC CH02 & CH03 (1125)
Total questions: 15
Worksheet time: 8mins
A Malaysian polytechnic stores student information in the form of rows and columns. Which data model is being used?
Hierarchical Model
Network Model
Relational Model
Object-Oriented Model
In the HR system of a Malaysian company, each employee record must be unique. Which attribute is most suitable as a Primary Key?
StaffName
StaffID
DepartmentName
StaffAddress
In the department table, deptNo is used to uniquely identify each department. What type of key is this?
Foreign Key
Secondary Key
Primary Key
Composite Key
What is an entity in data modeling?
An SQL command
An organizational rule
Something about which data is collected and stored
A relationship between tables
In a Malaysian university system, students can register for many subjects, and each subject can have many students. What type of relationship is this?
One-to-One (1:1)
One-to-Many (1:M)
Many-to-Many (M:N)
Recursive
A government department system in Malaysia does not allow NULL values for staff IC numbers. This rule is related to:
Referential Integrity
Entity Integrity
Business Rule
Indexing
In the staff table, the attribute DeptNo refers to DeptNo in the department table. What type of key is DeptNo in the staff table?
Primary Key
Composite Key
Foreign Key
Candidate Key
Why must data redundancy be controlled in a Malaysian hospital database system?
To increase internet speed
To prevent data anomalies
To reduce the number of tables
To hide user data
In a college ERD, one lecturer teaches many classes, but each class is taught by only one lecturer. What type of relationship is this?
One-to-One (1:1)
One-to-Many (1:M)
Many-to-Many (M:N)
Weak relationship
What is the main function of a data dictionary in a DBMS?
To store student data
To store metadata
To store SQL queries
To store database backups
A Malaysian public university uses Student ID + Program Code to uniquely identify each student. This is an example of a:
Primary Key
Foreign Key
Composite Key
Secondary Key
Why can a many-to-many (M:N) relationship not be directly implemented in the relational model?
It is not supported by SQL
It causes data redundancy
It must be transformed into one-to-many relationships
It has no primary key
In Malaysia’s government e-procurement system, indexes are mainly used to:
Increase security
Reduce redundancy
Speed up data retrieval
Prevent NULL values
Changes in physical data storage do not affect the logical design of a database. This concept is known as:
Logical Independence
Physical Independence
Entity Integrity
Data Abstraction
In a Malaysian HR policy, the rule “Every staff member must belong to one department” is an example of a:
Attribute
Entity
Relationship
Business Rule
