Entity relationship diagram model of george’s garage

Substance relationship outline model of george㠢â‚ ¬Ã¢â€ž ¢s carport Presentation Connection between at least one then one element of tables by pripary key and outside key is called as Entity Relationship graph model. This documentation will be on Entity Relationship chart model of Georges Garage. Database Information Tables of the Garage Database Carport Database gives data of the table Name with Primary key and Foreign Key. 1)Ncar_sale Pk: Ncar_id 2).ShCar_Sale Pk:- ShCar_id 3).VehicleSale Pk: Sale_id Fk:- Ncar_id , ShCar_id, Dept_id 4) Car_auction Pk : au_id Fk:- SHCar_id 5) Car_Workshop Pk: Workshop_id Fk : dept_id, Car_servise_id 6) Car_servise Pk : Car_servise_id FK :- Payment_id , Parts_id 7) Servise_payment Pk : Payment_id Fk : Staff_id 8) Car_Parts Pk : Parts_id 9) Customer Pk : cust_id 10) Parts_Sale_Stock Pk : Parts_sale_id Fk : parts_id, cust_id 11) Parts_order Pk : Order_id FK : parts_id 12) Suplier Pk :- Suplier_id Fk :- Order_id 13) Department Pk :- Dept_id 14) staff Pk : Staff_id FK : dept_id 15) Vehicle_Booking Pk :- Booki_id Fk :- Cust_id 16) Vehicle_Hire Pk : Hire_id Fk : Booki_id, Dept_id 17) Valeting_Servise Pk : Valeting_servise_id FK : booki_id, 18) Car_Hire Pk : Car_Hire_id 19) Vehicle Pk :- Vehicle_id Fk : booki_id, Car_Hire_id 20) Sp_Car_Hire Pk :- Sp_Car_id Fk :- Vehicle_id 21) Rolls_Roys Pk : Rr_Car_id Fk : Sp_Car_id 22) Limousines Pk : Li_Car_id Fk : Sp_Car_id 23) Minibus Pk : Mb_Car_id Fk : Sp_Car_id Element Relationship Diagram Concepts Keys * Primary Key :- Primary Key is a key that extraordinarily recognize estimation of the table Model:- In installment table, Payment_id is an essential key. Make table Servise_payment ( payment_id varchar(5) NOT NULL CONSTRAINT carser_pk PRIMARY KEY, ) * Foreign Key :- Foreign Key is a key that is demonstrates the essential Key of the another table Make table Car_servise ( Payment_id varchar(5) NOT NULL CONSTRAINT spayme_fk FOREIGN KEY REFERENCES Servise_payment(payment_id) ) * Example :- In Car_Service table, Payment_id is a remote Key which point out another Payment_id of the Payment table Element Assortment of Attributes is known as Entity. In sql, parson table is an element and Person_id, Person_name, person_Address and Person_BOD is a traits of individual. Accept Genaral This database on the George carport along these lines it contains all data of the garage.there are twenty three tables which are associated with one another.. a. A portion of the worker have same measure of compensation since they may work in same office and same position. b. A few Cars Hire date are comparable in light of the fact that distinctive vehicle may employ in same date. c. A few tables have Integer information type or buoy information type because of Price of part and seat of vehicle separately. Spacial 1)Ncar_sale This Ncar tables contains detail of deals of the new vehicles 2).ShCar_Sale This table store data about recycled vehicle. 3).VehicleSale This table tracks the New vehicle and Second hand vehicle deal. This table goes about as deal office 4) Car_auction Vehicle sell off table keeps record of vehicle closeout data. Recycled vehicle utilized in vehicle sell off 5) Car_Workshop This is Workshop office table. This table store information of vehicle benefits in the workshop. 6) Car_servise This table gives data about help of the one vehicle. Its additionally gives data about parts which are utilized in administration, Payment and kind of administration. 7) Service_payment This installment table store installment data of each Service. 8) Car_Parts Vehicle parts table contain subtleties of every piece of the vehicle. Some vehicle parts additionally request from the provider. 9) Customer This table store clients data. 10) Parts_Sale_Stock This table is use for store data of parts deal 11) Parts_order Parts request table contains parts request information. 12) Suplier This table used to store data about Supplier 13) Department Division table contain all office data 14) staff this table gives data of the all staff of the departsment 15) Vehicle_Hire This table is a Hire division table which store booking data. 16) Vehicle_Booking This table used to book recruit vehicle data just as valeting Service data. 17) Valeting_Servise This table tracks the valeting administration. 18) Car_Hire Vehicle enlist tables contains data about just vehicles and Vans 19) Vehicle This Vehicle table store detail of the recruit vehicles, for example, Car and uncommon vehicle. 20) Sp_Car_Hire Vehicle recruit tables contains data about just exceptional vehicle, for example, Minibus, Rolls Roys and Limousines. 21) Rolls_Roys Moves Roys table contain data about rolls roys uncommon vehicle.Rolls Roys is utilized for occation 22) Limousines Limousines table contain data about rolls roys exceptional vehicle. Limousines utilized for wedding and night outs 23) Minibus Minibus table contain data about Minibus unique vehicle. This table tracks Airport pickup 5 Syntaxes. Make Syntax Make Syntax is utilized in sql which is for make table. Make Syntax is utilized in the information Definition language(DDL). For Example :- This punctuation for make Vehicle_sale table. Make table Vehicle_Sale ( Sale_id int(3), New_car_sale_id varchar(5), Secondhandcar_sale_id varchar(5), Staff_id varchar(5) ) Addition Syntax Addition Syntax is utilized in sql which is for Insert an incentive in the table. Addition Syntax is utilized in the information Manipulation language(DML). For Example : This linguistic structure for embed an incentive in the Vehicle_sale Addition into Vehicle_Sale values(S01,Car01,sh01,em01); List Systax List utilized for make search process effectively and quick For instance : In representative table, each utilize has their own telephone number and it is extraordinary