The project aims to develop a website and application that enables employees to enter and manage the company's car data in an organized and efficient manner instead of keeping them in Excel files.
1.2 Problem
The company currently suffers from using Excel files to store car data, leading to difficulties in accessing, analyzing, and organizing the data effectively.
1.3 Benefits
Organizing data, easy access, improved data analysis process, enhanced user experience, and increased efficiency in car data management.
2. Project Scope
2.1 Core Features
Add New Car: Enter car data.
Edit Car Data: Modify the entered data.
Deactivate Car: Disable specific car data instead of deleting it.
View Cars: Display a list of all cars with search and filter options.
Export Data: Export data to Excel or PDF files.
Reports: Create custom reports based on the entered data.
Notifications: Alerts regarding car data updates.
2.2 Target Users
Drivers.
Supervisors.
Data Entry Clerks.
Managers.
Roles and Permissions in the System
1. Drivers
1.1 Description
Drivers are the users who operate the cars and need access to the data of the car they drive.
1.2 Permissions
View Car Data: They can view the data related to the car they are driving only.
Receive Notifications: They receive notifications about data updates related to their car, such as maintenance alerts.
Update Car Status: They can update the status of the car, such as usage status or report issues.
1.3 Limitations
They cannot add or edit car data.
They cannot view or edit data of other cars.
2. Supervisors
2.1 Description
Supervisors are responsible for managing the cars, guiding the drivers, and ensuring compliance with rules and procedures.
2.2 Permissions
View All Car Data: They can view all car data in the system.
Edit Car Data: They can edit the data entered for any car.
Deactivate Car: They can disable the data of a specific car so that it does not appear in the active lists.
Create Reports: They can create custom reports based on the entered data.
Export Data: They can export data to Excel or PDF files.
2.3 Limitations
They cannot add new cars to the system.
They cannot modify the permissions of other users.
3. Data Entry Clerks
3.1 Description
Data Entry Clerks are responsible for entering car data into the system.
3.2 Permissions
Add New Car: They can enter data for a new car.
Edit Car Data: They can edit the data entered for any car.
View All Car Data: They can view all car data in the system.
3.3 Limitations
They cannot deactivate a car.
They cannot export data or create reports.
4. Managers
4.1 Description
Managers are responsible for overseeing the overall car management system and ensuring smooth operations.
4.2 Permissions
View All Car Data: They can view all car data in the system.
Edit Car Data: They can edit the data entered for any car.
Deactivate Car: They can disable the data of a specific car so that it does not appear in the active lists.
Add New Car: They can enter data for a new car.
Create Reports: They can create custom reports based on the entered data.
Export Data: They can export data to Excel or PDF files.
Manage Users: They can add new users, modify their permissions, or delete them.
4.3 Limitations
They have no limitations on permissions within the system.
3. Functional Requirements
3.1 Add New Car
Enter plate number.
Enter chassis number.
Enter the actual user name.
Enter car type.
Enter car color.
Enter manufacturer.
Enter year of manufacture.
Enter serial number.
Enter plate registration type.
3.2 Edit Car Data
Ability to modify any of the entered car data.
3.3 Deactivate Car
Ability to disable specific car data so that it does not appear in active lists.
3.4 View Cars
Display a list of all cars.
Provide search and filter options based on various criteria (e.g., plate number, car type, car color, manufacturer, year of manufacture).
3.5 Export Data
Export data to Excel or PDF files.
3.6 Create Reports
Provide the ability to create custom reports based on the entered data.
Display statistics about the number of cars, etc.
3.7 Notifications
Send alerts regarding car data updates.
Send notifications when car data is added or modified.
4. Non-Functional Requirements
4.1 Security
Secure sensitive data using advanced security protocols (e.g., SSL encryption).
Access control: Define user permissions based on their roles.
4.2 Performance
Ensure fast application response even when large amounts of data are entered.
Ability to efficiently handle thousands of records.
4.3 Scalability
Design the system to easily add new features in the future.
Handle increased data volume and number of users without affecting performance.
4.4 Usability
Design an intuitive and easy-to-use user interface.
Provide a user manual and tutorials for the user team.
5. Data Model
5.1 Tables and Relationships
Cars Table:
Car ID (serial number).
Plate number.
Chassis number.
Actual user name.
Car type.
Car color.
Manufacturer.
Year of manufacture.
Serial number.
Plate registration type.
Car status (active/inactive).
5.2 Relationships
One-to-one relationship between car and user.
6. Interfaces
6.1 Interface Descriptions
Add New Car Interface: Includes fields to enter all car data.
Edit Car Data Interface: Displays current data and allows editing.
View Cars Interface: Displays a list of cars with search and filter options.
Export Data Interface: Allows users to export data.
Reports Interface: Allows creating and viewing custom reports.
Notifications Interface: Displays notifications and alerts about cars.
6.2 Main Screen Mockups
[Mockup for Add New Car Interface]:
[Mockup for View Cars Interface]:
[Mockup for Reports Interface]:
[Mockup for Notifications Interface]:
7. Roadmap
7.1 Project Development Timeline
8. Additional Notes
Ensure regular data updates.
Provide continuous technical support for users.
Periodically evaluate performance and update the system as needed.
Fields Table
Table 7
Column 1
Column 2
Column 3
Column 4
Column 1
Column 2
Column 3
Column 4
1
Field Name
Mandatory
Specifications
Source
2
Plate Number
Yes
Text, unique, specified length
Employee
3
Chassis Number
Yes
Text, unique, specified length
Employee
4
Actual User Name
Yes
Text, max 100 characters
Employee
5
Car Type
Yes
Text, max 50 characters
Employee
6
Car Color
Yes
Text, max 20 characters
Employee
7
Manufacturer
Yes
Text, max 50 characters
Employee
8
Year of Manufacture
Yes
Year (4 digits)
Employee
9
Serial Number
Yes
Text, unique, specified length
Employee
10
Plate Registration Type
Yes
Text, max 20 characters
Employee
11
Car Status
Yes
Text, fixed values (active/inactive)
System
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (