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
for 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

  1. sajilijabiriMarch 4, 2022 at 6:08 PM

    Golden Nugget Hotel and Casino - Mapyro
    Find Golden Nugget 화성 출장마사지 Hotel and 아산 출장샵 Casino locations, rates, amenities: expert Las Vegas research, only at Hotel and Travel Index. 사천 출장샵 Realtime 안양 출장마사지 driving 포천 출장안마 directions to Golden Nugget

    ReplyDelete

Post a Comment

Popular posts from this blog

Image
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?” Questions: 1. How should you respond to C. T.? Write him a brief memo with your views. Ans: Normalization is the approach of organizing the contents of a desk within the database. Normalization is vital to expand device normal overall performance and accuracy. Normalization splits massive quantity of facts in to smaller groupings a good way to get admission to the statistics speedy and co...
Read more

Puppy Palace

Image
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-andpony 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. 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 breed, size, age, name, and so on. In the tricks table, you might want the trick name and description. You will...
Read more