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 After evaluating various development strategies, Susan prepared a system requirements document and submitted her recommendations to Cassia Umi, Personal Trainer’s president. During her presentation, Susan discussed in-house development and outsourcing options. She did not feel that a commercial software package would meet Personal Trainer’s needs. Based on her research, Susan felt it would be premature to select a development strategy at this time. Instead, she recommended to Cassia that an in-house team should develop a design prototype, using a relational database as a model. Susan said that the prototype would have two main objectives: It would represent a user-approved model of the new system, and it would identify all systems entities and the relationships among them. Susan explained that it would be better to design the basic system first, and then address other issues, including Web enhancements and implementation options. She proposed a three-step plan: data design, user interface design, and application architecture. She explained that systems analysts refer to this as the systems design phase of a development project. Cassia agreed with Susan’s recommendation, and asked her to go forward with the plan. Tasks 1. In your discussion of the systems design phase, you mentioned normalization to Cassia. She would like you to explain the basics of normalization in plain English to help her understand the data design tasks. 2. Review the Personal Trainer fact-finding summary in Chapter 4 and draw an ERD with cardinality notation. Assume that system entities include members, classes, merchandise, and fitness instructors. 3. Design tables in 3NF. As you create the database, include various codes for at least three of the fields. 4. Use sample data to populate the fields for at least three records in each table.
Frequently Asked Questions
We are a micro-tutoring platform that connects students with verified tutors. Our tutors are highly vetted to provide
quality answers to homework questions, and papers.
We serve every type of students you can imagine. Many are adult students who have full-time jobs, families, and other time commitments. Others are on-campus college students who want to save themselves time.
We hire current and former academics, graduate students who teach their own classes, with advanced masters and graduate degrees. All of our writers’ credentials are objectively verified prior to their acceptance.
We’ll deliver the paper within your deadline. If you have an 8 hour deadline, we’ll have the paper sent to your email by then. You only need to tell us when you need the paper by and we’ll deliver it before then!
Anywhere from $11.95 to $30 per page. It all depends with your academic level (whether college, undergraduate, masters or Ph.D), number of pages and the urgency. You can use our custom calculator here to get the specific price
Of course. At the moment, we are offering a 10% discounts on all orders above $120. However, if you have an exceptionally large order, say above $400, please talk to our live chat support for a bigger discount. 🙂
Yes it is. All of your credit card information is handled by a third-party. All that we know about you is the name that you provide us with and the assignment that you’re commissioning us to complete.
Absolutely! All our papers are written from scratch. Additionally, we pass them through plagiarism software such as SafeAssign and Turnitin before submission.
Once we are done editing and checking your paper through our plagiarism detection softwares, we’ll send your paper to your email. Alternatively, we’ll upload a copy of the assignment to your personal account.
Our service has a 100% refund policy. If you are not satisfied with your purchase, we’ll return your money. No questions asked!
Yes, you can have it! We offer unlimited revisions on all our papers! Don’t leave until you’re satisfied.
At last a site I can trust! What's more you guys care about my grades. You worry about each and every details and for that I am really grateful!
Thank you very much for the exceptional service! I couldn't have done it without you. You gave me expert guidance all the way through!
I wish I had known about you guys sooner! The writers completed my essay even before the deadline and the quality was exceptional too!