18 Questions
What is the primary purpose of databases according to the text?
To organize and store data for future access
How are files and databases different in terms of data storage?
Files store data required for application use, while databases store data for future access
What role does Database Management Software (DBMS) play in database management?
Managing database creation, tables, and data security
What is the purpose of an e-tag in the context of the text?
To track and identify different items using radio frequency
How do electronic tags (tags) transmit information in the context of the text?
By emitting a radio frequency to a tag reader or vice versa
What is the main advantage of using RFID technology mentioned in the text?
Tracking and identifying items with tiny chips
In what way have web forms changed the way business is conducted according to the text?
By limiting errors in user input and favoring online documentation
What was the main goal of SANRAL's electronic toll (e-toll) system in Gauteng, as mentioned in the text?
To fund a highway improvement project through toll collection
What is the primary reason for normalizing a database?
To efficiently organize data
Why is denormalized data in a flat-file database problematic?
It leads to anomalies
What does Edgar F Codd consider as the main goal of normalization?
Efficiently organizing data
How does a poorly planned flat-file database affect data handling as it grows?
Causes difficulties in handling data
What makes handling data increasingly difficult in a poorly planned database?
Introduction of anomalies
What is the significance of a primary key in a database?
It ensures that there are no duplicates in the records.
In a relational database, what is the role of multiple connected tables?
To group related fields together based on unique identifiers.
How do fields differ from records in a database?
Fields group related information, while records store individual data entries.
Why do database creators usually create a new field specifically for the primary key?
To ensure that there are no duplicates in the records.
What is the purpose of having a compulsory field called a primary key in each table of a database?
To hold a unique identifier for each record to refer to a specific entry.
Explore the basics of data collection, key warehousing concepts, and the difference between data warehousing and databases. Learn how to collect and mine data, along with a revision of database fundamentals.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free