Answer the following questions with your own answers and

Question

Answer the following questions with your own answers and thoughts. DO NOT USE THE INTERNET, GOOGLE, OR ANY OTHER WEB SOURCE. You may use your notes and book ONLY. Copy and pasting will be considered cheating.

1. What is a DBMS, in particular, a relational DBMS?
2. Why should we consider a DBMS to manage data?
3. How is application data represented in a DBMS?
4. How is data in a DBMS retrieved and manipulated?
5. What are the steps in designing a database?
6. Why is the ER model used to create an initial design?
7. What are the main concepts in the ER model?
8. What are guidelines for using the ER model effectively?
9. How is data represented in the relational model?
10. What integrity constraints can be expressed?
11. How can data be created and modified?
12. How can data be manipulated and queried?
13. What is the foundation for relational query languages like SQL? What is the difference between procedural and declarative languages?
14. What is relational algebra, and why is it important?
15. What are the basic algebra operators, and how are they combined to write complex queries?
16. What is relational calculus, and why is it important?
17. What is included in the SQL language? What is SQL:1999?
18. How are queries expressed in SQL? How is the meaning of a query specified in the SQL standard?
19. How does SQL build on and extend relational algebra and calculus?
20. What is grouping? How is it used with aggregate operations?