Question suppose you are designing a database for a library, Ask an Expert

Engineering

Question :

Suppose you are designing a database for a library, the library system contains information about people who borrow. Each person is uniquely identified. People can search and borrow books. A book has book ID. Author name, book title, subject and publishing year.

The library deals with many publishers. Each publisher has name and is uniquely identified by publisher ID.

Each publisher has many books. When a book is borrowed its status is changed from available Into borrowed and a retrieval date will be determined. Each person can borrow at most five books.

Draw an ERD for the library system.

Identify all fields you plan to include in the tables.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M93128674

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Suppose circle is a class derived from the class point now

Suppose, Circle is a class derived from the class Point. Now consider the following statements: Point p[] = new Point[12]; P[0] = new Circle(); Now suppose Circle has a method Area() computing are of a circle, and Point ...

Question after you have analyzed the existing material used

Question: After you have analyzed the existing material used by the company for their day-to-day duties, the current Access database, and the additional requirements that the current system does not meet, the following r ...

Is there any difference in terms of the information that

Is there any difference in terms of the information that could be provided to the decision maker by an IS that was created using HSM and an IS that was created using SSM?

System analysis project 4 can you answer the 4 questions at

System Analysis project 4: can you answer the 4 questions at the task section, thank you. Personal Trainer, Inc. owns and operates fitness centers in a dozen Midwestern cities. The centers have done well, and the company ...

Let sigmaab give the transition diagram for a

Let Σ={a,b}. Give the transition diagram for a nondeterministic ?nite state machine that accepts the set of strings in {a,b}∗ that contain a substring of length four that begins and ends with the same symbol. For example ...

Question 1 a server with an upload rate of 5000 bitssec

Question : 1. A server with an upload rate of 5,000 bits/sec must distribute a 10,000 bit file to 20 clients. Each client has a download rate of 4,000 bits/sec. What is the minimum time required to distribute the file to ...

Question in a sliding window protocol assume that the

Question : In a Sliding Window Protocol, assume that the senders and receivers window sizes are 3 packets each and a total of 6 packets are sent numbered 1-6. Draw time line diagrams corresponding to each of the followin ...

Question sql is often presented a a single database

Question : SQL is often presented a a single database language, but some contend that it is a set of languages. Which is it, why do you say so?, Why is that important for you to understand? Support your answers. The resp ...

Whats your answer about the equilibrium change from an

What's your answer about the equilibrium change from an event which decreases both demand and supply? You don't need to provide graph here. Just describe the curve shifts and how the equilibrium price and equilibrium qua ...

Suppose that the demand curve for tickets to see a football

Suppose that the demand curve for tickets to see a football team play a game is given by Q = 80,000 - 40P and marginal cost is zero. The team's stadium can host 75,000 fans. 1) How many tickets would the team sell if it ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert