Entity relationship diagram model of george’s garage

Entity relationship draw archetype of georges garage foundation garment kind between maven or more then one entity of gameboards by pripary see and foreign reveal is c in alled as Entity Relationship diagram model. This documentation will be on Entity Relationship diagram model of Georges Garage.Database InformationTables of the Garage Database Garage Database gives entropy of the hedge Name with primary winding key and Foreign Key.1)N machine_sale Pk N cable car_id2).Sh gondola car_Sale Pk- ShCar_id3).VehicleSale Pk Sale_id Fk- Ncar_id , ShCar_id, Dept_id4) Car_auction Pk au_id Fk- SHCar_id5) Car_Workshop Pk Workshop_id Fk dept_id, Car_servise_id6) Car_servise Pk Car_servise_id FK - Payment_id , Parts_id7) Servise_ honorarium Pk Payment_id Fk Staff_id8) Car_Parts Pk Parts_id9) Customer Pk cust_id10) Parts_Sale_Stock Pk Parts_sale_id Fk move_id, cust_id11) Parts_ put in Pk Order_id FK parts_id12) Suplier Pk - Suplier_id Fk - Order_id13) Department Pk - Dept_id 14) mental faculty Pk Staff_id FK dept_id15) Vehicle_Booking Pk - Booki_id Fk - Cust_id16) Vehicle_Hire Pk Hire_id Fk Booki_id, Dept_id17) Valeting_Servise Pk Valeting_servise_id FK booki_id, 18) Car_Hire Pk Car_Hire_id19) Vehicle Pk - Vehicle_id Fk booki_id, Car_Hire_id20) Sp_Car_Hire Pk - Sp_Car_id Fk - Vehicle_id21) Rolls_Roys Pk Rr_Car_id Fk Sp_Car_id 22) Limousines Pk Li_Car_id Fk Sp_Car_id23) Minibus Pk Mb_Car_id Fk Sp_Car_idEntity Relationship Diagram ConceptsKeys* Primary Key - Primary Key is a key that uniquely identify shelter of the accede Example- In payment duck, Payment_id is a primary key.Create table Servise_payment( payment_id varchar(5) non NULL shyness carser_pk PRIMARY KEY,)* Foreign Key - Foreign Key is a key thats indicates the primary Key of the another tableCreate 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 fore ign Key which point out another Payment_id of the Payment table Entity Collection of Attributes is known as Entity. In sql, parson table is a entity and Person_id, Person_name, person_Address and Person_BOD is a attributes of person.AssumeGenaral This entropybase on the George garage therefore it contains all breeding of the garage.there ar twenty three tables which are connected with each other..a. some(a) of the employee have kindred amount of salary because they may work in same section and same position.b. Some Cars Hire date are similar because different car might prosecute in same date.c. Some tables have Integer data type or ice-cream soda data type due to Price of part and seat of car respectively.Spacial1)Ncar_sale This Ncar tables contains concomitant of sales of the new cars2).ShCar_Sale This table store training intimately second transcend car. 3).VehicleSaleThis table keeps records of the New car and succor hand car sale. This table acts as sale department4) Car_auction Car auction table keeps record of car auction study. Second hand car apply in car auction 5) Car_Workshop This is Workshop department table. This table store data of car services in the workshop. 6) Car_servise This table gives information about service of the one car. Its also gives information about parts which are used in service, Payment and type of service. 7) Service_payment This payment table store payment information of each Service.8) Car_Parts Car parts table contain details of each Parts of the car. Some car parts also order from the supplier.9) Customer This table store customers information. 10) Parts_Sale_Stock This table is use for store information of parts sale11) Parts_order Parts order table contains parts order data. 12) Suplier This table used to store information about Supplier13) Department Department table contain all department information14) staff this table gives information of the all staff of the departsment 15) Vehicle_Hire This t able is a Hire department table which store involvement information.16) Vehicle_Booking This table used to book hire vehicle information as well as valeting Service information.17) Valeting_Servise This table keeps records of the valeting service. 18) Car_Hire Car hire tables contains information about only cars and Vans 19) Vehicle This Vehicle table store detail of the hire vehicles such as Car and special vehicle.20) Sp_Car_Hire Car hire tables contains information about only special vehicle such as Minibus, Rolls Roys and Limousines.21) Rolls_Roys Rolls Roys table contain information about rolls roys special vehicle.Rolls Roys is used for occation 22) Limousines Limousines table contain information about rolls roys special vehicle. Limousines used for wedding and nighttime outs23) Minibus Minibus table contain information about Minibus special vehicle. This table keeps records of airport pickup 5 Syntaxes.Create SyntaxCreate Syntax is used in sql which is for create tab le. Create Syntax is used in the data Definition language(DDL).For Example - This syntax for create Vehicle_sale table. Create table Vehicle_Sale( Sale_id int(3), New_car_sale_id varchar(5), Secondhandcar_sale_id varchar(5), Staff_id varchar(5)) barge in SyntaxInsert Syntax is used in sql which is for Insert value in the table. Insert Syntax is used in the data purpose language(DML).For Example This syntax for insert value in the Vehicle_saleInsert into Vehicle_Sale values(S01,Car01,sh01,em01) indicator Systax Index used for make search process easily and degenerateFor example In employee table, each employ has their own phone identification number and it is unique