Online Database

As a freelance developer, your job scope would involve building the following: 1. Web-Based Application: Develop a web-based application that will serve as the foundation for later app development. The application will have a user-friendly interface and will allow users to manage package tracking information. 2. Database Design: Design a database to store package tracking information. The database should include fields such as customer name, address, account number, item description, weight, tracking number, supplier, warehouse number, email, shipment number, and package status. 3. Email Notifications: Implement a feature that sends mass emails to individuals when new items are entered into the database via an Excel import. The emails should provide relevant package information. 4. Excel Import: Develop a functionality that allows batch imports of package information through Excel sheets. This will enable users to import multiple package details at once, saving time and effort. [login to view URL] Login: Create a secure login system that allows customers to access their package information using their account number and a unique password. Once logged in, customers should be able to view the status of any package associated with their account. 6. Administrator Backend: Build an administrator backend that enables authorized personnel to make changes and manage the system. The backend should have appropriate security measures in place and allow administrators to modify package details, user accounts, and system settings. 7. Batch Invoice Import: Implement a feature that enables batch imports of invoice totals to each package via an Excel sheet. This will allow users to associate invoice information with the respective packages efficiently. 8. Website Integration: Integrate the login functionality with the current website. Users should be able to access the package tracking system seamlessly from the website without the need for separate credentials. Throughout the development process, you should prioritize data security, user experience, and scalability. Regular communication with the client is essential to understand their specific requirements, provide progress updates, and incorporate feedback into the development process.