Structured Systems Analysis and Design
(ICT2621) - Chapter 9 UPDATED ACTUAL
Questions and CORRECT Answers
Data Structures - CORRECT ANSWER - A framework for organizing, storing and
managing data. Consists of files or tables that interact in different ways
Schema - CORRECT ANSWER - The complete definition of a database, including
descriptions of all fields, tables and relationships is called a schema
Open Database Connectivity (OBDC) - CORRECT ANSWER - An industry-standard
protocol that makes it possible for software from different vendors to interact and exchange data
Entity - CORRECT ANSWER - A person, place, thing or event for which data is collected
and maintained
Table or File - CORRECT ANSWER - Contains a set of related records that store data
about a specific entity
Field - CORRECT ANSWER - A single characteristic or fact about an entity, also called an
attribute.
Record - CORRECT ANSWER - A set of related fields that describes one instance or
occurrence of an entity
Primary Key - CORRECT ANSWER - A field or combination of fields that uniquely
identifies a particular member of an entity
Candidate Key - CORRECT ANSWER - Any field that can serve as a primary key
(ICT2621) - Chapter 9 UPDATED ACTUAL
Questions and CORRECT Answers
Data Structures - CORRECT ANSWER - A framework for organizing, storing and
managing data. Consists of files or tables that interact in different ways
Schema - CORRECT ANSWER - The complete definition of a database, including
descriptions of all fields, tables and relationships is called a schema
Open Database Connectivity (OBDC) - CORRECT ANSWER - An industry-standard
protocol that makes it possible for software from different vendors to interact and exchange data
Entity - CORRECT ANSWER - A person, place, thing or event for which data is collected
and maintained
Table or File - CORRECT ANSWER - Contains a set of related records that store data
about a specific entity
Field - CORRECT ANSWER - A single characteristic or fact about an entity, also called an
attribute.
Record - CORRECT ANSWER - A set of related fields that describes one instance or
occurrence of an entity
Primary Key - CORRECT ANSWER - A field or combination of fields that uniquely
identifies a particular member of an entity
Candidate Key - CORRECT ANSWER - Any field that can serve as a primary key
