Chat with us, powered by LiveChat Web Database Project – Phase 1 Think of a useful application for a database. If possible, try to come up with something that would be useful for you or a friend. Some ideas that come - Wridemy Bestessaypapers

Web Database Project – Phase 1 Think of a useful application for a database. If possible, try to come up with something that would be useful for you or a friend. Some ideas that come

 

Web Database Project – Phase 1

Think of a useful application for a database. If possible, try to come up with something 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 PHPMyAdmin 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.

In the next project phase you will create a Web interface using PHP that will interface with your database.

Web Database Project: Phase 2

Create web pages for your database using PHP. You should have one page that will return all the information from the database. You should create additional pages that will allow you to do various queries of your database. You should be able to retrieve and insert data; also include functionality to delete data from your database. I will be looking for these features. Feel free to handle those functions however you feel is best for your project.

Create an html form that will allow you to enter in new information for the database. The information should be handled by a PHP script that will take the data and input it into the database.

The interface doesn’t have to look real pretty at this point. That will be done in the next phase. If you want to go ahead and make things look nice, feel free to do so.

If you have not yet created a home page, create a separate home page that contains links to each of the web pages you create to access your database.  Your database (must have a minimum of two tables) is not to be displayed on the home page; be creative on this page.   On each of the database pages create a button (link) to go back to the home page. Your project must have more than one page; your home page should have links to other pages to perform operations on the database.  Some appropriate picture or image should be on the home page that relates to you project.  Make your project look as professional as possible.  You may want to show it during a interview.

Create a text file in which to store hyperlinks to your home page and PHP scripts.  Turn in this file to the appropriate submission box.

Web Database Project: Phase 3

Now is the time to make your project look good and as professional as possible.

By now you should have created your MySQL database and PHP scripts that can be used to query, insert, and delete data.  The objective of Phase 3 is to make it look nice. For example, you can use HTML in your PHP scripts to put the queried data into a table.  You might also choose to create a style sheet to control colors, fonts, etc.

You must have a home page which links to other pages you have created to manipulate your database.  Be sure that all pages have a button to link back to the home page and possibly buttons to link to other pages as necessary.  If you only create one page and display everything on that page you will have not met the minimum requirement for this class.  I will be looking to see if you put some real work into this final project.

When you have finished with your project, create a text file in which to turn in a hyperlink to your home page and if you wish hyperlinks to your PHP scripts.  Include your name in this file and any other comments you choose to include about your project.  Upload the file to the appropriate submission box.

Use the file naming convention shown in the drop box.

    Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

    Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

    Do you need an answer to this or any other questions?