please help using netbean and mysql workbench This assignment you will be making

Question

please help using netbean and mysql workbench

This assignment you will be making a form that will do one of three things in a database

-          It will add a record

-          It will update a record

-          It will search for a record

Your database will contain a table for keeping a record of all your friends and family and should contain:

First name

Last name

Phone number

Address

City

State

Zip

Birthdate

Username

Password

The sex of the person

And the relationship

You should also keep a primary key for the user

You will then have two pages a friends and family form page and a results page

The form will ask the user to enter the information and then choose to either

Create a new record

Update and existing record

Search for a record

The results page will display the information that they are requesting with either adding a record, updating it or displaying the results of a record.

Explanation / Answer

Put reusable information into separate tables. Any information that you’ll be entering multiple times is “reusable” information. Your goal in database design is to avoid entering the same data twice. Instead, find a way to reuse the data that’s already been entered. Not only does this save work, but it avoids data entry errors or discrepancies that will make it difficult to maintain a database.

An example is a product description. You might be tempted to put that right into the orders table (Figure 3-3), but the product descriptions don’t change, and you’ll find yourself entering the same descriptions again and again for each new order. This is a sure sign that this information belongs in a separate

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.