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?