Ch1 Review Questions Itcs215 - Database Mgmt

1045 Words5 Pages
1. What is redundancy? What problems are associated with redundancy? Redundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space because you’re storing the same data in multiple places. The extra space results in larger spreadsheets that require more space in memory and on disk and that take longer to save and open. 2. Besides redundancy, what other problems are associated with the nondatabase approach to processing data? 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. 3. What is an entity? An attribute? An Entity is a person, place, object, event or idea for which you want to store and process data. An Attribute is a characteristic or property of an entity. 4. What is a relationship? A one-to-many relationship? A Relationship is an association between entities. A One-too-many relationship is when a rep is associated with several costumers, but that costumer is only associated with one rep. 5. What is a database? A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities. 6. How do you create a one-to-many relationship in a database system? Either by using an SQL or by using a graphical management tool like MS Access. 7. What is an E-R diagram? An E-R diagram is a visual way to represent a database. 8. What is a DBMS? A Database Management System is a program, or a collection of programs, through which users interact with a database. 9. What is database design? Database Design is
Open Document