In this assignment, you shall create tables that store data about audio albums - CDs, cassettes, LPs, DVDs, etc. Create 1 or 2 MySQL table using any of the online medias.

Requirements

-Design your database. Keep it simple One or two tables - albums and artists.

-You shall create tables in your database as needed.

-Create a login section for users to login ***extra credit if you can make this login functional such as some password in database *******

-You shall write the following HTML and PHP documents:

-a createTables.php script that creates the tables

-a form for the user to enter data for a new album

-a PHP script that handles the form

-a form for the user to enter data for a new artist

-a PHP script that handles the form

-a PHP script that handles the form

-a form that allows the user to search the database or show contents

Keep the database design simple - not too many tables. You may design a create and retrieve operations on a MySQL database using PHP functions. Please provide an interface to the user. This is a full three-tier small web app.

Home Work FAQS

- Do you care what type of artist/album information is in the tables? Any artist and album material is ok

- What do you mean by "use any of the above medias?" Online Media

- If PHP creates the tables, are they recreated every time? All tables should be stored away in a database; You can also write a query to search and retrieve from the database.

- What is the login supposed to do? After the user is logged in user can now view their material also you can redirect the user to a second page to view materials.