Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image

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

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
664220a5d2687_985760.pdf

180 KBs PDF File

Word file Icon
664220a5d2687_985760.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

More Books

Students also viewed these Economics questions

Question

Is peak oil a fact or a concept? Defend your view.

Answered: 1 week ago

Question

What does EUR mean? How is it related to peak oil?

Answered: 1 week ago