Relational Database Principles and Designing Using SQL Assignment

This assignment delves into the core concepts of relational database design and implementation using SQL. It begins with an exploration of relational algebra, demonstrating its application through various queries. The assignment then progresses to practical SQL query writing, covering SELECT statements to retrieve specific information from a sample database. Further SQL tasks involve creating tables, adding data, and modifying table structures. A significant portion of the assignment focuses on database normalization, explaining the problems associated with poorly designed databases and demonstrating the process of converting a database to Third Normal Form (3NF) to eliminate data redundancy and improve data integrity. Finally, the assignment concludes with a conceptual design exercise, requiring the creation of an entity-relationship diagram (ERD) for a given scenario, along with a list of assumptions made during the data modeling process. The assignment covers topics like database design, SQL, normalization, and ER diagrams.