This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Data Exam Study Guide Includes Chapters 2, 7, 8, 9 and Access Database Concepts 1. Define basic database vocabulary including: Database- a collection of related tables. Table/Entity- data about something we want to keep track of. Record- a row in a table. The actual object. Field/Attribute- a column. A characteristic of what you want to keep track of. Value- the contents of a cell. Primary Key- used to identify each record. How you can tell the diff between two things. Each table has one. Foreign Key- a field used to connect two tables together. The primary key of the parent is added to the child. Can have multiple foreign keys. Metadata- Data about data. In access, the table structure. Data Anomalies bad data 2. How do databases compare to spreadsheets? a. What are the limitations of spreadsheets that are overcome by a database? SS has only one sort order, DB has multiple. b. List other benefits database provide. Data is synced up. On demand reporting. b. Provide examples of appropriate uses of spreadsheets. c. Provide examples of appropriate uses for databases. d. What are the drawbacks of databases? more expensive, more complicated. 3. Relationships a. What is referential integrity? It will keep all your tables synced up if one table changes. b. Give some examples of when you would want to enforce it and when you wouldnt. c. What is a parent record/table? The original table. must be made first. d. What is a child record/table? Relies on the parent for some info. 4. Key Fields a. What are the rules for selecting good primary keys? It must be unique to each and every record. Only one per table. b. What are the rules for selecting good foreign keys? 5. Define each of the following types of databases including: Hierarchical Network Relational- Relates data in tables thru foreign keys. Multidimensional Object-Oriented 6. Queries a. Can you write queries in Access to achieve a specified output including: displaying desired columns-yes ACIS 1504 - 3d309dd7a7dcf2e4a6a8f19b4b67649a353df68a.doc Page: 1 of 7 hiding columns- yes displaying rows in a particular sort order- yes selecting desired rows including: - yes o simple selection o multiple selection criteria (AND, OR) o NOT o LIKE queries with summary calculations- yes queries with record calculations- yes b. What are the limitations of queries and how are they overcome? Data Resources 1. Data Warehouse a. What is a data warehouse? A huge database b. How is a data warehouse populated? Where does the data come from? Comes from numerous other databases where the data has been transformed to fit in. When? Every record has been time stamped....
View Full Document
This test prep was uploaded on 04/09/2008 for the course ACIS 1504 taught by Professor Jmlacoste during the Fall '07 term at Virginia Tech.
- Fall '07