Draw an erd for the library system

Assignment Help Computer Engineering

Reference no: EM132141209

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.

Reference no: EM132141209

Questions Cloud

Balance on the balance sheet at the beginning : Your firm expects to incur a ($500K) loss in year 1 and make $100K of net income in year 2 and $300K of net income in year 3. The retention ratio

How much is in the account 10 years from now : You decide to deposit 1,605.21 dollars in an account that earns 10 percent annual interest (compounded annually). How much is in the account 10 years from now?

How much is in your account after 13 years from now : Assume that you put 373.41 dollars in an account that earns simple interest at a 13.2 percent annual rate. How much is in your account after 13 years from now?

Corporate finance question : What is the present value (PV) of this investment, given that the interest rate is 5% per year?

Draw an erd for the library system : Draw an ERD for the library system. Identify all fields you plan to include in the tables.

Period and cash dividends : What is the major accounting difference between interest incurred during a period and cash dividends declared during the same period?

What is the total distance that the disk arm moves : What is the total distance (in cylinders) that the disk arm moves to satisfy all the pending requests for each of the following disk-scheduling algorithms?

Dealership financing option : What should be the per-annum interest rate that the bank should charge so that it is equivalent to the dealership financing option?

Semi-annual compounding : Suppose instead that the loan interest rate is 6% p.a. semi-annual compounding. How much money will he need?

User Account

All Pages