Friday, May 8, 2020

Kroenke Ch2 Solutions Essay - 1318 Words

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 must be deleted for each Sibling. For example, if†¦show more content†¦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

Wednesday, May 6, 2020

2 Random Speeches Bob Marley and Beauty (Ideas) Free Essays

Speech September 27, 2012 Bob Marley the Rastafarian I. Nesta Robert Bob Marley was born February of 1945. Bob Marley was born in Jamaica. We will write a custom essay sample on 2 Random Speeches Bob Marley and Beauty (Ideas) or any similar topic only for you Order Now You might know him as a singer, song writer, a rhythm guitarist, and lead singer of the Wailer’s. He stayed with the group through most of his life. Bob is the go to guy for spreading Jamaican music and the Rastafarian movement. Some of his most popular songs are: I Shot the Sheriff, No Women No Cry and Jamming to name a few, I listen to some of his music, which for me is inspirational. Gives me something to think about, what was going on in his mind mentally and the thoughts about war, peace and love. II. One of my favorite quotes from Bob is â€Å"I don’t have prejudice against white people because then I would have prejudice against myself. My father is white my mother is black. I’m not on the black men side or the white men, I’m God’s side. Bob Marley was raised Catholic, but became a devoted Rastafarian and started growing dreads, which is very important to them, it’s like the anatine tuning meaning you’re into the universe. Rastas are also vegetarian. Bob was a jiglo with eleven kids, some you might know like Damien Marley and Ziggy Marley. III. Rastafarians also were avid pot heads which is a Rastafarian belief were ganja or that kush is a holy sacrament. The difference between Rastas and non Rastas are that they smoke for religious and medicinal purposes. Another quote I like is â€Å"why do government people want the herb to be illegal, why something that makes people so happy, so relax so illegal? Some people smoke weed because you rebel makes you question what is and what isn’t. Exercise your mind frees your mind in a society that tries to involve it’s self in everyday life telling you what is right and wrong! † IV. In July 1977 Bob found out that out that he had cancer all throughout his body, he even had spots his brain the size of quarters that the doctor didn’t understand how he last so long without any medication or medicine assistance. He was buried near his birth place; his last words were to his son â€Å"mommy can’t buy life†! I know that for me inner beauty supposed to shine through to reveal your outer beauty; and it’s taken me awhile for me to truly understand why men and women choose physical beauty over inner beauty. Physical beauty and inner beauty can be similar and dissimilar. Inner beauty are the actions we take, whether it’s giving up a smile to a stranger, eating the right foods, wearing clothes that shows our physique, or using the right hair tools: such as curling irons, flat iron, and gel. These are things we do to take care of ourselves, and they add up to make us the unique person that we and you are! Physical and inner beauty can be similar or dissimilar: they both attract people. People in general are attracted to both physical and inner beauty. I may be drawn to Morris Chestnut’s appearance; while my big sister will love his personality. Physical and inner beauty are both equally important though. Let’s take for example: Beyonce, who many young girls and women admire for her unique sense of style (myself included). I’ve never met her in person, but it seems to me that she has this balance of inner and outer beauty. As the face of L’Oreal, a brand known for their quality cosmetics: hair and nail colors; we have seen Beyonce’s alter ego Sasha Fierce! She’s a bad Bitch! She also appears to be very comfortable in her own skin either portraying Etta James in Cadillac Records or Deena Jones in Dream Girls. When I watch Beyonce being interviewed, she seems very genuine, candid, and confident when sharing bits and pieces about her life. I sense that she pay close attention to details: hair, make-up, perfume and the clothes she wears. Finding balance between inner and outer beauty doesn’t just happen overnight. It’ll take some inner soul searching and discovering of our own uniqueness: hat beauty could be in the form of how we dress or the way we shine! Most importantly it’s the way we feel about ourselves, and having the awareness that beauty consists of both the inner and outer, we are the first step to becoming more authentic and the real person that we were meant to be, Beautiful! How to cite 2 Random Speeches Bob Marley and Beauty (Ideas), Essay examples