Question: Consider the following table with the structure tblFriends(lastName, firstName, address, birthday, phoneNumbers, emailAddresses). If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF.

Consider the following table with the structure tblFriends(lastName, firstName, address, birthday, phoneNumbers, emailAddresses). If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF.

lastName firstName address birthday phoneNumbers Gordon Alicia 34 Second St. 3/16 Washington

lastName firstName address birthday phoneNumbers Gordon Alicia 34 Second St. 3/16 Washington Edward Davis Olivia 12 Main St. 12/12 55 Birch Ave. 10/3 2224343 349-0012 222-7121 222-9012 333-8788 834-0112 email Addresses agordon@mail.com ewash@mail.com coolguy@earth.com olivia@abc.com

Step by Step Solution

★★★★★

3.56 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer The table as given satisfies 1NF To satisfy 2NF we ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Logic & Design Comprehensive Questions!

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...

Consider the following table of constraint coefficients for a linear programming problem: Show how this table can be converted into the dual angular structure for multitime period linear programming...

Consider the following table of constraint coefficients for a linear programming problem: (a) Show how this table can be converted into the block angular structure for multidivisional linear...

Please work on the laptop please , i want to know how to work.. SmartProjects Company is planning to design a data model to hold information relating to their projects, employees working on company...

What is the purpose of the AS clause in SQL? It defines a search condition It assigns aliases to tables, columns, or calculations It is used in INNER JOIN to join two tables Neither of the other...

1. For any firm in any market structure, a factor's marginal revenue product is a. b. the average product of the factor muitiplied by the price of the output. the change in revenue caused by the sale...

CS270 Introduction to Computer Architecture II Homework 3 Instructions: Copy the questions into a word-processing document such as Microsoft Word. Then add your answers and save the completed...

\fCHAPTER 14 Server Farms: M/M/k and M/M/k/k In today's high-volume world, almost no websites, compute centers, or call centers consist of just a single server. Instead a \"server farm\" is used. The...

Consider the following table for a firm. The first column shows the number of units of a variable factor of production employed by the firm. Total Number of Units of the Factor Total Number of Units...

Saved Consider the following table. Students SID SFirstName SLastName SState 1 John Lee OH 2 Marry McDonlad TX 3 Steven Johnson TX What is the result of the following query? SELECT SID, FROM Students...

Hemlock Farms is a community located in the Pocono Mountains area of eastern Pennsylvania. The file Hemlock Farms contains information on homes that were recently for sale. The variables included...

Write a final marketing plan. In addition to your previous papers, include the following: your promotional strategy for your product or service, including how you may use the following: advertising,...

When seeking financial banking from a venture capitalist a small business

5. The mechanics of the circular flow model. Summary

A public static method named computeSum() is located in ClassA. To call the method from within ClassB, use the statement _____________. a. ClassA.computeSum(); b. ClassB(computeSum()); c....

Which of the following method declarations is correct for a static method named displayFacts() if the method receives an int argument? a. Public static int displayFacts() b. Public void...

The method with the declaration public static int aMethod(double d) is a method type of _____________. a. static b. int c. double d. You cannot determine the method type.

A proposed nuclear power plant will cost $2.9 billion to build and then will produce cash flows of $370 million a year for 15 years. After that period (in year 15), it must be decommissioned at a...

Part 2 Time Value of Money Calculations In your spreadsheet, calculate the answers to the following questions: 3. The required investment now if you want to collect 50,000 after ten years and can...

Beckman Enterprises compr un activo depreciable el 1 de octubre del ao 1 a un costo de $108 000. Se espera que el activo tenga un valor de rescate de $15,200 al final de su vida til de cinco aos. Si...