Question: 1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of

1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answer and show how to convert to the higher forms.
2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
Marina (MarinaNum, Name, (SlipNum, Length, RentalFee, BoatName) )
3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form:
MarinaSlip (SlipID, MarinaNum, SlipNum, Length, RentalFee, BoatName, BoatType, OwnerNum, LastName, FirstName)

Step by Step Solution

★★★★★

3.47 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 1NF but 2NF Marina MarinaNum Name SlipNum Length RentalFee BoatName Convert to ... 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

Document Format (1 attachment)

671-CS-DB (1001).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an...

The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. No computer work is required. 1. Using the types of entities found in the...

The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required. 1. Using the types of entities found in the Solmaris...

Complete the Bits Corporation exercises 1-6 containing red Advisorricum A of y. nasional and that 1. Comment and **. The following spendencies b pendencies that is a ble to an equivalent ie to an...

You need to use SQL Server at MyEducator with Credentials set as your Student Account through the Advanced Query editor to do this assignment. Be sure to format and name columns as appropriate. Save...

1.A printout of each query (4-21), both your input and the results, where needed. Staple the above printouts in order and handwrite #4-21 on each (if you click print on the browser and change the...

Use MySQL and Figures 1-8 through 1-12 in Chapter 1 to complete the 1. Use the appropriate CREATE TABLE commands Alexamara Marina Group to create the tables in the 8aA table usngG re 3-2 2. Add the...

Use MySQL and Figures 1-8 through 1-12 in Chapter 1 to complete the 1. Use the appropriate CREATE TABLE commands to create the Alexamara Marina Group tables in the Alexae Marina Group database. The...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

1.- MyLab MIS Supply chain management is less about managing the physical movement of goods and more about managing information. Discuss the implications of this statement. 2.-MyLab MIS If a company...

Egret Corporation, a calendar year C Corp, was formed June 1, 2011, and opened for business on September 1, 2011. After its formation, but prior to opening for business, Egret incurred the following...

SQL applies predicates in the _______ clause after groups havebeen formed, so aggregate functions may be used. a) Group by b) With c) Where d) Having

Q 4 ) ( 1 5 pts ) Consider the following graph Where S is the start state and G is the goal state. Arcs show the edge costs. Assume that A * * algorithm is applied using two different heuristic...

Which one is not a metric to measure a companys Digital. Advertising Campaign ? a. CPM b. CPA c. CPV d. CPM .

What is another term for a subquery? a. Outer query b. Inner query c. Union query d. Aggregate query

The _____ operator allows you to select the records that match each condition separately, and then combine them into a single view. a. COMBINE b. MATCH c. UNION d. MERGE

Which symbol is a wildcard representing any number of characters? a. * b. c. & d. #

A company is evaluating an investment in a salt mine. The initial investment would be $790,000 and the estimated annual cash flows over 5 years would be $230,000. The government requires that it...

SanData Inc. recently paid its annual dividend of $ 3 . 6 2 . Dividends have consistently grown at a rate of 5 % . You estimate that the stock has a required return of 1 5 % . What is the intrinsic...

iN '06 ABC Company is considering the purchase of an asset which would cost $100,000. The '06 information includes the impact of this asset. All changes from '05 to '06 can be attributed to the...