Solve the clues and complete the puzzle. 1. A collection of data stored in a PC in a systematic way.
2. A unit of a database file made up of related fields.
3. A single piece of information in a record.
4. A…………………..database maintains separate, related files, but combines data elements from the files for queries and reports.
5. Some companies have several computers sharing a database over a ……………………...
6. To look for specific information, for example the name of an employee.
7. To classify records into numerical or alphabetical order.
8. A tool that allows you to extract information that meets certain criteria.
2. A unit of a database file made up of related fields is called a table. A table consists of rows (also known as records) and columns (also known as fields), which store specific types of data. Each table in a database is designed to hold data related to a specific topic or entity.
3. A single piece of information in a record is called a field. Fields store specific types of information, such as names, addresses, dates, or numbers. Each field in a record represents a different attribute of the entity being stored in the database.
4. A relational database maintains separate, related files, but combines data elements from the files for queries and reports. This type of database is called a relational database because it establishes relationships between different tables based on common fields. By combining data from multiple tables, relational databases allow us to extract meaningful information and answer complex queries.
5. Some companies have several computers sharing a database over a network. This network is called a shared or networked database. It allows multiple users or computers to access and interact with the same database simultaneously. This is particularly useful in environments where multiple users need to work with and update the same data.
6. To look for specific information, for example, the name of an employee, we use a search or query. By entering specific criteria or keywords, we can search for records that meet those criteria in a database. This helps in finding relevant information quickly and efficiently.
7. To classify records into numerical or alphabetical order, we use sorting. Sorting allows us to arrange and organize records in a logical and ordered manner based on specific fields. For example, if we want to sort a list of employees by their last names, we can arrange them alphabetically from A to Z or Z to A.
8. A tool that allows you to extract information that meets certain criteria is called a query tool. It enables users to define specific criteria or conditions to filter and extract desired data from a database. This helps in generating reports, analyzing patterns, and making informed decisions based on the extracted information.