Questions:
Discussion 1
Relational Algebra and SQL
• What is relational algebra?
• What is the connection between relational algebra and SQL. Use at least two examples to compare the syntax of relational algebra and SQL statement.
Discussion 2
Entity Relationship Model and Database Design
• Explain why the entity relationship (ER) model is useful. How has it helped to produce a more structured relational database design environment?
Discussion 3
Data Redundancy and Normalization
• Discuss the relationship between data redundancy and normalization. What are the consequences if databases are not normalized? What problems is normalization addressing? Why is normalization crucial for effective database design and development?
Discussion 4
Structured Query Language
• Explain SQL and its functions.