Reference no: EM133135705
Assignment Details:
Question 1. Describe the seven general guidelines used to name any object in a data model.
Question 2. Using MySQL Workbench, complete question 2-29 in the text. In addition to the E-R diagram, describe the process you used to determine which entities, attributes and relationships needed to be considered.
2.29. Draw an E-R diagram for the following situation: ShinyShoesForAll (SSFA) is a small shoe repair shop located in a suburban town in the Boston area. SSFA repairs shoes, bags, wallets, luggage, and other similar items. Its customers are individuals and small businesses. The store wants to track the categories to which a customer belongs. SSFA also needs each customer's name and phone number. A job at SSFA is initiated when a customer brings an item or a set of items to be repaired to the shop. At that time, an SSFA employee evaluates the condition of the items to be repaired and gives a separate esti-mate of the repair cost for each item. The employee also estimates the completion date for the entire job. Each of the items to be repaired will be classified into one of many item types (such as shoes, luggage, etc.); it should be possible and easy to create new item types even before any item is assigned to a type and to remember previous item types when no item in the database is currently of that type. At the time when a repair job is completed, the system should allow the completion date to be recorded as well as the date when the order is picked up. If a customer has comments regarding the job, it should be possible to capture them in the system.
Question 3. Using MySQL Workbench, create an E-R diagram for question 2-32. Explain what you chose for the identifier of each entity type on your ERD.
2-32. Figure 2-26 shows a grade report that is mailed to stu¬dents at the end of each semester. Prepare an ERD reflect-ing the data contained in the grade report. Assume that each course is taught by one instructor. Also, draw this data model using the tool you have been told to use in the course. Explain what you chose for the Identifier of each entity type on your ERD.
Question 4. We've seen ERDs drawn in two additional tools. What are some of the similarities and differences between how they work when compared to MySQL Workbench?
Attachment:- Assignment 2.rar
|
Main causes of turnover
: 1. What do you think could be two main causes of turnover in your Company? Explain.
|
|
Does leana have contract of service or contract for service
: Does Leana have a contract of service or a contract for service with Industrial Injection Molding Solutions
|
|
Example of the fundamental attribution error
: Describe an example of the Fundamental Attribution Error. This example can come from a situation experienced in your own life or from another source
|
|
Calculate the breakeven point in dollars
: Clark's manufactures comfortable women footwear to be worn during office hours. Selling price per unit = $20. Calculate the breakeven point in dollars
|
|
Explain what you chose for the identifier
: Describe the seven general guidelines used to name any object in a data model - Explain what you chose for the identifier of each entity type on your ERD
|
|
Compute the band yield to maturity
: The market price of the bonds is $1,070 and the market's required yield to maturity on a comparable-risk bond is 6 percent. Compute the band yield to maturity
|
|
What is the ending balance of bj after the distribution
: The profit for 2021 was P480,000 and the year-end balances on partners' capital accounts are P200,000; P150,000; and P150,000, What is the ending balance of Bj
|
|
How much will b receive in final distribution
: A, B and C have capital balances of P 300,000, P 400,000 and P 500,000, respectively before liquidation. How much will B receive in final distribution
|
|
List of 5 to 7 competencies
: Provide a list of 5 to 7 competencies that you believe all OD practitioners should possess.
|