Database for Motors company(Academic Project)

Title DJ Motors Scope Database system to store, edit and display customer details, employees details, vehicle details, supplier details, Bookings Handles complaints Performs calculations on the existing database on a weekly basis to identify the cars due for service and MOT Issue service,MOT reminders to car owners via [login to view URL], letters (automatically printed) Issue special offers, deals calculate total hours worked every fortnight calculate empoyee,s salary every fortnight calculate total paied out every month, year calculate total paid in every month, year customer's details -first name -last name -address -post code -tel. contact [login to view URL] -customer ID Vehicle details -registration number -make -model -year -engine size -disell/petrol -transmition -date last serviced -MOT last issued bookings -customer ID -employee ID -date and time of booking -work to be done Staff -first name -last name -NI number -address -post code -tel. contact [login to view URL] -employee ID -time in -time out Complaint -customer ID -complaint what do you produce? e.g gearbox repair, half/full survice, MOT etc.. whats your product line? e.g range of different types of service, i.e half/full etc... what survices do you offer? Storage, delivery, ect... what can't you avoid? complaint as it would affect our reputation, payments for parts to other companies etc... who are your customers? e.g vehicle owners car sales garages etc... what do your customers want from you? e.g good sevice, reciet, possibly complain and want refund what kind of things differentiate you from your competitors? (The complete description is attached) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform SQL Server-C#