Preview

Chapter 4 Quiz Week 2

Better Essays
Open Document
Open Document
537 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Chapter 4 Quiz Week 2
STEP 1 | |

Read the following business requirements closely to determine the entities and relationships needed to fulfill the requirements. The nouns in the paragraph will tell you the entities that will be needed. The verbs in the paragraph will help you determine the relationships between the entities. Muscles Health Club Database Requirements | The Muscles Health Club needs a database to keep track of its members, their personal trainers, and the fitness classes they are taking.Employees can act as personal trainers for members. However, only certified employees can act as personal trainers. A member can work with only one personal trainer at a time.Members can take multiple fitness classes. Fitness classes are taught by employees who can teach multiple classes. Fitness classes are taught in one of the classrooms at one of Muscles Health Club's several locations.Each fitness classroom is designed for a different type of class (e.g., spinning, aerobics, water aerobics, weight training, etc.). It is necessary to track what fitness classes are being held in each of the different Muscles Health Club locations. | | |

STEP 2 | |
 Run Visio 2010 either via Citrix or on your workstation.
 Click on the Software and Database Template group in the main window.
 Double-click on the Database Model Diagram Template to open a new file.
 Save the file with a name containing Lab2_, your first initial, and your last name as the file name (e.g., Lab2_JSmith.accdb). You will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation. STEP 3 | |

Add an entity for each entity you identified in the requirements.
 Drag the entity icon onto the drawing area in Visio.
 In the Database Properties window, add a physical name to identify it. STEP 4 | |

For each entity, create a list of attributes you think would be useful to describe the

You May Also Find These Documents Helpful

  • Good Essays

    WEEK 2 QUIZ

    • 798 Words
    • 8 Pages

    A child learns that whenever he eats all of his dinner he gets a cookie for dessert. This type of learning is BEST explained by _______________.…

    • 798 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    StudyModeUpload

    • 2671 Words
    • 24 Pages

    65. Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.…

    • 2671 Words
    • 24 Pages
    Powerful Essays
  • Satisfactory Essays

    | Contrast Watson’s and Bowlby’s views on attachment * John Watson: warned about the danger of too much mother love. Wants babies to be cared for by many different people * John Bowlby: "no such thing as too much motherly love"…

    • 1279 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    According to Agnew, strain theories generally describe all but which of the following forms of strain?…

    • 615 Words
    • 8 Pages
    Satisfactory Essays
  • Good Essays

    Chapter 4-6 Assignment

    • 773 Words
    • 4 Pages

    Chapters 4-6 Assignment There a variety of reasons on why a person joins a gang. In class, we discussed a variety of different risk factors that can help predict membership. In the video former gang member, Marlin Henderseon discussed his experience within the gang culture. One of the risk factors that we discussed in class involved the family structure. Since both of his parents were crack addicts, he did not get to bond a lot with his family.…

    • 773 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Week 2 Quiz

    • 362 Words
    • 2 Pages

    6. Which of the following is the process that assists helpers with understanding their own attitudes and feelings?…

    • 362 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Week 4 Quiz

    • 341 Words
    • 2 Pages

    a. The emphasis on ethnic foods and ethnically associated political associations instead of deeper ties.…

    • 341 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Lesson 4 quiz

    • 551 Words
    • 7 Pages

    You are now either taking a test or not taking a test. This statement is an example of appropriate polarization.…

    • 551 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Attributes describes one aspect of an entity type. Entity type is described by set of attributes. An entity is a real-world item or concept that exists on its own (Shiflet, 2002). The set of all possible values for an entity is the entity type. Each entity has attributes, or particular properties that describe the entity. For example student Indra Paudel has properties of his own studentID, StudentName and StudentGrade.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    quiz week 1

    • 340 Words
    • 2 Pages

    A theory that explains the most effective pattern of leadership behavior in a specified situation is best classified as…

    • 340 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 4 quiz

    • 604 Words
    • 3 Pages

    7. When the researcher measures a behavior that needs to be changed, applies therapy and measures the behavior again, and then removes the treatment and measures the behavior again, this is referred to as ABA design.…

    • 604 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Chapter 3 Questions

    • 1404 Words
    • 5 Pages

    1. How would you respond when someone makes a decision that adversely affects you while saying “it’s nothing personal it’s just business”? Is business impersonal?…

    • 1404 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Chapter 3 Questions

    • 2090 Words
    • 22 Pages

    1. Which of the following is not one of the advantages of iron over bronze?…

    • 2090 Words
    • 22 Pages
    Satisfactory Essays
  • Powerful Essays

    This paragraph shall contain a full identification of the database to which this document applies including identification number(s), title(s), abbreviation(s), version number(s),…

    • 1336 Words
    • 6 Pages
    Powerful Essays
  • Best Essays

    Srs Project

    • 3236 Words
    • 13 Pages

    References: Abraham Silberschatz, Henry F. Korth and S. Sudarshan. Database System Concepts. McGrawHill, 1996 1…

    • 3236 Words
    • 13 Pages
    Best Essays