Concept of Dbms
Angeles University Foundation
College of Computer Studies
Bachelor of Science in Information Technology
DMS 410 – Database Management System 1
Chapter 1 - Introduction to Database Management
Answers to Review Questions
What is redundancy? What problems are associated with redundancy?
1. Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space, makes the updating of data more cumbersome and time-consuming, and can lead to inconsistencies.
Besides redundancy, what other problems are associated with the non-database approach to processing data?
2. The problems, other than redundancy, associated with the nondatabase approach to processing data include difficulties accessing related data, limited security features to protect data from access by unauthorized users, limited ability for multiple users to update the same data at the same time, and size limitations.
What is an entity? An attribute?
3. An entity is a person, place, object, event, or idea for which you want to store and process data. An attribute, which is also called a field or column in many database systems, is a characteristic or property of an entity.
What is a relationship? A one-to-many relationship?
4. A relationship is an association between entities. A one-to-many relationship exists between two entities when each row in the first entity matches many rows in the second entity and each row in the second entity matches only one row in the first entity.
What is a database?
5. A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities.
How do you create a one-to-many relationship in a database system?
6. In a database system, you create a one-to-many relationship by using common columns in the two tables.
What is an E-R diagram?
7. An E-R diagram represents a database in a
College of Computer Studies
Bachelor of Science in Information Technology
DMS 410 – Database Management System 1
Chapter 1 - Introduction to Database Management
Answers to Review Questions
What is redundancy? What problems are associated with redundancy?
1. Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space, makes the updating of data more cumbersome and time-consuming, and can lead to inconsistencies.
Besides redundancy, what other problems are associated with the non-database approach to processing data?
2. The problems, other than redundancy, associated with the nondatabase approach to processing data include difficulties accessing related data, limited security features to protect data from access by unauthorized users, limited ability for multiple users to update the same data at the same time, and size limitations.
What is an entity? An attribute?
3. An entity is a person, place, object, event, or idea for which you want to store and process data. An attribute, which is also called a field or column in many database systems, is a characteristic or property of an entity.
What is a relationship? A one-to-many relationship?
4. A relationship is an association between entities. A one-to-many relationship exists between two entities when each row in the first entity matches many rows in the second entity and each row in the second entity matches only one row in the first entity.
What is a database?
5. A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities.
How do you create a one-to-many relationship in a database system?
6. In a database system, you create a one-to-many relationship by using common columns in the two tables.
What is an E-R diagram?
7. An E-R diagram represents a database in a