Mayville Public Library
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.
No comments:
Post a Comment