Question

A fitness center has customers who may work with a personal trainer. Each personal trainer may...

A fitness center has customers who may work with a personal trainer. Each personal trainer may have many clients and must maintain a schedule of when she meets with clients. Draw an E-R diagram for this situation, and make sure to include Primary Key, Foreign Key, Attributes, and Relationships.

Homework Answers

Answer #1

E-R Diagram-

  • This Er model has 3 main entities-
  1. Customer
  2. Trainer
  3. Meet Schedules
  • This Er model has has been converted into 3NF
  • Here each entity and its attributes are in tabular form
  • Data types of each attribute has been mentioned with it
  • The primary key as PK and foriegn key as FK has been mentioned there.If any doubt, please feel free to ask and comment, i would like to answer them.
    Thank you
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name...
Background Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers...
Background Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company is planning an international expansion by opening a new “supercenter” in the Toronto area. Personal Trainer’s president, Cassia Umi, hired an IT consultant, Susan Park, to help develop an information system for the new facility. During the project, Susan will work closely with Gray Lewis, who will manage the new operation. Background During requirements modeling for the new...
Case Study Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The...
Case Study Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company is planning an international expansion by opening a new “supercenter” in the Toronto area. Personal Trainer’s president, Cassia Umi, hired an IT consultant, Susan Park, to help develop an information system for the new facility. During the project, Susan will work closely with Gray Lewis, who will manage the new operation. Background You are enjoying your job...
An IT support organization within a large company wants to develop a relational database to keep...
An IT support organization within a large company wants to develop a relational database to keep track of its work. We will call users of the organization’s service CLIENTs. CLIENTs, as needed, submit requests for help called TICKETs. Each TICKET, in turn, can have multiple PROBLEM_ITEMs. There are many SUPPORT_SPECIALISTs in the organization. Eventually each PROBLEM_ITEM is assigned to a unique SUPPORT_SPECIALIST. Each SUPPORT_SPECIALIST can have multiple PROBLEM_ITEMs assigned to him or her. Since PROBLEM_ITEMs may not be assigned to...
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram"...
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram" - do an ER diagram like we've been doing in class).   8.99 (do a, b, and c) 8.99 a. Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions, clearly state them for each situation): a. A company has a number of employees. The attributes of...
In the real world of work, we encounter supervisors, co-workers, and customers who may be exhibiting...
In the real world of work, we encounter supervisors, co-workers, and customers who may be exhibiting one or more personality disorders. Lets imagine that you share an office with someone who is borderline. You feel like you need to walk on eggshells all the time around this person. The co-worker's name is Betty and she was diagnosed with a borderline personality disorder. Betty loves to cause conflicts with co-workers and supervisors. She manipulates daily office situations by causing problems purposely...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate...
Florida Now Real Estate (45 pts) Tanya Pierce, President and owner of Florida Now Real Estate is seeking your assistance in designing a database for her business. One of her employees has experience in developing and implementing Access-based systems, but has no experience in conceptual or logical data modeling. So, at this point Tanya only wants you to develop a conceptual data model for her system. You are to use our entity-data diagramming notation - Crows foot symbols. Tanya has...
Jefferson Dance Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD...
Jefferson Dance Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the...
Draw the Crow’s Foot database notation entity-relationship diagrams (ERD) to represent the databases, based on the three narratives below. Use Lucid Chart or another ERD diagramming tool to create your diagram. You do not need to create the databases, but to design it using applicable business rules according to your judgment. Submit a PDF of the Entity Relationship Diagram for each database. Remember to identify in your diagrams: All the main entities and the main attributes for each entity The...
One of Jim O’Brien’s customers, Mid-West Supply, has presented him with an opportunity for a significant...
One of Jim O’Brien’s customers, Mid-West Supply, has presented him with an opportunity for a significant amount of freight moving into a new market for Hardee. Hardee is a truckload carrier primarily moving freight in east/west lanes in the United States, with some movements into Canada. Hardee has dispatch centers located throughout the United States which have some dock and warehousing capacity. The new move would be between Lincoln, NE and Miami, FL. Hardee has avoided this market because of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT