Mga Post

-
Imahe
Case Study #2 Personal Trainer, Inc. 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 several development strategies, including in-house development and outsourcing. 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 strateg...
Mag-post ng isang Komento
Magbasa nang higit pa
-
Imahe
Case Study #1 1. Create an initial entity-relationship diagram for the New Century Health Clinic system ANS : 2. Normalize your table designs. ANS: PATIENT  (PATIENT NUMBER, PATIENT FIRST NAME, PATIENT LAST NAME, DATE OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE)  APPOINTMENT LIST  (APPT NUMBER, PATIENT NUMBER, APPOINTMENT DATE, APPOINTMENT TIME, PROVIDER NUMBER) 3. If you identified any new entities during normalization, create a final entity- relationship  diagram  for the system. ANS:         This is my final entity-relationship, the same with  number 1.                 4. Write a memo for your documentation file that contains your recommendation about whether  a file processing or a database environment should be used. Attach copies of your ERD(s) and normalized designs. ANS:           In investigating the segment material...
Mag-post ng isang Komento
Magbasa nang higit pa
-
Imahe
APPLY YOUR KNOWLEDGE 3 Mayville Public Library S ituation:   Mayville is a rural village with a population of 900. Until now, Mayville was  served by a bookmobile from a larger town. The Mayville Village Council has authorized  funds for a small public library, and you have volunteered to set up an information system for the library. Assume that the library will have multiple copies of certain books. 1.  Draw an ERD for the Mayville library system 2. Indicate cardinality.         3. Identify all fields you plan to include in the tables .     4. Create 3NF table designs.
Mag-post ng isang Komento
Magbasa nang higit pa
-
Imahe
APPLY YOUR KNOWLEDGE 4      Western Wear Outfitters Situation:  Western Wear is a mail-order firm that offers an extensive selection of casual clothing  for men and women. Western Wear plans to launch a new Web site, and the company  wants to develop a new set of product codes. Currently, 650 different product sexist , with the possibility of adding more in the future. Many products come in various sizes,styles, and colors. The marketing manager asked you to develop an individualized product code  that can identify a specific item and its characteristics. Your initial reaction is that it can 1. Design a code scheme that will meet the  marketing manager’s stated requirements. 2 . Write a brief memo to the marketing manager suggesting at least one alternative to the   code she proposed, and state your reasons. Answer:           An other option to the item code proposed would be make the co...
Mag-post ng isang Komento
Magbasa nang higit pa
-
Imahe
APPLY YOUR KNOWLEDGE 2  Puppy Palace Situation:             Puppy Palace works with TV and movie producers who need dogs that can perform special tricks, such as headstands, somersaults, ladder climbs, and various dog-and pony tricks. Puppy Palace has about 16 dogs and a list of 50 tricks from which to choose. Each dog can perform one or more tricks, and many tricks can be performed by more than one dog. When a dog learns a new trick, the trainer assigns a skill level. Some customers insist on using dogs that score a 10, which is the highest skill level. As an IT consultant, you have been asked to suggest 3NF table designs. You are fairly certain that a M:N relationship exists between dogs and tricks. Questions: 1. Draw an ERD for the Puppy Palace information system. 2. Indicate cardinality. 3. Identify all fields you plan to include in the dogs and tricks tables. For example, in the dogs table, you might want...
Mag-post ng isang Komento
Magbasa nang higit pa
-
Imahe
APPLY YOUR KNOWLEDGE I April 10, 2018 Pick and Shovel Construction Company Situation: Pick and Shovel Construction Company is a multistate building contractor specializing in medium-priced town homes. C. T. Scott, the owner, is in your office for the third time today to see how the new relational database project is coming along. Unfortunately, someone mentioned to C. T. that the delay had something to do with achieving  normalization . “Why is all this normalization stuff so important?” he asks. “The old system worked OK most of the time, and now you are telling me that we need all these special rules. Why is this necessary?” on is 1.   How should you respond to C. T.? Write him a brief memo with your views. Answer: The use of Normalization is to develop system performance and accuracy. And also normalization is the process of organizing the contents of a table in the database. The main significant of normalization is to Eliminate Duplication of data. ...
Mag-post ng isang Komento
Magbasa nang higit pa