I have 35 written questions and 5 SQL assignments. I will provide all three Query languages for the database and the ER Diagram. For the SQL assignments, you must provide both the SQL statement an

Review Questions 1


Please answer these questions in your own words:


1. What is redundancy? What problems are associated with redundancy?

2. What is an entity?An attribute?

3. What is a relationship?A one-to-many relationship?

4. How do you create a one-to-many relationship in a database system?

5. What is an E-R diagram?

6. What is database design?

7. What is an integrity constraint? When does a database have integrity?

8. What is data independence? Why is it desirable?

9. How can the complexity of a DBMS be a disadvantage?

10. Why can a failure in a database environment be more serious than an error in a nondatabase environment?