Question: Problem 1 (30 points): Given Relation X = (A,B,C,D,E,F,G,H,I,J) and given these functional dependencies: {A,B){C} {B} {E,F} {A,D} {G,H} {G}{1} {H}{J} a. Determine the

Problem 1 (30 points): Given Relation X = (A,B,C,D,E,F,G,H,I,J) and given these functional dependencies: {A,B){C} {B} {E,F} {A,D} {G,H} {G}{1} {H}{J} a. Determine the Primary Key of R. b. Is {ADG) a key? Explain your answer. c. Is {ABDG) a key? Explain your answer. d. Can you tell if this table is in first normal form? e. When asked to put the table in 2NF, a student produce the following two tables. Explain why the student's answer is not in 2NF and then place the table in 2NF. The primary key is underlined. {A, B, C, E, F} {D, G, H, I, J} Place R into 3rd Normal Form including the key of each table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

In schema normalisation, is Boyce-Codd Normal Form (BCNF) always to be preferred over 3rd Normal Form (4NF)? Explain your answer. [5 marks] 8 (TURN OVER) CST.2004.7.4 8 Economics, Law and Ethics (a)...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Southern Stitches is a local casual clothing shop that makes a variety of t-shirt styles. Below is some actual vs. budget information for Southern's t-shirts for the month of May. Assume no...

According to the News Wire "Competitive Markets," how many catfish farms exited the industry in 2002-2008? What did they then do? Was this socially desirable?

The astronomical unit equals the mean distance between the earth and the sun. This distance is 150,000,000 km, which is precise to three significant figures. Express this in scientific notation to...

Describe Descartess views about reflex activity.

A spokesperson for Yahoo! doesnt think that Netflixs unlimited vacationtime policy would work at her company: Were a grown up company with over 12,000 employees, she says, and you have to have some...

1) Compute inventory turnover for Boeing and McDonald's 2) Using the ratios you computed in question 1, Boeing and McDonald's are very different companies in very different industries. Do their...

Chris Lane, the head professional at Royal Oak Country Club, must develop a schedule of matches for the couples golf league that begins its season at 4:00 P.M. tomorrow. Eighteen couples signed up...

Using the program BurnFraction.m, and assuming that ?? = 5, the beginning of heat addition is -10?, and the duration of heat addition is 40?, (a) plot the Wiebe heat release fraction curve for the...

Burdeno Appliances has two divisions, Sales and Financing. Sales is responsible for selling Burdeno's Inventory and maintaining Inventory for future sale. Financing Division takes loan applications,...

Golden Food Products produces special-formula pet food. The company carries no inventories. The master budget calls for the company to manufacture and sell 120,000 cases at a budgeted price of $60...

Please answer as per question otherwise it would be reported. Identify the elements that the Crown must prove for each of the offences that the accused was charged with on January 12, Y0. On January...

Judging types (J) tend to intermix work and play. Group of answer choices True False

Patrick Corporation acquired 100 percent of O'Brien Company's outstanding common stock on January 1 for $617,000 in cash. O'Brien reported net assets with a carrying amount of $351,000 at that time....

Members of the board of directors of Adobe Security have received the following operating income data for the year just ended: (Click the icon to view the operating Income data.) Members of the board...

Some people argue that the internal control requirements of the Sarbanes-Oxley Act (SOX) put U.S. companies at a competitive disadvantage to companies outside the United States. Discuss the...

What is graph database? What are nodes, properties and edges?

What does it mean to transform data? Give an example other than the ones used in this book.

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and...

The Miltmore Corporation performs consulting services for companies that think they have image problems. Recently, the Bluedot Beer Company approached Miltmore. Bluedot executives were concerned that...

A Vermont company is monitoring a process that fills maple syrup bottles. When the process is filling correctly, the median average fill in an 8-ounce bottle of syrup is 8.03 ounces. The last 15...

The manager of credit card operations for a small regional bank has determined that last years median credit card balance was $1,989.32. A sample of 18 customer balances this year revealed the...