DBMS EXAM ONE UPDATED Exam Questions and CORRECT Answers

DBMS EXAM ONE UPDATED Exam Questions and CORRECT Answers 1) What is redundancy? What problems are associated with redundancy? - Correct ANSWERRedundancy is the duplication of data or the storing of the same data in more than one place. Redundancy wastes space b/c 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 that take longer to save and open. It also makes changes more cumbersome, and it makes things inconsistent, for example, when you enter the same name three different ways (ex: johnsons vs johnson's, or johnsons'). 3) What is an entity? An attribute? - Correct ANSWER- An entity is a person, place, object, event, or idea for which you want to store and process data. (each entity has its own table). An attribute is a characteristic or property on an entity. Attributes= Also known as fields or columns in many database systems.