Musicology Warehouse $($MW$)$ is a hub for the diverse world of music, an art form that

has existed since immemorial. With various genres such as Gospel, Hip Hop, and

Reggae, the music industry thrives with many interests and intentions.

True to its name, "warehouse," the establishment serves as a distribution centre for

retail music platforms like Spotify, Deezer, etc., ensuring the supply of different music

genres across the globe.

Besides online platforms, MW has physical stores with branches strategically located

throughout South Africa where customers can conveniently procure their preferred

music.

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

The system must use frontend validation on key data fields.

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

HINTS:

$$ Use a Password log$-$in routine, Menus, Buttons, etc., in your GUI to simplify

user interaction with the system.

$$ The system must have formal login and logout routines.

$$ The Username for the system admin who has access to all functionalities must

be $$Myuser$,$ and the password must be $$SA$1$@$123.$

$$ You must create separate roles for each type of user, i$.$e$.$ advisor, nurse, doctor,

etc.

$$ At each stage of application processing, appropriate screen layouts, prompts,

and messages must be used to assist the user. For example, a student may

receive a message that they have been accepted$/$rejected$.$

$$ For consistency, use CSS stylesheets to define common interface features

such as colour, fonts, and menus

Paste the PHP and HTML codes that create or register a new Admin $/$ User$.$

$(4$ marks$)$

$1\mathrm{.}1$ Paste the JavaScript validation code for the username and password in the user login form.

$(6$ marks$)$

$$

$1\mathrm{.}3$ Paste a screenshot of the user login screen. $(2$ marks$)$

$1\mathrm{.}4$ Paste the CSS code showing definition of any $5$ components, e$.$g$.$ headings, fonts, etc., used in your application. Do not give definitions of more than $5$ components. $(5$ marks$)$

$1\mathrm{.}5$ Paste the PHP statement$($s$)$ you used to connect the application to your database. $(3$ marks$)$

$$

$1\mathrm{.}6$ Paste the MySQL statement that you used to create the main Musicology$$s Warehouse $($MW$)$ database. $(2$ marks$)$

$1\mathrm{.}7$ Paste MySQL statement$($s$)$ to create the albums table within the MW database. This must clearly show all the fields relating to an user. $(2$ marks$)$

$1\mathrm{.}8$ Paste the MySQL statement$($s$)$ you used to create the Admin and CD$.$ This is the table that stores details about Admin and CD details

$(3$ marks$)$

$1\mathrm{.}7$ Paste a screenshot from your browser to show a user logging into the system. Use YOUR ACTUAL details, such as the name and password of a admin$/$ user$/$ customer. $(2$ marks$)$

$1\mathrm{.}8$ Paste a screenshot to show the user referred to in question $1\mathrm{.}7$ SUCCESSFULLY logged into the system. The screenshot must show the name of the logged in user. $(2$ marks$)$

$1\mathrm{.}9$ Paste the PHP code for the logout$/$ exit method, function, or program.

$(5$ marks$)$

$$

$2\mathrm{.}0$ Paste your screenshot of the logout window. $(3$ marks$)$

$2\mathrm{.}1$ Paste the PHP code that adds a album$/$CD to the database $($applicants table$).(5$ marks$)$

$2\mathrm{.}2$ Paste a screenshot from the browser showing ALL functions on the system. $(2$ marks$)$

$$

$2\mathrm{.}3$ Increase the stock level quantity by the admin user shown in the screenshot for question $2\mathrm{.}2.$ Show the modified application in a screenshot.