Intro to Database Systems Chapter 1
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 database structure and controls access to the data stored in the database. It helps manage the cabinet’s contents (pg. 7)
5. Structural independence is when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. (pg. 15) It’s important because it can modify the data without cause any interruption other to access the data
6. Data are raw facts but information is raw facts that has meaning (pg. 5)
7. DBMS serves as the intermediary between the user and the database. The advantages are improved data sharing, data security, better data integration, minimized data inconsistency, improved data access, improved decision making, and increased end user productivity. (pg. 8-9)
8. Single user database – supports only user at a time.
Desktop database – single-user database that runs on a personal computer.
Multiuser database – supports multiple users at the same time.
Workgroup database – when the multiuser database supports a relatively small number of users or a specific department within an organization.
Enterprise database - when the database is used by the entire organization and supports many users.
Centralized database - A database that supports data
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 database structure and controls access to the data stored in the database. It helps manage the cabinet’s contents (pg. 7)
5. Structural independence is when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. (pg. 15) It’s important because it can modify the data without cause any interruption other to access the data
6. Data are raw facts but information is raw facts that has meaning (pg. 5)
7. DBMS serves as the intermediary between the user and the database. The advantages are improved data sharing, data security, better data integration, minimized data inconsistency, improved data access, improved decision making, and increased end user productivity. (pg. 8-9)
8. Single user database – supports only user at a time.
Desktop database – single-user database that runs on a personal computer.
Multiuser database – supports multiple users at the same time.
Workgroup database – when the multiuser database supports a relatively small number of users or a specific department within an organization.
Enterprise database - when the database is used by the entire organization and supports many users.
Centralized database - A database that supports data