Description: A reseller of spare parts of automobile shop having multiple showroom and warehouse like to develop a database to manage its inventory system. It stock and sales different spare parts (with OEM number, Chassis Number, Model Number, Brand, Vehicle, Item Types, Descriptions, etc.) that have been purchase from the suppliers (with company name, contact person name, address, phone number, mobile number, Identity Name, Identity Number, email, etc.). These spare parts(items) have cost information, quantity information and different stock location (Ware House with name, location address, phone number, email address, etc. stores the items). If a client (with identity Name, Identity Number, name, address, phone number, mobile, email, etc.) purchase the item from a shop, after invoicing, shop will generate the delivery order (DO) to the warehouse/showroom mentioning all the delivery address and item details. After receiving the (DO), ware house/showroom start to packing the order and starts to dispatch the order according to its address. Shop always follow its buying and selling process. To purchase items, it will make an enquiry of the item to suppliers. After passing this enquiry , shop and supplier will negotiate on their pricing. After finalizing the cost, shop will generate a purchase order(PO) to the supplier, mentioning all the required items with all necessary details (with cost that is being negotiated and mentioning all terms and conditions). PO is termed as confirmed order so, the supplier dispatch the order to warehouse/showroom after certain payment procedure made. Lastly, warehouse/ showroom will start their procedure to include these purchase items into inventory. Similarly, sale process starts from the quotation. A client enquiry the required items and wish to take quotation. After quotation, if a client wish to purchase these items a Performa is made from the quotation negotiating all the constraints from the client. Finalizing payments procedures and delivery details, this leads to invoicing the items. UML Diagram LOGICAL DATABASE DESIGN Office (office id, company name, registration no, address, phone, mobile, fax, email, website, A/c no)Primary key = (office id) Suppliers (supplier id no., company name, contact person, address, phone, mobile, fax, email, website, identity no, identity name, A/c no, office id)Primary key = (supplier id)Foreign key = (office id) ~ > office(id) Showroom (showroom id, showroom name, registration number, address, phone, mobile, fax, email, website, A/c no, office id)Primary key = (showroom id)Foreign key = (office id) ~ > office (id) Clients (client id, company name, contact person, address, phone, mobile, fax, email, website, identity no, identity name, A/c no, showroom id)Primary key = (client id)Foreign key = (showroom id) ~ > showroom (id) Ware house (warehouse id, warehouse name, registration no, address, phone, mobile, fax, email, website, A/c no, showroom id)Primary key = (warehouse id)Foreign key = (showroom id) ~ > showroom (id) Items (item code, item desc, oem no.1, oem no.2, stock no.1, stock no.2, model no.1, model no.2, chasis no, vehicle, brand, cost price, sales price, stock location, discount percentage, supplier id)Primary key = (item code)Foreign key = (supplier id) ~ > supplier (id) Payment (payment id, payment type, agent id, agent type, invoice no, invoice date, invoice amount, invoice type, narration, A/c no, showroom id, dr amount, cr amount)Primary key = (payment id)Foreign key = (showroom id) ~ > showroom (id) Delivery (delivery id, packing no, shipping address, shipping port, item code, item description, stock location, delivery agent, transport modes, client id, confirm delivery)Primary key = (delivery id)Foreign key = (client id) ~ > client (id)
reseller of spare parts of automobile shop
Pssst…We can write an original essay just for you.
Any essay type. Any subject. We will even overcome a 6 hour deadline.
<< SAVE15 >>
Place your first order with code to get 15% discount right away!