Saturday, October 5, 2019
Theatre history Essay Example | Topics and Well Written Essays - 1250 words
Theatre history - Essay Example One of these elevated stages will represent Oliviaââ¬â¢s house and will be found at the upper right side of the arena. The lower stage, a foot lower from the other, represents the front of her house. At the extreme right of the lower stage looks like an alley where characters enters and the other end where they exit. Lights flood the stage as each character enters and delivers his or her lines. We see gothic designs in the facades (I suggest that it would be a minimalist stage, perhaps columns to represent the foundations of Oliviaââ¬â¢s house and steps that lead to the front of her house). A tree or two (short-growing trees or shrubs, may be placed at one or opposite ends of opposite sides of the road, perhaps some props resembling a hawthorn tree, with apple-shaped, bright red resemblance of its fruit hanging on its branches). Most likely, this part of the play will take place later in the evening, perhaps a little after dinner time, that we will observe characters in the play are like having their relaxing time, in one of the dialogues Olivia reveals that she and Sebastian (mistaken as his twin Viola, who will disguise herself as Cesario) have just been married a couple of hours ago, and Toby will later be seen already drunk. Colorful medieval costumes that are common during the Elizabethan and the Renaissance theatre will be seen worn by the actors, except for Malvolio who should be wearing all black which is evocative of his characterââ¬â¢s mood throughout the play. Music is an element predominantly present throughout the play; it is through music that the love of Orsino is magnified, the irony as well as comedy is amplified in the portrayals of Feste, Malvolio and his tricksters, and in the drunkenness and merriment of Sir Toby Belch. Music, as one of the underlying themes of the play suggests the comic as well as the tragic episodes or scenes in the play. Fast music is played every now and then, which becomes louder when a climactic episode is
Friday, October 4, 2019
International Business Management Essay Example | Topics and Well Written Essays - 4000 words - 2
International Business Management - Essay Example e of this report to be submitted to the Directors of Paltek Company, is to bid for a contract to help Paltek implement its international strategy successfully. The report based on the companyââ¬â¢s resources and sector, will identify strategic challenges and market entry options in international markets. Paltek has an annual turnover of à £5 million, employing 70 people to provide specialist circuit boards for business-to-business (B2B) markets including the military and information technology sectors. The components for manufacturing the circuit boards are procured from a number of international markets. The company plans to sell its product on an international scale, and has marketed some of its goods to the United States. Paltekââ¬â¢s new aim is to break into the Nordic markets, because the economies in Northern Europe are highly advanced. Expansion of the company into the European market would prove to be beneficial because of its great numbers of electronic manufacturers and purchasers. In this region Paltek plans to achieve economies of scale by using innovative ideas necessary to remain competitive. Presently offering their products only to United Kingdom customers, Paltek plans to build the design and manufacture facility for niche markets on an international scale. Though procuring supplies of components from Asia, Paltek does not plan to enter the Asian market to sell its products. The company however sees international activities capturing wider markets as the approach to increase the companyââ¬â¢s growth. Moreover, another reason for developing the European markets is that Paltek believes that the key to running a successful business is to be in close proximity to the customers. ââ¬Å"For a young, resource-constrained, technology-based start-up embarking on international sales, the choice of entry mode is a strategic decision of major importanceâ⬠(Burgel & Murray 33). The initial foreign entry behaviour of a young firm can be of major importance in its
Thursday, October 3, 2019
Pel Appliances Essay Example for Free
Pel Appliances Essay In 1986-87, the company started manufacturing of refrigerators in technical collaboration with M/s IAR-SILTAL of Italy. In 1987, PEL deep freezers were also introduced in technical collaboration with M/s Ariston of Italy. In 2006, the Company has started manufacturing of split type air conditioners of various capacities as the customer choice has shifted from window type to split type. The product has been well received in the market. This encourages the company to multiply its production in the coming year. Today, PEL has become a household name. Its products are not only in great demand in the local market but the Company has started exporting its appliances The company comprises of two divisions: * Appliances Division * Power Division Pak Elektron Limited (PEL) is the pioneer manufacturer of electrical goods in Pakistan. It was established in 1956 in technical collaboration with M/s AEG of Germany. In October 1978, the company was taken over by Saigol Group of Companies. Since its inception, the company has always been contributing owards the advancement and development of the engineering sector in Pakistan by introducing a range of quality electrical equipments and home appliances and by producing hundreds of engineers, skilled workers and technicians through its apprenticeship schemes and training programmes. The company comprises of two divisions: * Ever since their launch, PEL air conditioners have a leading position in the market. PEL air conditioners cooling performance has been tested and approved by Copeland and ITS USA. With the shift of users preference from window type to split type air conditioners, PEL has started manufacturing split type air conditioners. PEL Refrigerators The manufacturing of refrigerators started in 1986-87 in technical collaboration with M/s IAR-SILTAL of Italy. Like the air conditioner, PELs refrigerators are also in great demand. Today, PEL Crystal has 30% market share. Its cooling performance is tested and approved by Danfoss, Germany and its manufacturing facility is ISO 9002 certified by SGS Switzerland. PEL Deep Freezers PEL deep freezers were introduced in 1987 in technical collaboration with M/s Ariston of Italy. Because of durability and high quality, PEL deep freezers are the preferred choice of companies like Unilever. Power Division manufactures energy meters, transformers, switchgears, Kiosks, compact stations, shunt capacitor banks etc. All these electrical goods are manufactured under strict quality control and in accordance with international standards. PEL is one of the major electrical equipment suppliers to Water and Power Development Authority (WAPDA) and Karachi Electrical Supply Corporation (KESC), which are the largest power utilities in Pakistan. Over the years, PEL electrical equipment has been used in numerous power projects of national importance within Pakistan. PEL has the privilege of getting its equipment approved and certified by well-reputed international consultants such as: * Preece, Cardew and Rider, England Harza Engineering Company, USA * Snam Progeti, Italy * Societe Dumezm, France * Miner ;amp; Miner International Inc. USA * Ensa, France In spite of stiff competition from emerging local and multinational brands, PEL Groups appliances and electrical equipments have remained in the spotlight due to constant innovation. Strategic partnership with multinationals of repute have enabled the PEL G roup to incorporate new technologies into existing product ranges, thus giving the Pakistani market access to innovative, affordable and quality products. PEL was 16th Company in Pakistan which got ISO 9002 Certification in 1997, since then PEL Management is applying this International Standard Practices for Effectively Managing Quality of Products and Services that Company Offers. The International Standard Practices in PEL have been Upgraded as per the Revisedà ISO 9001 Standards and itsà Scope of Applicationà is expanding ever since and Top Management is Committed to make PEL a Total Quality Management (TQM) Company. In this Company Quality is the Subject of Management at all Levels.
Just Walk on By: Black Men and Public Space, Brent Staples
Just Walk on By: Black Men and Public Space, Brent Staples In the essay, Just Walk on By, Brent Staples succeeds greatly in demonstrating the current negative view of black men in America and the fact that racism is still alive today. He narrates a personal anecdote about the path he takes to understand the effect his appearance can have on his environment. Staples describes his extreme frustration at the fact that racism plays such a large role in his life. The essay illustrates that prejudice and racism are still prevalent by using many examples, his intended audience, imagery, and comparisons. In this essay, Staples describes how he has always been discriminated against for being a black journalist in a white area of work. He first realizes this as a graduate student when he takes a walk late at night and frightens a white woman who believed he was following her. He agrees that the world is violent and that the woman had a right to be fearful of him, but it perturbs him that he cannot change the fact that he was the cause of the fear. He begins to understand that he has a quality to change the environment around him solely because of the color of his skin. However, he does not become angry but maintains a sense of calamity throughout the essay. His newfound understanding causes him to begin actively trying to make himself look less intimidating to others around him. Accordingly, Staples uses many examples to express the racial stereotype he acquires to his intended audience, which are white women and black men in general. He describes two common times when people unreasonably mistook him for a burglar and a colleague of his as a killer. These examples begin to make the reader feel sympathy towards black men as a whole and the prejudice they cannot escape. He explains a time when he entered a jewelry store to write an article for a newspaper and was greeted with an enormous red Doberman pinscher. Readers realize the hardship of the lives of black men who cannot even enter a jewelry store without causing alarm. Women in particular are victim to this behavior of racism, and some will realize their wrongdoings when reading the essay. Staples, however, will not let this stereotype of being a threat to society overcome his emotions. To lighten the environment around him, he whistles classical music to assure others that he is not a perilous man and th at they should not fear him. Through these actions, he suppresses the personal notions of feeling like a thug while also lessening the aspect of terror felt by nearby people. The whistling allows others to see the accurate representation of Staples that they can only see once they put their racism aside. Furthermore, Staples uses much vivid imagery to help his readers imagine the situations he has to cope with. The image of Staples barely being able to take a knife to a raw chicken shows readers that Staples is in fact a harmless person. Also, Staples describes white women who walk the street as night as seeming to forge ahead as though bracing themselves against being tackled. The women are intensely protecting themselves from black men who they do not know based solely on stereotypes. These images facilitate the readers ability to fully experience the depth of Stapless story. His diction portrays this tactic from the very beginning of his essay. Staples states that his first victim was a woman causing many readers to jump to the conclusion that Staples hurt this woman in some way, like the predisposed notion of black people causes many to presume. Readers soon realize this mistake and recognize that he or she just made the assumption that many people make prejudicially every day. Additionally, Staples uses comparisons to enhance the descriptions of the fear that others feel by Stapless presence. Staples explains that the womans quick getaway when she saw him on a street at night made him feel like an accomplice in tyranny that was indistinguishable from the muggers. This experience shows how the womans racism affected her own actions but also how it negatively influenced the black man emotionally. He also uses an onomatopoeia to recreate the atmosphere of walking the streets at night when he says he could cross in front of a car stopped at a traffic light and elicit the thunk, thunk, thunk, thunk of the driver-black, white, male, or female-hammering down the door locks. The sound of the cars locking creates an uneasy feeling among readers and shows the extent of precaution that not only women took as a result of his presence. Staples effectively persuades his readers to believe that not all black men are harmful and to stop fueling racism. He also convinces his readers to feel sympathetic towards black men. I have been on both sides of this situation by being the one causing fear and the one falling victim to prejudice. I constantly find myself making sure that I am fully aware of my surroundings and the people around me when I am out alone. This prejudice has been passed down to me by my aunts who always encourage me to have pepper spray with me at all times and walk back to my car with my car key poking out between my fingers as a defensive action. I now realize that these notions are wrong and that black men do not deserve this unfair treatment. I know how horrible it makes me feel whenever people fear me in an airport, and I should not encourage this behavior by engaging in it. Stapless essay successfully reveals the emotions felt by black men when they are prejudiced against and the injustice that bl ack men have to deal with still today.
Wednesday, October 2, 2019
african americans Essay -- essays research papers
African Americans continued to live as second class citizens in the 1950ââ¬â¢s and 1960ââ¬â¢s, especially in the South, despite the Fourteenth Amendment and the Fifteenth Amendment, which prohibited states from denying anyone the right to vote due to race. States passed laws directed at separating the races and keeping blacks from the polls. During these times, African Americans and other Americans led an organized and strong movement to fight for racial equality. The movement often met with strong opposition, such as in Birmingham, Alabama, where police sprayed protestors with high pressure fire hoses. à à à à à In the early 1900ââ¬â¢s W.E.B. Du Bois established the NAACP, (National Association for the Advancement of Colored People) which fought to end segregation, the separation of people on the basis of race. In the case of Brown vs. Board of Education, the Supreme Court struck down segregation as unconstitutional. à à à à à On December 1, 1955, Rosa Parks, a seamstress and an NAACP officer, took a seat in the front row of the ââ¬Å"coloredâ⬠section of a Montgomery bus. As the bus filled up, the driver ordered Parks and three other African American passengers to empty the row they were occupying so that a white man could sit down without having to sit next to any African Americans. The leaders of the African American community, including many ministers, formed the Montgomery Improvement Association to organize a boycott. They elected the pastor o...
Sexual Discrimination in the Workplace :: Sexual Discrimination Stereotypes Feminism Essays
Sexual Discrimination in the Workplace Sexual discrimination in the workplace is something that many individuals have to deal with. This is not to be confused with sexual harassment, rather different treatment an individual(s) receives because of their gender. I chose to speak to this issue because it seems that no matter what is done, this idea, or 'tradition,' of men being superior to women will not fade out. Sexual discrimination is a major factor in how some stereotypes are derived. Men, on the average, are taller, stronger, and more aggressive than women (Harriman 69). It is believed that women have a slight advantage over men in communication skills and creativity. Women are perceived as delicate and are definitely the only part of the human population capable of bearing children, therefore, working conditions that were set for men were considered to be too dangerous for women (Harriman 47). Consider this scenario. A woman goes to college for four years. She put everything she had into getting an education that would give her an edge on the competition in her field. When she steps out into the world to strive towards her dream career, she finds that doors are being slammed in her face because she is not the right 'man' for the job. It disgusts me to think that I, or any man for that matter, could cause a major downfall in a company (which could also hurt the economy) because I was hired as a male instead of a qualified employee. One may in theory have equal opportunity to demonstrate skills in certain types of employment, but if one lacks money for decent clothes, or in some cases social standing, [or their sex], one is less likely to be interviewed... -Gross 105 This unfair treatment cannot be abolished by just snapping your fingers or closing your eyes and clicking your heels together.
Tuesday, October 1, 2019
Database Slides on Normalization
Chapter 11 Relational Database Design Algorithms and Further Dependencies Chapter Outline ? ? ? ? ? ? ? 0. Designing a Set of Relations 1. Properties of Relational Decompositions 2. Algorithms for Relational Database Schema 3. Multivalued Dependencies and Fourth Normal Form 4. Join Dependencies and Fifth Normal Form 5. Inclusion Dependencies 6. Other Dependencies and Normal Forms DESIGNING A SET OF RELATIONS ? Goals: ? Lossless join property (a must) ? Algorithm 11. 1 tests for general losslessness. Algorithm 11. decomposes a relation into BCNF components by sacrificing the dependency preservation. 4NF (based on multi-valued dependencies) 5NF (based on join dependencies) ? Dependency preservation property ? ? Additional normal forms ? ? 1. Properties of Relational Decompositions ? Relation Decomposition and Insufficiency of Normal Forms: ? Universal Relation Schema: ? A relation schema R = {A1, A2, â⬠¦, An} that includes all the attributes of the database. Every attribute name is unique. ? Universal relation assumption: ? (Cont) ? Decomposition: ? ? Attribute preservation condition: ?The process of decomposing the universal relation schema R into a set of relation schemas D = {R1,R2, â⬠¦, Rm} that will become the relational database schema by using the functional dependencies. Each attribute in R will appear in at least one relation schema Ri in the decomposition so that no attributes are ââ¬Å"lostâ⬠. (Cont) ? ? Another goal of decomposition is to have each individual relation Ri in the decomposition D be in BCNF or 3NF. Additional properties of decomposition are needed to prevent from generating spurious tuples (Cont) ? Dependency Preservation Property of a Decomposition: ? Definition: Given a set of dependencies F on R, the projection of F on Ri, denoted by pRi(F) where Ri is a subset of R, is the set of dependencies X > Y in F+ such that the attributes in X U Y are all contained in Ri. Hence, the projection of F on each relation schema Ri in t he decomposition D is the set of functional dependencies in F+, the closure of F, such that all their left- and right-hand-side attributes are in Ri. (Cont. ) ? Dependency Preservation Property of a Decomposition (cont. ): ? Dependency Preservation Property: ? ? A decomposition D = {R1, R2, â⬠¦ Rm} of R is dependency-preserving with respect to F if the union of the projections of F on each Ri in D is equivalent to F; that is ((? R1(F)) U . . . U (? Rm(F)))+ = F+ (See examples in Fig 10. 12a and Fig 10. 11) ? Claim 1: ? It is always possible to find a dependency-preserving decomposition D with respect to F such that each relation Ri in D is in 3NF. Projection of F on Ri Given a set of dependencies F on R, the projection of F on Ri, denoted by ? Ri(F) where Ri is a subset of R, is the set of dependencies X > Y in F+ such that the attributes in X ?Y are all contained in Ri. Dependency Preservation Condition Given R(A, B, C, D) and F = { A > B, B > C, C > D} à Let D1={R1(A,B), R2 (B,C), R3(C,D)} ? R1(F)={A > B} ? R2(F)={B > C} ? R3(F)={C > D} FDs are preserved. (Cont. ) ? Lossless (Non-additive) Join Property of a Decomposition: ? Definition: Lossless join property: a decomposition D = {R1, R2, â⬠¦ , Rm} of R has the lossless (nonadditive) join property with respect to the set of dependencies F on R if, for every relation state r of R that satisfies F, the following holds, where * is the natural join of all the relations in D: (? R1(r), â⬠¦ , ? Rm(r)) = r ? Note: The word loss in lossless refers to loss of information, not to loss of tuples. In fact, for ââ¬Å"loss of informationâ⬠a better term is ââ¬Å"addition of spurious informationâ⬠Example S s1 s2 s3 P p1 p2 p1 D d1 d2 d3 = S s1 s2 s3 P p1 p2 p1 * P p1 p2 p1 D d1 d2 d3 Lossless Join Decomposition NO (Cont. ) Lossless (Non-additive) Join Property of a Decomposition (cont. ): Algorithm 11. 1: Testing for Lossless Join Property Input: A universal relation R, a decomposition D = {R1, R2, â⬠¦ , Rm} of R,and a set F of functional dependencies. 1.Create an initial matrix S with one row i for each relation Ri in D, and one column j for each attribute Aj in R. 2. Set S(i,j):=bij for all matrix entries. (/* each bij is a distinct symbol associated with indices (i,j) */). 3. For each row i representing relation schema Ri {for each column j representing attribute Aj {if (relation Ri includes attribute Aj) then set S(i,j):= aj;};}; ? (/* each aj is a distinct symbol associated with index (j) */) ? CONTINUED on NEXT SLIDE (Cont. ) 4. Repeat the following loop until a complete loop execution results in no changes to S {for each functional dependency X >?Y in F {for all rows in S which have the same symbols in the columns corresponding to attributes in X {make the symbols in each column that correspond to an attribute in Y be the same in all these rows as follows: If any of the rows has an ââ¬Å"aâ⬠symbol for the column, set the other rows to that same ââ¬Å"aâ ⬠symbol in the column. If no ââ¬Å"aâ⬠symbol exists for the attribute in any of the rows, choose one of the ââ¬Å"bâ⬠symbols that appear in one of the rows for the attribute and set the other rows to that same ââ¬Å"bâ⬠symbol in the column ;}; }; }; 5.If a row is made up entirely of ââ¬Å"aâ⬠symbols, then the decomposition has the lossless join property; otherwise it does not. (Cont. ) Lossless (nonadditive) join test for n-ary decompositions. (a) Case 1: Decomposition of EMP_PROJ into EMP_PROJ1 and EMP_LOCS fails test. (b) A decomposition of EMP_PROJ that has the lossless join property. (Cont. ) Lossless (nonadditive) join test for n-ary decompositions. (c) Case 2: Decomposition of EMP_PROJ into EMP, PROJECT, and WORKS_ON satisfies test. (Cont. ) ? Testing Binary Decompositions for Lossless Join Property ? ?Binary Decomposition: Decomposition of a relation R into two relations. PROPERTY LJ1 (lossless join test for binary decompositions): A decomposi tion D = {R1, R2} of R has the lossless join property with respect to a set of functional dependencies F on R if and only if either ? ? The FD ((R1 ? R2) >? (R1- R2)) is in F+, or The FD ((R1 ? R2) >? (R2 ââ¬â R1)) is in F+. 2. Algorithms for Relational Database Schema Design Algorithm 11. 3: Relational Decomposition into BCNF with Lossless (non-additive) join property Input: A universal relation R and a set of functional dependencies F on the attributes of R. 1. Set D := {R}; 2.While there is a relation schema Q in D that is not in BCNF do { choose a relation schema Q in D that is not in BCNF; find a functional dependency X > Y in Q that violates BCNF; replace Q in D by two relation schemas (Q ââ¬â Y) and (X U Y); }; Assumption: No null values are allowed for the join attributes. Algorithms for Relational Database Schema Design Algorithm 11. 4 Relational Synthesis into 3NF with Dependency Preservation and Lossless (Non-Additive) Join Property Input: A universal relation R a nd a set of functional dependencies F on the attributes of R. 1. Find a minimal cover G for F (Use Algorithm 10. ). 2. For each left-hand-side X of a functional dependency that appears in G, create a relation schema in D with attributes {X U {A1} U {A2} â⬠¦ U {Ak}}, where X >? A1, X >? A2, â⬠¦ , X > Ak are the only dependencies in G with X as left-hand-side (X is the key of this relation). 3. If none of the relation schemas in D contains a key of R, then create one more relation schema in D that contains attributes that form a key of R. (Use Algorithm 11. 4a to find the key of R) 4. Eliminate redundant relations from the result. A relation R is considered redundant if R is a projection of another relation SAlgorithms for Relational Database Schema Design Algorithm 11. 4a Finding a Key K for R Given a set F of Functional Dependencies Input: A universal relation R and a set of functional dependencies F on the attributes of R. 1. Set K := R; 2. For each attribute A in K { Compu te (K ââ¬â A)+ with respect to F; If (K ââ¬â A)+ contains all the attributes in R, then set K := K ââ¬â {A}; } (Cont. ) 3. Multivalued Dependencies and Fourth Normal Form (a) The EMP relation with two MVDs: ENAME ââ¬â>> PNAME and ENAME ââ¬â>> DNAME. (b) Decomposing the EMP relation into two 4NF relations EMP_PROJECTS and EMP_DEPENDENTS. (Cont. ) c) The relation SUPPLY with no MVDs is in 4NF but not in 5NF if it has the JD(R1, R2, R3). (d) Decomposing the relation SUPPLY into the 5NF relations R1, R2, and R3. (Cont. ) Definition: ? A multivalued dependency (MVD) X ââ¬â>> Y specified on relation schema R, where X and Y are both subsets of R, specifies the following constraint on any relation state r of R: If two tuples t1 and t2 exist in r such that t1[X] = t2[X], then two tuples t3 and t4 should also exist in r with the following properties, where we use Z to denote (R -(X U Y)): ? t3[X] = t4[X] = t1[X] = t2[X]. t3[Y] = t1[Y] and t4[Y] = t2[Y]. t3[Z] = t2[Z] a nd t4[Z] = t1[Z].An MVD X ââ¬â>> Y in R is called a trivial MVD if (a) Y is a subset of X, or (b) X U Y = R. ? ? ? Multivalued Dependencies and Fourth Normal Form Definition: ? A relation schema R is in 4NF with respect to a set of dependencies F (that includes functional dependencies and multivalued dependencies) if, for every nontrivial multivalued dependency X ââ¬â>> Y in F+, X is a superkey for R. ? Informally, whenever 2 tuples that have different Y values but same X values, exists, then if these Y values get repeated in separate tuples with every distinct values of Z {Z = R ââ¬â (X U Y)} that occurs with the same X value. Cont. ) (Cont. ) Lossless (Non-additive) Join Decomposition into 4NF Relations: ? PROPERTY LJ1ââ¬â¢ ? The relation schemas R1 and R2 form a lossless (non-additive) join decomposition of R with respect to a set F of functional and multivalued dependencies if and only if ? (R1 ? R2) ââ¬â>> (R1 ââ¬â R2) (R1 ? R2) ââ¬â>> (R2 ââ¬â R1 )). ? or ? (Cont. ) Algorithm 11. 5: Relational decomposition into 4NF relations with non-additive join property ? Input: A universal relation R and a set of functional and multivalued dependencies F.Set D := { R }; While there is a relation schema Q in D that is not in 4NF do { choose a relation schema Q in D that is not in 4NF; find a nontrivial MVD X ââ¬â>> Y in Q that violates 4NF; replace Q in D by two relation schemas (Q ââ¬â Y) and (X U Y); }; 1. 2. 4. Join Dependencies and Fifth Normal Form Definition: ? A join dependency (JD), denoted by JD(R1, R2, â⬠¦ , Rn), specified on relation schema R, specifies a constraint on the states r of R. ? ? The constraint states that every legal state r of R should have a non-additive join decomposition into R1, R2, â⬠¦ Rn; that is, for every such r we have * (? R1(r), ? R2(r), â⬠¦ , ? Rn(r)) = r (Cont. ) Definition: ? A relation schema R is in fifth normal form (5NF) (or Project-Join Normal Form (PJNF)) with respect to a set F of functional, multivalued, and join dependencies if, ? for every nontrivial join dependency JD(R1, R2, â⬠¦ , Rn) in F+ (that is, implied by F), ? every Ri is a superkey of R. Recap ? ? ? ? ? Designing a Set of Relations Properties of Relational Decompositions Algorithms for Relational Database Schema Multivalued Dependencies and Fourth Normal Form Join Dependencies and Fifth Normal FormTutorial/Quiz 4 Q1) Consider a relation R with 5 attributes ABCDE, You are given the following dependencies: A > B, BC > E, ED > A a) List all the keys, b) Is R in 3 NF c) Is R in BCNF Q2) Consider the following decomposition for the relation schema R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = { {A, B} > {C}, {A} > {D, E}, {B} > {F}, {F} > {G, H}, {D} -> {I, J} }. Preserves Lossless Join and Dependencies? a) D1 = {R1, R2, R3, R4, R5}, R1={A,B,C} R2={A,D,E}, R3={B,F}, R4 = {F,G,H}, R5 = {D,I,J} b) D2 = {R1, R2, R3} R1 = {A,B,C,D,E} R2 = {B,F,G,H}, R3 = {D,I,J }
Subscribe to:
Posts (Atom)