Creating a Logical Data Model for Car Dealership Database Systems

This assignment presents a logical data model for a car dealership, designed to efficiently store and manage information about manufacturers, car models, sales, and customers. The solution includes the creation of tables for Manufacturers, Dealers, Sales, Customers, and Cars, with appropriate primary and foreign key relationships to ensure data integrity. SQL queries are provided to demonstrate how to create these tables. The assignment emphasizes normalization principles to minimize data redundancy and ensure data consistency. The relationships between entities, such as one-to-many relationships between customers and sales, and cars and products, are clearly defined. The solution showcases the application of normalization rules to improve the database's processing efficiency and maintain unambiguous results. The model encompasses all aspects of a dealership's operations, from manufacturer details to customer contact information and sales records.