PART-A1.Model Description:The trading company which sells vehicles of both new and used type maintainsinformation about its vehicles, its manufacturer and its sales details in a database. Avehicle is manufactured by a manufacturer who is uniquely identified with the help ofmanufacturer id. The details of the manufacturer like name, phone number and industryrank are preserved in the database. The manufacture holds many address each forparticular type. The vehicle in the motor company is identified with the help vehicle id.The chassis number of the vehicle is maintained in the database for reference purpose.The vehicles of the company are classified into new vehicles and used vehicles. For newvehicle manufacturer information, color, price and discount information are maintained inthe database. The facilities of the car are mentioned in extras. As the cars have multiplefacility the facilities information of the car are maintained in separate table. The price anddescription are maintained for used vehicles. Both client and sales person contactinformation like name and address are stored in the database. Each person is identifiedwith an id. The database maintains sale information of the vehicles. Each vehicle salesinformation like the client who bought the vehicle, price it was sold and commissioninformation is maintained. As the sale commission is shared among more than one salesperson the details of the salesperson who conceded the sales are maintained in thedatabase.2.Entity Relationship Diagram:3.Relational Data Modelperson(person_id, name, address)manufacturer(manu_id, manu_name, phone_num, industry_rank)manu_address(manu_id, type, address, foregin key(manu_id) referencesmanufacturer(manu_id))vehicle (vehicle_id, chassis_no)new_vehicle(vehicle_id, manu_id, colour, price, discount, engine_capacity, foreignkey vehicle_id references vehicle(vehicle_id))
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
A Model Description: Jo Bloggs Auto Traderslg...
|4
|815
|451
Advanced Management Consolelg...
|35
|7601
|31
Database Management System Assignment 2022lg...
|32
|6949
|24
ITECH 1006 : The Database Management System Reportlg...
|21
|3550
|123
Assignment - Foreign Constraints | MySQLlg...
|14
|1245
|258
ICT40115 - Certificate IV in Information Technologylg...