This website uses cookies to ensure you have the best experience. Learn more

Kroenke Ch2 Solutions Essay

1381 words - 6 pages

Chapter 3 and 4 and Relational Algebra

Chapter 3:

1. Consider the relation (20 points):
PERSON_2 (Name, Sibling, Shoe_Size, Hobby)
Assume that the following functional dependencies exist:
Name  Sibling
Name  Shoe_Size
Name  Hobby

a. Describe deletion, modification, and insertion anomalies for this relation.
Consider the following relation:
Name Sibling Shoe_Size Hobby
Jones Fred E Model boats
Jones Fred E Scuba Diving
Jones Sally E Model boats
Jones Sally E Scuba Diving
Jones Frank E Model boats
Jones Frank E Scuba Diving
Greene Nikki B Embroidery
Chau Jonathan C Scuba diving
Chau Eileen C Scuba diving

Deletion anomaly:
If a Name drops a Hobby, one line ...view middle of the document...

2. Consider the relation (50 points):
STUDENT (Number, Name, Dorm, RoomType, DormCost, Sibling, Nickname)
Assume that students pay different dorm costs, depending on the type of room they have. Assume that students can have multiple nicknames.
a. State any multivalued dependencies.
We will assume that Number  Name where name is not unique (i.e., there may be more than one “John Smith”, each with a different student number). Then the multivalued dependencies are:
Number  Sibling
Number  Nickname
Note: We can not assume that Name  Nickname because Name is not unique. For example, one John Smith may have the nickname “Johnny” while another John Smith has the nickname “Joe”. If Name  Nickname then John Smith  (“Johnny”, “Joe”) which means that both nicknames apply to both John Smiths. But this is not the case – each John Smith has only one nickname, and they are not the same.
b. State the functional dependencies.
We will assume that Number  Name where name is not unique (i.e., there may be more than one “John Smith”, each with a different student number). Then the functional dependencies are:
Number  Name
Number  Dorm
Number  RoomType
RoomType  DormCost
Note: This assumes that only RoomType  DormCost – that is, the cost of a certain type of dorm room is the same no matter what dorm the student is living in. An alternate assumption would be that (Dorm, RoomType)  DormCost, where the cost of the type of dorm room varies form dorm to dorm.
c. Transform this table into two or more tables such that each table is in BCNF and in 4NF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.
We’ll move the obvious multivalued dependencies into their own tables, and then check for BCNF. IF we have BCNF and no multivalued dependencies, we also have 4NF:
STEP ONE: MOVE MUTIVALUED DEPENDENCIES INTO SEPARATE TABLES:
STUDENT_2 (Number, Name, Dorm, RoomType, DormCost)
STUDENT_SIBLING (Number, Sibling)
STUDENT_NICKNAME (Number, Nickname)
STEP TWO: CHECK EACH OF THE RESULTING TABLES FOR BNCF:
STEP TWO (A): CHECK STUDENT
STUDENT_2 FUNCTIONAL DEPENDENCIES:
STUDENT_2 (Number, Name, Dorm, RoomType, DormCost)
Number  Name
Number  Dorm
Number  RoomType
RoomType  DormCost
STUDENT_2 CANDIDATE KEYS:
Number
Is every determinant a candidate key?
NO, RoomType is NOT a candidate key.
Therefore the relation is NOT in BCNF.
Therefore, move RoomType  DormCost into another table
STUDENT_3 (Number, Name, Dorm, RoomType)
DORM_RATE (RoomType, DormCost)
STEP TWO (A) (1): CHECK STUDENT_3:
STUDENT FUNCTIONAL DEPENDENCIES:
STUDENT_3 (Number, Name, Dorm, RoomType)
Number  Name
Number  Dorm
Number  RoomType
STUDENT CANDIDATE KEYS:
Number
Is every determinant a candidate key?
YES, Therefore STUDENT_3 is in BNCF.
STEP TWO (A) (2): CHECK STUDENT:
DORM_RATE FUNCTIONAL DEPENDENCIES:
DORM_RATE (RoomType, DormCost)
...

Other Papers Like Kroenke Ch2 Solutions

A Heart Of Darkness Essay

1748 words - 7 pages In this short story, there are frequent significant subject and ideas that make the story, "A Heart of Darkness," by Joseph Conrad, and haunting novel. The main theme is absolute white power over the natives. The theme validates the corruption, and the dependence caused by the white people as they took over the Congo. White men were giving all the power; they had no self-control, and in the end they did not use wisely. The white men became

The Aspects Of Vulnerability Among The Exploited In Medical Research

2287 words - 10 pages Essentially, everyone is in some state of vulnerability. However, some of us are more susceptible to harm due to our vulnerabilities. The susceptible are the individuals with the greatest risk. These individuals risk the loss of their autonomy, and maybe even their lives. Vulnerable populations can be found in every subset of society. However, as previously mentioned, there are some vulnerable populations that are at an even greater risk than

The Hitchhiker’S Guide To The Galaxy

1171 words - 5 pages The Hitchhiker’s Guide to the Galaxy As the human race makes life-changing discoveries, it is made apparent that there is always more to learn as the universe, instead of becoming familiar, is becoming absurd. The Hitchhiker’s Guide to the Galaxy, written by Douglas Adams, as well as the 2005 film adaption, portrays absurdity to be an all-encompassing system in the universe. Through the introduction and attempt to understand lack of reason, the

The Ford Motor Company Wage Increase Of 1914 And The Theory Of Incentives And Efficiency Wages

1252 words - 6 pages ‘It’s not the employer who pays the wages. Employers only handle the money. It is the customer who pays the wages’ (Henry Ford, cited in Johnson and Weinstein 2004, p. 2). When the Ford Motor Company announced that it would more than double the wages of its workers in January 1914 to a ‘five-dollar day’ minimum, was this a contradiction to Henry Ford’s statement? If customers are actually the ultimate payers of wages, then more than

Historical Analysis Of The Economical Breakthroughs Of The Industrial Revolution

1396 words - 6 pages A Historical Analysis of the Economical Breakthroughs of the Industrial Revolution During the Industrial Revolution, many elements of society experienced huge breakthroughs that would change the way they functioned forever. Economics were definitely one of them. With many new inventions and many factories appearing, many, many, more resources were being created than ever before. Also, all of the revenue from these resources was being given to

Leadership Portrayed in Monologue from Shakespeare’s Henry V

1214 words - 5 pages Leadership is defined as a socially constructed process and which also affect organizational future outcomes. Leader is someone at high position who have overall duty for an organization, she or he decide what to do and the way how to achieve it. (Carter and Greer, 2013)The role of leader is extremely important for an organization, leader use their own power to influence the followers though many different ways such as motivation in order to

Cuba Civil Rights

1906 words - 8 pages Picture a country that has limits on how much you can make random government imprisonments and more what do you do. That is the situation for the eleven million seventy-five thousand two hundred forty-four people of Cuba since the takeover of Fidel Castro. The US is opposed to Castro taking control of Cuba. Castro managed to ease the United States nerves when he said that Cuba was against all forms of communism. According to Lana Wylie the Union

US Freight System

1273 words - 6 pages marketplace and to enhance quality of life, effective investments in U.S. transportation infrastructure must be made and innovative transportation solutions must be considered • The freight railroads in the U.S. are poised to meet these challenges by offering multiple transportation solutions in a constant effort to meet customer needs The increasing population and transport of goods projected for the next 25 years, permits the League to continue playing

Democratic Peace Theory

1852 words - 8 pages Intro: US Presidents have made it a goal during their term(s) in office to establish a good relationship with foreign countries and even try to improve upon existing connections with our allies. Some believe it is to prevent conflicts between the countries while others dispute that it is a threat assessment by the United States to pick and choose their friends and enemies. Preventing conflict between two democracies or countries that practice

Booker T. Washington

1621 words - 7 pages “Success is to be measured not so much by the position that one has reached in life as by the obstacles which he has overcome” –Booker T. Washing. Booker Taliaferro Washington was born in Hale’s Ford, Virginia on April 5th, 1856 to Jane Burroughs and an unknown White man. Washington was married three times. His first wife was Fannie N. Smith from Malden, West Virginia. Booker and Fannie were married in the summer of 1882 and had one child

Corn, Broccoli, Grass Or Balanced

2611 words - 11 pages About a century ago, there was not an epidemic of diet-related illness, a bizarre account of destroyed farmland, dead zones in our oceans created by chemical run-off spilling into the waterways, and there sure was not millions of people questioning the moral ethics of their diet. In the Omnivore’s Dilemma: A Natural History of Four Meals, the author Michael Pollan goes on a journey to investigate the sources of the nation’s food supply, for which

Related Essays

Freedom And Responsibility Essay

2141 words - 9 pages Built within the Constitution of the United States are specifically defined freedoms that are guaranteed to all citizens. Conversely, with every constitutional freedom there comes a corresponding responsibility. On September 25, 1789, the state legislature’s twelve proposed amendments were transmitted by congress, the first two dealing with congressional representation and congressional pay. The following numbers three through twelve were

Hate Crime Laws Essay

2348 words - 10 pages On June 7, 1998, 49-year-old James Byrd Jr. of Texas accepted a ride from three white men, who then beat him severely, urinated on him, chained him by his ankles to the back of their pick-up truck, dragged him for three miles into the countryside, and dumped his corpse in front of an African-American cemetery (Graczyk). A little over a year later, a jury sentenced ring leader John King to death by lethal injection (“Man Executed for Dragging

Rational Emotional Behavior Therapy Case Study Conceptualization And Treatment Plan

2140 words - 9 pages Rational Emotional Behavior Therapy Case Study of Sarah: A Conceptualization and Treatment Plan Rational emotive behavior therapy, REBT, was developed by Albert Ellis and holds the central belief that the events in our lives do not cause our disturbances but that they are instead caused by our view of the events (Murdock, 2009). Murdock (2009) states that “people are seen as responsible for their behavior” (p. 279) but, because they are

Holidays In Albania Essay

1636 words - 7 pages Have you ever thought about having exciting and incredibly cheap vacations? Albania might be the right choice. According to My Travel Guide, Albania is ranked the fourth among ten places worth visiting in Eastern Europe (“Top 10 Eastern European Destinations”). One can encounter three kinds of vacations in this Mediterranean country: winter, summer, and cultural. The ideal places to spend your winter vacations are the Albanian Alps. They are