Database Assignment: Designing a Logical Data Model for Car Dealership

This assignment focuses on designing a logical data model for a car dealership. The solution includes the creation of tables for manufacturers, dealers, sales, customers, and cars. The database design incorporates primary and foreign keys to establish relationships between the tables, with a focus on creating efficient and unambiguous data structures. SQL queries are provided to define the table structures. The assignment also addresses normalization principles to ensure data integrity and minimize redundancy. The relationships between entities such as manufacturers and dealers, cars and dealers, customers and sales are designed in the form of normalization. The solution explains the one-to-many and zero-to-many relationships. The model also includes the details of the normalization process to eliminate data duplication.