Intro to Database Systems Chapter 1 Essay

1016 Words Jul 2nd, 2013 5 Pages
Chapter 1
1 A. Data = raw fact (pg. 5)
B. Field = a character or group of characters that defines a characteristic of a person, place, or thing. (pg. 660)
C. Record = a collection of related fields (pg. 666)
D. File = a named collection of related record (pg. 660)
2. Data redundancy is when the same data are stored unnecessarily at different places. Spreadsheets /islands of information lead up to the date redundancy. (pg. 16)
3. Data independence is when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data. It standalone data so it doesn’t need to be link with anything. (pg. 15)
4. DBMS is a collection of programs that manages the
…show more content…
Operational database – a database that is designed primarily to support a company’s day to day operation.
Data warehouse – focuses primarily on storing data used to generate information required to make tactical or strategic decision. (pg. 9)
9. Hardware, software, people, procedures, and data (pg. 18-20)
10. Metadata is data about data (pg. 7)
11. Better and faster speed also less errors
12. Increased costs, management complexity, maintaining currency, vendor dependence, and frequent upgrade/replacement.
13. Unstructured data are data that exist in their original state but structured data not. It is the generation of information. The structured data is more prevalent in a typical business environment. (pg. 9-10)
14. Self-documentation through metadata, enforcement of data types or domains to ensure consistency of data within a column, defined relationships among tables, or constraints to ensure consistency of data across related tables. (pg. 23)
15. It doesn’t read your mind. It only received the raw data user put in.
16. Understanding the shortcomings of the file system enables you to understand the development of modern database. (pg. 14)

Chapter 2
1. Data model is a relatively simple representation, usually graphical, of more complex real world data structures. It is an iterative, progressive process (pg. 30)
2. Business rule is a brief, precise and unambiguous description of a policy, procedure, or principle within a