Database Management: Terms and Concepts, Quizzes of Accounting

Download Database Management: Terms and Concepts and more Quizzes Accounting in PDF only on Docsity! TERM 1 Terms: Metadata DEFINITION 1 - data that describes data. The format depends on the software product that is processing the database. Example: how many tables I want to have, table names. Any additional data requirements check to make sure they are met. TERM 2 Terms: Anomaly DEFINITION 2 - bad/flawed data Redundancy (idleness) Example: when the same user uses two different emails and is stored as two different customers. Two accounts = two catalogues sent = more money spent. If redundancy is cut down, anomaly is cut down. TERM 3 Terms: Table/Entity DEFINITION 3 set of related records what users want to track. TERM 4 Terms: Record/Instance DEFINITION 4 row, an example of that object. TERM 5 Terms: Field/Attribute DEFINITION 5 column, a characteristic of that object. TERM 6 Terms: Value DEFINITION 6 content of cell, text that represents one field or record what we care about. TERM 7 Terms: Normalization DEFINITION 7 he process of converting poorly structured tables into two or more well-structured tables Normalized tables eliminate data duplication, but they can be slower to process - General Goal: to construct tables such that every table has a single topic or theme TERM 8 Database: DEFINITION 8 o A database is a self-describing collection of integrated records. wiki: A database consists of an organized collection of data for one or more multiple uses. TERM 9 Database: Purpose DEFINITION 9 To keep track of data with multiple themes Access to information to help people do their jobs more easily and quickly TERM 10 Database: Benefits DEFINITION 10 On-demand information retrieval Multiple people can be working on it at once metadata Only relevant data is output Data is independent of the programs that act on it Referential integrity can be enforced automatically synchronization between information