The librarians are convinced that a database system is needed to manage their operations. They ask...

Transcribed Image Text:

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

Answer rating: 100% (QA)

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 the full answer