Question

In: Computer Science

Suppose a relation looks like this: CUSTOMER(CustID, CustName, DateOfBirth, City, CityPopulation) Assume that City determines the...

Suppose a relation looks like this: CUSTOMER(CustID, CustName, DateOfBirth, City, CityPopulation) Assume that City determines the CityPopulation.

Write the logical model for this relation in which each relation is at least up to 3rd NF.

Expert Solution

dependencies are

CustID->CustName

CustID->DateOfBirth

CustID->City

CustID->CityPopulation

City->CityPoputation

candidate key is :CustID

above customer relation is in 1NF.

2NF->no partial dependencies present..means part of candidate key should not determine any other attribute..

here in custoer table we have only one attribute in candidate key..so there is no chance of partial dependencies ..

therefore above relation is in 2NF..

3NF: X->Y

2 conditions 1)x is superkey 2) y is prime attribute

either one of above 2 conditions satisfy then the relation is in 3NF

note:prime attributes: attribute which are present in candidate key

CustID->CustName -->CustID is super key ..therefore this dependency is in 3NF

CustID->DateOfBirth -->CustID is super key ..therefore this dependency is in 3NF

CustID->City -->CustID is super key ..therefore this dependency is in 3NF

CustID->CityPopulation -->CustID is super key ..therefore this dependency is in 3NF

City->CityPoputation --->City is not super key and City population is not prime attribute ...therefore this dependency violate 3NF condition.so split the table Customer

3NF TABLES ARE

R1(CustID, CustName, DateOfBirth, City)

DEPENDENCIES FOR R1

CustID->CustName

CustID->DateOfBirth

CustID->City

CustID->CityPopulation

R2(City, CityPopulation)

DEPENDENCIES FOR R2

City->CityPoputation

venereology answered 1 year ago

What is a Monocentric city? What determines land prices in a Monocentric city?

A neighboring city looks identical in every way (except each house in the neighboring city requires...

A neighboring city looks identical in every way (except each house in the neighboring city requires only half the electricity and only ¼ of the water is produced for use compared with the city in the above questions – which sacrifices 1 unit of water for 1 unit of electricity). Use comparative advantage to determine which city will supply water and which will supply electricity. Estimate the price range of electricity in terms of water.

Is a sprawling city (like Atlanta and Tampa) or a compact city (like New York and...

Is a sprawling city (like Atlanta and Tampa) or a compact city (like New York and Boston) better in terms of healthy lifestyle and environmental impacts? Explain why. (150-200 words)

A mass on a spring is subjected to an external force that looks like a triangular...

A mass on a spring is subjected to an external force that looks like a triangular wave: F(t) = 1+t from t=-1 to 0 F(t) = 1-t from t=0 to t=1 Periodicity = 2 The differential equation for the position of the mass (using Newton’s law) ends up being: x’’(t) + 2x’(t) + 101x(t) = F(t) 1. Find the generic homogeneous solution 2. Find the Fourier series of F(t) 3. Find the Fourier series of the particular solution (which is...

What it Looks Like to the User The program will loop, asking the user for a...

What it Looks Like to the User The program will loop, asking the user for a bet amount from 0 to 100 (assume dollars, you can use ints or longs). If the user types a 0 that means she wants to quit. Otherwise, accept the amount as their bet and simulate a slot machine pull. Your program will print out a line that looks like a slot machine result containing three strings. Some examples are: BAR 7 BAR, 7 7 cherries,...

What are the knowledge important for hotel business (Customer, supplier, administrator)(Small hotels like darwin city hotel)?...

What are the knowledge important for hotel business (Customer, supplier, administrator)(Small hotels like darwin city hotel)? How they use these knowledge? Develop a KMS framework for the business

It looks like a four-door SUV, drives like a four-door SUV but isn’t. What is it?...

It looks like a four-door SUV, drives like a four-door SUV but isn’t. What is it? This company uses 5% of the world’s sugar! They were the first large German Company to list on the New York Stock Exchange. You see them everywhere but no one knows what a TEU is. What does China have to do with the Ford Mustang? The largest auto exporter from USA is? (in terms of value)

Suppose we would like to determine if the typical amount spent per customer for dinner at...

Suppose we would like to determine if the typical amount spent per customer for dinner at a new restaurant in town is more than $20.00. A sample of 49 customers over a three-week period was randomly selected and the average amount spent was $22.60. Assume that the standard deviation is known to be $2.50. Using a 0.02 level of significance, would we conclude the typical amount spent per customer is more than $20.00?

THIS LOOKS LIKE A LONG PROBLEM BUT IT'S JUST A LOT OF WORDS- THE QUESTIONS ARE...

THIS LOOKS LIKE A LONG PROBLEM BUT IT'S JUST A LOT OF WORDS- THE QUESTIONS ARE JUST CALCULATIONS If capacity increased, French estimated that sales revenues would rise by at least $50,000 per month due to unmet demand and increased efficiency. The company’s margins on the additional revenues were expected to be 35% . French saw three viable options to increase capacity: 1. Purchase an additional CNC machine for cash, 2. Finance the purchase of an additional CNC machine, or...

1. Suppose we would like to determine if the typical amount spent per customer for dinner...

1. Suppose we would like to determine if the typical amount spent per customer for dinner at a new restaurant in town is more than $20.00. A sample of 49 customers over a three-week period was randomly selected and the average amount spent was $22.60. Assume that the standard deviation is known to be $2.50. •Using a 95% confidence level of significance, would we conclude the typical amount spent per customer is more than $20.00? •Discuss your interpretation of your findings. 2....