Databases 1 - JSS3 Computer Studies Past Questions and Answers - page 1
What is the primary purpose of a database?
Entertainment
Efficient data retrieval and management
Artistic expression
Physical exercise
Which type of database relies on physical records and manual methods?
Relational database
Hierarchical database
Computerized database
Manual database
In a hierarchical model, how is data organized?
Into tables with rows and columns
In a tree-like structure with a top-down hierarchy
As a collection of records connected by relationships
Into networks of interconnected nodes
Which model allows for more flexible relationships and many-to-many connections?
Hierarchical model
Relational model
Network model
Circular model
What is the primary advantage of the relational model?
Rigid structure
Complex design
Flexibility and scalability
Manual data entry
Which database terminology represents a collection of related data organized in rows and columns?
Field
Record
Table
Key
What is a primary key used for in a relational database?
To represent an attribute or characteristic
To link to the primary key of another table
To establish relationships between tables
To ensure unique identification of each record
What is a foreign key in a relational database?
A unique identifier for each record
A field linking to the primary key of another table
A table with rows and columns
An attribute or characteristic
Which type of model uses a set of mathematical principles in its design?
Hierarchical model
Relational model
Network model
Circular model
What does a record represent in a database table?
A complete set of data
A single data element
A unique identifier
An attribute or characteristic