I designed data base for create an application. The application helps employees who work at car deal shop to manage information about cars.
1.Project Overview. The project is to develop an application that keeps tracking records of cars in car selling shop. The inventory record will be updated when the company purchases and sells cars. The application will also track car records of repair assuming that the dealer runs repair business as well. The purpose of the project is learning interaction between programming and database which is very important in the real world. The main programming language of the project would be C# which provides convenience to develop multiple web pagess. The application will consist of approximately multiple web pages. The IDE would be Visual Studio 2015 that enables to connect to the database (ADO .NET).
2.Functional Requirements.
● System Management: Query any data in the database and navigate to each subordinate system menus.
● Vehicle Management: Add, delete, search and update vehicle record.
● Option Management: Add, delete, search and update option record.
● Customer Management: Add, delete, search and update customer information.
● Employee Management: Add, delete, search and update employee information.
● Invoice Management: The key value of tracking sale, inventory, customer and employee’s performance.
● Repair Service Management: Repair history of each vehicle.
--
3. Data Designe
--
4. Data Image
- Main
-- - Invoice
-- - Employee
