ITCO231 Database Exercises

Part 1

Step 1: Use the Internet to locate one web-based form that contains user interaction. The form must contain at least 8 areas for data entry such as text boxes, list boxes, radio buttons etc. The form must not be password protected as it must be accessible by your instructor.

You probably use web forms often. Here's just a few places where you can find web forms:

• Online credit card application form
• Create an online account at your favorite retailer
• Shop and check out on your favorite online retailer's website
• School application
• Sign up for a news letter

See an example below: see image.

Step 2: Take one screen shot and paste the form into a Word document.

Step 3: Using the web-based form as your initial table, create a crow's food entity relationship diagram (ERD) that includes all the items on the form in a single table. You may use Word, PowerPoint, or Visio to complete this diagram. Name the entity appropriately based on the Web page where you obtained the screenshot and list the attributes (form items).

• Note: At the end of step 3, the ERD will contain one entity containing all the items on the form.

Step 4: Create at least 2 entities related with initial form entity.

• Note: The two new entities will not contain any of the attributes from the original form entity. Use your imagination and prior World experiences to think of other potential entities that could be related to the form entity. Review the intellipath lessons on Database Conceptual Design and Logical Design of Databases (Entities, Attributes, and Relationships) to help with this section.
• If you need assistance, contact your instructor.

Step 5: Using your initial entity and the two new entities, follow normalization rules to 3NF. Create a final ERD in 3NF:

• The 3NF final design must have at least three entities.
• Each entity must have at least six attributes.
• Relationships must exist between at least three or more of the entities.

Step 6: Explain the steps and changes you made to your diagram to bring it to 3NF.

• Describe the process you took to complete each normal form when refining your database. Explain why your design meets or does not meet the criteria for that normal form.
• Be sure to address important normalization concepts such as: Repeating groups, single/multi-value attributes, Keys, Partial dependencies, transitive dependencies.

Part 2

Deliverable length: Word document containing screenshot of SQL Server Management Studio with AdventureWorks database attached.

Now that you have installed and configured SQL Server and SQL Server and SQL Server Management Studio in your Unit 1 DB, you must create the database that you'll use in future assignments.

1.Create a folder on your hard drive, off the root of C:\\ called "ITCO231"

2.Download the AdventureWorks database script (.sql) file. Save the file to the ITCO231 folder you created.

3.You must have SQL Server Management Studio installed to load the database. If you have not yet installed SQL Server Management Studio, go back to Unit 1 Discussion Board, Part 1 and complete the installation.

4.Open SQL Server Management Studio and log in.

5.Go to Windows Explorer and open your ITCO231 folder. Double-click on the AdventureWorksLT2012.sql file that you downloaded into the folder. The file should open in SQL Server Management Studio.

6.Click Execute to run the script file in SQL Server Management Studio.

7.IN SQL Server Management Studio, in the Object Explorer, right click on Databases and select Refresh. Your new AdventureWorksLT2012 database should now appear in the list.

8.Expand the Object Explorer window so that you can see the entire server name and expand Databases so it shows the AdventureWorksLT2012 database. It should be similar to the below diagram but with your version and system information.