TM111 - Book 1 Part 4 - A World Built of Data Exam 2023 Solved 100% Correct

Data - ANSWER-Facts, figures, and other evidence gathered through observations. information - ANSWER-Data converted into a meaningful and useful context database - ANSWER-a collection of organized data that allows access, retrieval, and use of data SABRE - ANSWER-the first civilian computer application to provide real time responses to enquiries. Used for airline bookings. IMS - ANSWER-a joint hierarchical database and information management system with extensive transaction processing capabilities. database responsibility - ANSWER-database designers are able to present data selectively. Search Engine Optimization - ANSWER-the process of maximizing the number of visitors to a particular website by ensuring that the site appears high on the list of results returned by a search engine. Flat database - ANSWER-A simple database file that is not related or linked to any other collection of data. query language - ANSWER-consists of simple, English-like statements that allow users to specify the data to display, print, store, update, or delete SQL - ANSWER-Structured Query Language, commonly used for managing databases by typing commands. The limitiations of flat databases - ANSWER-The computer has more data to read through, so accessing and searching through them can be slow. Data has to be repeated and leads to inputting errors and inconsistencies. File sizes can be large due to repeated data. Spreadsheet vs Database - ANSWER-A spreadsheet is a screen-oriented interactive program enabling a user to lay out financial data on the screen. A Database is a collection of organized data that allows access, retrieval, and use of data relational database - ANSWER-A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables normalisation - ANSWER-Process of converting a database from a flat file database to a relational database. database entity - ANSWER-an item that we would like to store information about tangible - ANSWER-capable of being touched; real, concrete intangible - ANSWER-unable to be touched or grasped; not having physical presence Database Attribute - ANSWER-Describes an entity or distinct characteristics about it Database Key - ANSWER-a field in a table used to identify a record, such as EmployeeNumber Joining Table - ANSWER-A table that re-establishes the relationships between the entities identified. Database View - ANSWER-A virtual table that provides access to specific columns in one or more tables. A view doesn't hold any data but presents the data in the underlying table or tables. A database administrator can grant access to a view without granting access to a table to limit what a user can see and manipulate. Database Management System (DBMS) - ANSWER-creates, reads, updates, and deletes data in a database while controlling access and security Standards - ANSWER-tightly defined descriptions of how a product should be constructed or operated. SQL is an ISO standard. ISO - ANSWER-International Organization for Standardization legacy system - ANSWER-Older information systems that are often incompatible with other systems, technologies, and ways of conducting business. Incompatible legacy systems can be a major roadblock to turning data into information, and they can inhibit firm agility, holding back operational and strategic initiatives. Big Data - ANSWER-a broad term for datasets so large or complex that traditional data processing applications are inadequate. data sampling - ANSWER-the selection of a sample to estimate the characteristics of an entire population big data analytics - ANSWER-the process of examining large amounts of data of a variety of types to uncover hidden patterns, unknown correlations, and other useful information Three Vs of Big Data - ANSWER-volume, velocity, variety