Preview

Rocky Mountain Outfitters

Satisfactory Essays
Open Document
Open Document
258 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Rocky Mountain Outfitters
Rethinking Rocky Mountain Outfitters
Chapter 13

Questions
Update the RMO relational database design in Figure 13-9 based on the changes that you made to the ERD. Be sure that all your database tables are in 3NF.
Write ODL schema specifications for all new classes and relationships that you added to the class diagram.
Verify that the new classes and relationships are accurately represented in the updated relational database design that you developed for question 1.

Answers
Professor, I am confused about the third normal form. I think I understand the example on page 501, figure 13-13, but I don't know how to determine whether one function is dependent on another. I have attempted to create a table in 3NF showing the steps from 1NF.
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Data Table Analysis: Kudler Fine Foods
    • 496 Words
    • 2 Pages

    Data Table Analysis: Kudler Fine Foods

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Jc Penny
    • 765 Words
    • 4 Pages

    Jc Penny

    On April 14, 1902 James Cash Penney the founder and two partners opened the Golden Rule dry-goods store in the small town of Kenner, Wyoming. In 1907 Penney bought out his original partners and took on new ones, beginning with Earl Corder Sams. When the firm was incorporated on January 17, 1913 as JC Penny Stores Company, there were 34 stores in the American West. Penney then moved the company’s main headquarters to New York. Today Penny’s is engaged in marketing apparel, home furnishings, jewelry, cosmetics, and cookware. With all those things and for many years JC Penny has been a great retail store to buy your home goods. And in recent events there has been many bad decisions that have brought Penny’s into a financial bad place. Bring in Ron Johnson, not communicating with their strategy, and not having a good strategy plan.…

    • 765 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    IT 240 Latest Version Set (A) Week 6 Assignment Work Group Scenarios
    • 694 Words
    • 4 Pages

    IT 240 Latest Version Set (A) Week 6 Assignment Work Group Scenarios

    # Select a primary key for each table as indicated in the provided ERD diagram.…

    • 694 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Rocky Mountain National Park
    • 391 Words
    • 2 Pages

    Rocky Mountain National Park

    Bears lake is a popular hiking and camping destination sitting at an elevation of 9,450 feet.. It is approximately 10 miles long and depth is currently unknown.It was formed from a glacier During the ice age, the glacier melted over millions of years…

    • 391 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Service Request Dba/380 Huffman Trucking
    • 553 Words
    • 3 Pages

    Service Request Dba/380 Huffman Trucking

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Answers to Premiere Products Exercises
    • 268 Words
    • 2 Pages

    Answers to Premiere Products Exercises

    For our course assignment, we will ignore the multidependencies and focus on bringing the design to 3NF. The design is already in 1NF, but not in 2NF, due to the partial dependency InstructorNum → InstructorName. Split the table into two:…

    • 268 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Rei Sporting Goods
    • 1182 Words
    • 5 Pages

    Rei Sporting Goods

    REI is a sporting good company that specializes in quality outdoor gear. The company started in 1938 as a gear co-op, and has grown to include more than 3.5 million active members, which it serves through 30 stores, as well as catalog and Internet operations. REI has successfully built a competitive advantage through the four generic building blocks of efficiency, quality, innovation and customer responsiveness.…

    • 1182 Words
    • 5 Pages
    Good Essays
    Read More
  • Good Essays

    Urban Outfitters
    • 653 Words
    • 3 Pages

    Urban Outfitters

    Q2 FY 2009 Urban Outfitters Earnings Conference Call, Thursday, August 14, 2008 11:00 a.m. ET, http://phx.corporate-ir.net/phoenix.zhtml?c=115825&p=irol-EventDetails&EventId=1908465…

    • 653 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    American Eagle Outfitters
    • 1752 Words
    • 8 Pages

    American Eagle Outfitters

    The Silverman family first founded American Eagle Outfitters in 1977. They operated specialty clothing stores under the name Retail Ventures. In 1980 the Silverman's encountered financial troubles when the Schottenstein family bought out 50% of the Retail Ventures. In 1991 the Schottenstein family bought the rest of Retail Ventures and opened 153 American Eagle Outfitters. By late 2000 the company had introduced 46 new stores in Canada. American Eagle had approximately $2 million in annual sales in 2003 and now operates over 800 stores in the United States and Canada (http://www.hoovers.com/american-eagle-outfitters/--ID__17231--/free-co-factsheet.xhtml).…

    • 1752 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Potential constraints on my logical data model
    • 373 Words
    • 2 Pages

    Potential constraints on my logical data model

    The database needs to be adjusted so that the client can adapt to it and use it correctly, for this to happen the database needs to be designed around the client’s knowledge and skill…

    • 373 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Aurora Textile Company
    • 555 Words
    • 3 Pages

    Aurora Textile Company

    1976: The success of the herbicide Lasso had turned around Monsanto's struggling Agriculture Division, and by the time Agent Orange was banned in the U.S. and Lasso was facing increasing criticism, Monsanto had developed the weedkiller "Roundup”…

    • 555 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    C&F Apparel,
    • 310 Words
    • 2 Pages

    C&F Apparel,

    C&F Apparel faced constant challenges of developing good forecasts and maintaining product availability. The main question for Bill Smith, director of business planning for C&F Apparel, was whether or not adopting similar approaches such as “fast fashion” apparel makers Zara could work for his company. Either way, the assumptions in this case is that although it keeps cost low, is outsourcing most of its products from material and assembly plants located in the Pacific rim (while being in North America) worth waiting the two to three months for it to ship? Perhaps C&F should look into the cost-benefit analysis of outsourcing so far away and looking at more domestic sources, such as what Zara has that supplies them in typically two to three weeks. If C&F weren’t outsourcing as much, they could get their products in faster, and thus getting to customers faster. This could also help with fashion trends as waiting two to three months for shipment could be outdated than other similar sized sports apparel and active wear companies. While looking at their previous sales in certain products, its also important for C&F to see how those products demands are looking for their competitors in the same industry.…

    • 310 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Aurora Textile Company
    • 308 Words
    • 2 Pages

    Aurora Textile Company

    Aurora Textile Company having over 100 years history has been producing cotton and synthetic/cotton blend yarns to textile industry consisting of U.S. and the international market. The majority of the company’s revenue came from the domestic market and revenue sources for Aurora consist of the hosiery market accounting for 0.43, the knitted-outwear market accounting for 0.35, the wovens market accounting for 0.13, and industrial and specialty products accounting for remaining 0.09 of Aurora’s revenue.…

    • 308 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Carolina Wilderness Outfitters Case Study
    • 1213 Words
    • 5 Pages

    Carolina Wilderness Outfitters Case Study

    The case study depicted several issues that raised many questions unanswered especially regarding the recent termination case. In accordance to the case study, Tel & Tel (Carolina Wilderness Outfitters’ hotline service) received a call from a former employee trying to report discrimination issue in the management and also hinted a fraudulent act. Therefore it is wise for Ramos to investigate further into the matter. She should perform necessary audit procedures and collect all possible evidence to resolve problem.…

    • 1213 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Ranger Supply Company
    • 423 Words
    • 2 Pages

    Ranger Supply Company

    This case is simply intended to force students to think about reasons for or against international business. As with most cases, there are no perfect solutions, but there are some general conclusionsthat can be drawn.a.Some of the more obvious factors to consider are:1.Competition. There are similar distributors in Canada, whereas Eastern Europe may not havean organized system for the distribution of office supplies. Yet, some European firms (likethe British competitor) may attempt to pursue the Eastern European market.2.Transportation Costs. The costs of transporting office supplies to Eastern Europe would behigh, placing Ranger at a relative disadvantage compared to other European firms.3.Export Barriers. Either country could impose tariffs or quotas on the exports. Canada is lesslikely than Eastern European countries to impose such restrictions.4.Marketing Characteristics. Ranger would have an easier time adapting to the Canadianmarket. The information about Eastern Europe firms would be more limited. Thus, Ranger would be unable to identify many of the firms that may need office supplies, unless itexpended funds to search for newly opened retail stores. Furthermore, these stores may prefer to deal with a supplier that is not so distant. For example, they may have connections withWestern Europe suppliers. Since Ranger has no experience in Eastern Europe, it may be at adisadvantage in attempting to penetrate that market.5.Exchange Rates. The future exchange rates of the Canadian dollar and currencies of EasternEuropean countries could be relevant. Even if Ranger plans to invoice the exports in dollars,the future exchange rates will influence the amount of foreign currency needed by the firms inCanada or Eastern Europe to purchase the supplies. Therefore, foreign demand for thesupplies will be influenced by the exchange rates. The future Eastern European currencyvalues are more uncertain. In fact, the…

    • 423 Words
    • 2 Pages
    Good Essays
    Read More

Related Topics