Scenario C

Scenario C

Mayville Public Library

Situation:

Mayville is a rural village with a population of 900. Until now, Mayville was served bya bookmobile from a larger town. The Mayville Village Council has authorized fundsfor a small public library, and you have volunteered to set up an information systemfor the library. Assume that the library will have multiple copies of certain books.


1. Draw an ERD for the Mayville library system.Answer:

 2. Indicate cardinality.
Answer:

3. Identify all fields you plan to include in the tables.Answer: 


 4. Create 3NF table designs.
Answer:


Comments

Post a Comment

Popular posts from this blog

Chapter 9

Image
Apply Your Knowledge April 8,2018 A. 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?” Question: 1. How should you respond to C. T.? Write him a brief memo with your views. Answer:             Normalization is very important for it is a process of avoiding problems in data design. Also, it is a process of reducing redundancy and multivalued fields. Pick and Shovel Construction Company would provide online transaction processing whe
Read more

Reflection Paper

REFLECTION PAPER IN Commencement Address of Steve Jobs First story is about connecting the dots. Steve jobs says that it is impossible to connect the dots when looking forward, yet it is possible to connect when looking backward. So he reminisce his past and connect all the event happened because it is the answer on who he is right now. Second story is about love and loss. Steve found his self loving what he is doing. In his early age he find love in building his own name and company. He and Woz started Apple without having any knowledge in a business world and became bigger. When Apple became bigger Steve and Woz hire someone that has the knowledge in the business but the business is falling out, so Steve got fired on his own business. Steve never doubt his capability in discovering new things. In years later he build the company name NeXt and Pixar and eventually he met his lovely wife Laurence. Third story is about death. In successful years of Steve Jobs a painful event
Read more

Acticity 1

Image
I agree with the result given by the 16Personalities Test, it stated that I am a defender. Though I am a conservative type of person I can protect myself and others. Sometimes I am more self centered but I care to others. And I am helpful when someone needed my help.
Read more