- Posted By: freeproject
- Comments: 0
Posted By freeproject on July 17, 2017
This ER (Entity Relationship) Diagram represents the model of Automobiles Store and Service Management System Entity. The entity-relationship diagram of Automobiles Store and Service Management System shows all the visual instrument of database tables and the relations between Store, Services, Automobiles, Delivery etc. It used structure data and to define the relationships between structured data groups of Automobiles Store and Service Management System functionalities. The main entities of the Automobiles Store and Service Management System are Automobiles, Store, Customer, Services, Charges and Delivery.
Automobiles Store and Service Management System entities and their attributes :
- Automobiles Entity : Attributes of Automobiles are automobiles_id, automobiles_customer_id, automobile_number, automobile_type, automobile_description
- Store Entity : Attributes of Store are store_id, store_type, store_title, store_description
- Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
- Services Entity : Attributes of Services are service_id, service_vehicle_id, service_charge, service_type, service_description
- Charges Entity : Attributes of Charges are charge_id, charge_service_id, charge_amount, charge_total, charge_type, charge_description
- Delivery Entity : Attributes of Delivery are delivery_id, delivery_customer_id, delivery_address, delivery_type, delivery_by, delivery_date, delivery_description
Description of Automobiles Store and Service Management System Database :
- The details of Automobiles is store into the Automobiles tables respective with all tables
- Each entity (Delivery, Customer, Charges, Store, Automobiles) contains primary key and unique keys.
- The entity Customer, Charges has binded with Automobiles, Store entities with foreign key
- There is one-to-one and one-to-many relationships available between Charges, Services, Delivery, Automobiles
- All the entities Automobiles, Charges, Customer, Delivery are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Automobiles Store and Service Management System tables for fast query execution.