Musicology Warehouse $($MW$)$ is seeking a solution from you, a web developer, to

address two key requirements. The first requirement is a way for admin staff to handle

stock levels. Each branch has a driver who delivers items to customers, a branch has

stock items or different music genres. The admin staff will need to track how many

physical copies of CDs are available. An Album$\_$type in MW must be one of the

following: non$-$promo, promotional, on$-$discount. The album$\_$category is the genre the

album belongs to$.$ The admin must be able to add albums and track the number of

CDs available.

The second requirement is the development of the CSTCS$,$ or Customer Search To

Checkout System. This system aims to provide customers with a seamless

experience, allowing them to search for albums, add selected items to their cart, and

have the flexibility to view or update the cart as needed.

Required:

$1.$ Develop an online STOCK INVENTORY SYSTEM and CSTCS using PHP$,$ HTML$,$

CSS$,$ JavaScript, jQuery, and MySQL to provide an interface for Admin staff in

each branch

$2.$ The system must use frontend validation on key data fields.

$3.$ Use a MySQL database to store data in this application