IS 3003 Chapter Notes - Chapter 6: Associative Entity, Data Quality, Structure Mining
Document Summary
Study online at quizlet. com/_1m84fs: database, relational database, entity, entity- relationship diagram: Collection of related files containing records on people, places, or things. Prior to digital databases, business used file cabinets with paper files. Organize data into two-dimensional tables (relations) with columns and rows. Generalized category representing person, place, thing on which we store and maintain information. Used to clarify table relationships in a relational database: fields store data representing an attribute. (columns, attributes, record. Enable users to view the same data in different ways using multiple dimensions. Each aspect of information product, pricing, cost, region, or time period represents a different dimension. Finds hidden patterns and relationships in large databases and infers rules from them to predict future behavior. Provides unique identifier for all information in any row: foreign key. Primary key of a jointed table: database. System (dbms: logical view, physical view, data. Software for creating, storing, organizing, and accessing data from a database.