-

APPLY YOUR KNOWLEDGE 3



Mayville Public Library


Situation:
 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 forthe 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.


Mga Komento

Mag-post ng isang Komento

Mga sikat na post sa blog na ito

-
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...
Magbasa nang higit pa