Question: The librarians are convinced that a database system is needed to manage their operations. They ask you to prepare technical documentation based on the

The librarians are convinced that a database system is needed to manage their operations. They ask you to prepare technical documentation based on the following business processes and business rules: 1. When someone new visits the library, the librarians sign them up as a member of the library, giving them a library card with their unique member number. 2. Members can loan any number of books, movies, or subscriptions while their membership is active, and they are in good standing with the library. A librarian helps each member sign out their books using their librarian profile. 3. If a Member forgets to bring back their book or movie on time, a fine is applied to their account. Each fine indicates why the fine was issued and for which loan it originated from. As part of the technical documentation, you must prepare: 1. A description of an Entity-Relation Diagram, indicating which tables should exist, the primary keys for each table, at least two other fields within those tables, and the relationships between the tables. When describing your fields, clearing indicate which table they are in and if they are a primary or foreign key. When describing your relationships, clearly indicate the connectivity and cardinality between tables.
Step by Step Solution
There are 3 Steps involved in it
Sure based on the image you sent the librarians are convinced that a database system is needed to manage their operations They ask you to prepare technical documentation based on the following busines... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
664220a5d2687_985760.pdf
180 KBs PDF File
664220a5d2687_985760.docx
120 KBs Word File
