Chapter_5_Outline.odt

Test 2 Outlines Chapter 5 Outline ? Database Processing Quiz 1 Questions: A Collection of similar records is called a _______ Field : also known as columns which include groups of bytes. File : Also called a Table and is a group of similar rows or records Database: A self-describing collection of integrated records. A group of columns that identify a unique table: Key SQL is a ______ Query Language ? Structured Query Language Programming Language Other key terms Forms ? Used to enter data into a database Query ? Used to search a database Reports ? Prints wanted data in a structured form. Entity-Relationship Data Model (ERD) A tool for constructing data models, Developers use it to describe the content of a data model with ENTITIES and RELATIONSHIPS UML (unified modeling language used) ENTITY ? always a nown that users want to track. RELATIONSHIP ? N:M many to many; 1:M one to many Crows-foot diagram; o means optional. A small line means it ' s required. Maximum Cardinality and Minimum Cardinalities: 1:N, N:M, and 1:1 NORMALIZATION ? Kills redundant data (1 poorly constructed table into 2 or more) The data is repeated like department number and department name. Reduces the amount of data. Foreign Key ? Keys of different tables than the one they appear in. Metadata ? Data that discribes data (Field Properties/Cell description field in Acess below) Data Integrity ? When data in the same column has a different name for the same row. Data vs. a Spreadsheet Rule Lists of data involving a single theme can be stored in a spreadsheet; lists that involve data with multiple themes require a database. Components of a DBMS or Database management system: Used to create process and administer a database User --- Database Application --- DBMS --- Database Database Administration: Development ? Create and staff DBA function, Form steering committee, Specify requirements, validate data model, evaluate application Operation ? manage right s and responsibilities, manage security, track problems and manage solutions, monitor database performance, Manage DBMS. Backup and Recovery ? Monitor backup procedures, conduct training, manage recovery Adaptation ? Set up request tracking system, manage configuration change. Database Application ? A collection of forms , reports , queries , and application programs that process a database. Multi-User processing poses a problem with accessing the same database: Lost-update-Problem. Enterprise DBMS VS. Personal DBMS; Enterprise: IBM ' s DB2, microsoft ' s SQL server, and Oracle ' s oracle Personal DBMS: used for fewer than 100 users, or even fewer than 15. Access is the most common and popular today. Data Aggregators ? companies that obtain public and private data, and then process and store it in a sophisticated way . (Grocery store club card)