Here is the task require to develop a data-driven online client server system called “ParcelBuddy” aimed at logging and tracking parcel deliveries for a small delivery company and their drivers. You must build the system using PHP, MySQL and HTML/CSS using an Object Oriented approach to the code and data acquisition and Model-View-Controller design pattern . Noteworthy details : The core PHP architecture needs to follow an Object Oriented, Model-View-Controller (MVC) Design Pattern approach. For the system itself there should be two types of users. 1) a delivery manager who can manage parcel entries using a Create-Read-Update-Delete (CRUD) approach 2) a parcel delivery user (think similar to Evri). The system must allow users to login before they can do anything else. As a minimum for users, each record needs to include: a unique id, a unique username, a password, and a user type. All passwords must be appropriately encrypted in the database. A delivery point record will need a unique id, a recipient name and a location (full street address and latitude/longitude) as well as an assigned parcel delivery user. There will also be a need to store the status of the delivery and a photo of the final confirmed delivery area and coordinates. For testing and marking you must have two specific test accounts with these exact details: Manager Delivery user · User ID (auto generated in the DB) · Username: admin · Password: 123456 · User type: Manager · User ID (auto generated in the DB) · Username: lee · Password: 123456 · User type: Deliverer The website’s main home page must be named php and should start with a login page. Authenticated (logged in) Delivery users should be able to list all deliveries assigned to them and be able to search for a delivery record based on parameters like parcel recipient, postcode and address and parcel id and the search should be sophisticated enough to narrow down results including ordering of the results. Splitting the list into pages with suitable page navigation will get the highest marks. Delivery users will provide updates to each delivery once completed Authenticated (logged in) Manager users should be able to manage (CRUD) all parcel entries and assign a Delivery user to a particular deliver. Listings and Search results should be displayed using HTML with CSS (the use of Bootstrap or Materialize or other CSS frameworks is encouraged) The geolocation data (latitude/longitude) which involves maps (e.g. Google maps) so think about how you will include this information in a delivery point record and store dummy information for now. Your site must be designed and built to handle 1000’s of parcel records, 100s of delivery users, a few manager users and you need to demonstrate the system’s ability to handle this amount of data by creating large test data sets. You can generate test/mock data with a tool like mockaroo.com You must consider security and performance at every step and design the user experience for multiple platforms and abilities. For example, security should consider filtering malicious code from any text that users can enter, including SQL injection. Performance should minimise page weight including media associated with an item description (e.g. processing uploaded images to reduce their dimensions and file size).

Here is the task require to develop a data-driven online client server system called “ParcelBuddy” aimed at logging and tracking parcel deliveries for a small delivery company and their drivers. You must build the system using PHP, MySQL and HTML/CSS using an Object Oriented approach to the code and data acquisition and Model-View-Controller design pattern . Noteworthy details : The core PHP architecture needs to follow an Object Oriented, Model-View-Controller (MVC) Design Pattern approach. For the system itself there should be two types of users. 1) a delivery manager who can manage parcel entries using a Create-Read-Update-Delete (CRUD) approach 2) a parcel delivery user (think similar to Evri). The system must allow users to login before they can do anything else. As a minimum for users, each record needs to include: a unique id, a unique username, a password, and a user type. All passwords must be appropriately encrypted in the database. A delivery point record will need a unique id, a recipient name and a location (full street address and latitude/longitude) as well as an assigned parcel delivery user. There will also be a need to store the status of the delivery and a photo of the final confirmed delivery area and coordinates. For testing and marking you must have two specific test accounts with these exact details: Manager Delivery user · User ID (auto generated in the DB) · Username: admin · Password: 123456 · User type: Manager · User ID (auto generated in the DB) · Username: lee · Password: 123456 · User type: Deliverer The website’s main home page must be named php and should start with a login page. Authenticated (logged in) Delivery users should be able to list all deliveries assigned to them and be able to search for a delivery record based on parameters like parcel recipient, postcode and address and parcel id and the search should be sophisticated enough to narrow down results including ordering of the results. Splitting the list into pages with suitable page navigation will get the highest marks. Delivery users will provide updates to each delivery once completed Authenticated (logged in) Manager users should be able to manage (CRUD) all parcel entries and assign a Delivery user to a particular deliver. Listings and Search results should be displayed using HTML with CSS (the use of Bootstrap or Materialize or other CSS frameworks is encouraged) The geolocation data (latitude/longitude) which involves maps (e.g. Google maps) so think about how you will include this information in a delivery point record and store dummy information for now. Your site must be designed and built to handle 1000’s of parcel records, 100s of delivery users, a few manager users and you need to demonstrate the system’s ability to handle this amount of data by creating large test data sets. You can generate test/mock data with a tool like mockaroo.com You must consider security and performance at every step and design the user experience for multiple platforms and abilities. For example, security should consider filtering malicious code from any text that users can enter, including SQL injection. Performance should minimise page weight including media associated with an item description (e.g. processing uploaded images to reduce their dimensions and file size).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Here is the task require to develop a data-driven online client server system called “ParcelBuddy” aimed at logging and tracking parcel deliveries for a small delivery company and their drivers.

You must build the system using PHP, MySQL and HTML/CSS using an Object Oriented approach to the code and data acquisition and Model-View-Controller design pattern .

Noteworthy details :

The core PHP architecture needs to follow an Object Oriented, Model-View-Controller (MVC) Design Pattern approach.

For the system itself there should be two types of users. 1) a delivery manager who can manage parcel entries using a Create-Read-Update-Delete (CRUD) approach 2) a parcel delivery user (think similar to Evri).

The system must allow users to login before they can do anything else. As a minimum for users, each record needs to include: a unique id, a unique username, a password, and a user type. All passwords must be appropriately encrypted in the database.

A delivery point record will need a unique id, a recipient name and a location (full street address and latitude/longitude) as well as an assigned parcel delivery user. There will also be a need to store the status of the delivery and a photo of the final confirmed delivery area and coordinates.

For testing and marking you must have two specific test accounts with these exact details:

Manager

Delivery user

· User ID (auto generated in the DB)

· Username: admin

· Password: 123456

· User type: Manager

· User ID (auto generated in the DB)

· Username: lee

· Password: 123456

· User type: Deliverer

The website’s main home page must be named php and should start with a login page.

Authenticated (logged in) Delivery users should be able to list all deliveries assigned to them and be able to search for a delivery record based on parameters like parcel recipient, postcode and address and parcel id and the search should be sophisticated enough to narrow down results including ordering of the results. Splitting the list into pages with suitable page navigation will get the highest marks.

Delivery users will provide updates to each delivery once completed

Authenticated (logged in) Manager users should be able to manage (CRUD) all parcel entries and assign a Delivery user to a particular deliver.

Listings and Search results should be displayed using HTML with CSS (the use of Bootstrap or Materialize or other CSS frameworks is encouraged)

The geolocation data (latitude/longitude) which involves maps (e.g. Google maps) so think about how you will include this information in a delivery point record and store dummy information for now.

Your site must be designed and built to handle 1000’s of parcel records, 100s of delivery users, a few manager users and you need to demonstrate the system’s ability to handle this amount of data by creating large test data sets. You can generate test/mock data with a tool like mockaroo.com

You must consider security and performance at every step and design the user experience for multiple platforms and abilities. For example, security should consider filtering malicious code from any text that users can enter, including SQL injection. Performance should minimise page weight including media associated with an item description (e.g. processing uploaded images to reduce their dimensions and file size).

AI-Generated Solution

AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.

Unlock instant AI solutions

Tap the button
to generate a solution

Click the button to generate
a solution

SEE SOLUTION