• data and information are valuable assets to an organization
• methods for maintaining high-quality data and assessing the quality of valuable information
• advantages of organizing data in a database and described various types of databases
• roles of the database analysts and administrators
• Database is a collection of data organized in a manner that allows access, retrieval, and use of that data.
• Data is a collection of unprocessed items, which can include text, numbers, images, audio, and video. Information is processed data; that is, it is organized, meaningful, and useful.
• Database software, database management system (DBMS), allows users to create a computerized database; add, modify, and delete the data; sort and retrieve the data; and create forms and reports from the data.
• A bit is the smallest unit of data a computer can process.
• Eight bits grouped together in a unit form a byte, and each byte represents a single character, which can be a number, letter, space, punctuation mark, or other symbol.
• A field is a combination of one or more related characters and is the smallest unit of data a user accesses.
• A record is a group of related fields.
• A data file is a collection of related records stored on a storage medium.
• File maintenance refers to the procedures that keep data current.
• Validation is the process of comparing data with a set of rules or values to find out if the data is correct.
• Types of validity checks include an alphabetic check, a numeric check, a range check, a consistency check, a completeness check, and a check digit.
• A data dictionary contains data about each file in the database and each field within those files.
• A DBMS offers several methods to retrieve and maintain data, such as query languages, query by example, forms, and report generators.
• A query language consists of simple, English-like statements that allow users to specify the data to display, print, or store.
• A report generator allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. A backup is a copy of the database.
• A log is a listing of activities that change the contents of the database.
• A recovery utility uses the logs and/or backups to restore the database.
• Continuous backup is a backup plan in which all data is backed up whenever a change is made.
• A data model consists of rules and standards that define how the database organizes data.
Three popular data models are
-Relational
-Object-oriented
-Multidimensional
• methods for maintaining high-quality data and assessing the quality of valuable information
• advantages of organizing data in a database and described various types of databases
• roles of the database analysts and administrators
• Database is a collection of data organized in a manner that allows access, retrieval, and use of that data.
• Data is a collection of unprocessed items, which can include text, numbers, images, audio, and video. Information is processed data; that is, it is organized, meaningful, and useful.
• Database software, database management system (DBMS), allows users to create a computerized database; add, modify, and delete the data; sort and retrieve the data; and create forms and reports from the data.
• A bit is the smallest unit of data a computer can process.
• Eight bits grouped together in a unit form a byte, and each byte represents a single character, which can be a number, letter, space, punctuation mark, or other symbol.
• A field is a combination of one or more related characters and is the smallest unit of data a user accesses.
• A record is a group of related fields.
• A data file is a collection of related records stored on a storage medium.
• File maintenance refers to the procedures that keep data current.
• Validation is the process of comparing data with a set of rules or values to find out if the data is correct.
• Types of validity checks include an alphabetic check, a numeric check, a range check, a consistency check, a completeness check, and a check digit.
• A data dictionary contains data about each file in the database and each field within those files.
• A DBMS offers several methods to retrieve and maintain data, such as query languages, query by example, forms, and report generators.
• A query language consists of simple, English-like statements that allow users to specify the data to display, print, or store.
• A report generator allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. A backup is a copy of the database.
• A log is a listing of activities that change the contents of the database.
• A recovery utility uses the logs and/or backups to restore the database.
• Continuous backup is a backup plan in which all data is backed up whenever a change is made.
• A data model consists of rules and standards that define how the database organizes data.
Three popular data models are
-Relational
-Object-oriented
-Multidimensional