Web Database Project - Phase 1 Think of a useful application for a database. If possible, try' to come up withsomething that would be useful for you or a friend. Some ideas that come to mind are databases to

Web Database Project - Phase 1

Think of a useful application for a database. If possible, try' to come up withsomething that would be useful for you or a friend. Some ideas that come to mind are databases to organize your contact list, dvd collection, book collection (for a personal library'), multi-media collection...etc.

Design a relational database to meet your needs for your application. Create your MySQL database using your web hosting account. I suggest using the PHPMyAdmin tool to create your tables. You can also use the PHPMy Admin tool to populate your tables with some initial data. Put some thought into how you will organize your database before you start creating it in MySQL. Pay attention to things like primary keys and data types. I would suggest keeping the scope of your database somewhat reasonable. Keep in mind that what you create could be used in a portfolio (examples of projects completed as part of your course requirements) to show during a job interview. Your database must have a minimum of two tables.

In the following assignments you will have to create a home page that will link to your database pages that will pemit access to the database. You may want to create a home page now that is related to the database that you create for this assignment. Keep in mind that from the home page you will want to link to one or more pages to access the database. You will have to be able to link back to the home page on any pages you create.

When you have created your MySQL database, grab some screen shots of your tables in the PHPMyAdmin tool and paste them into a Word file (or similar format). Turn in this file with your screenshots into the appropriate submission box.