design an entity relationship (ER) model for a library management system. Your E-R model should include...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
design an entity relationship (ER) model for a library management system. Your E-R model should include the following: 1.A list of entities and their attributes. (Section 1 of your document) 2.A list of relationships between entities, including the cardinality of each relationship. (Section 2 of your document) 3.A graphical representation of the ER model (hand drawn figure ONLY scanned clearly and included in your pdf document) (Section 3 of your document) In your design, consider the following requirements for the library management system: A library has many branches, and each branch has a unique name and address. Each branch has many books, and each book has a unique ISBN, title, author, and year of publication. Each branch also has many members, and each member has a unique member ID, name and address (add email address, phone number). Members can borrow books from the library, and each borrowed book has a unique loan number, loan date and return date.. Members can also place holds on books that are currently withdrawn, and each hold has a unique hold ID, suspension date, and expiration date. You should also include any additional entities and relationships that you deem necessary for the library management system. You should have at least 5 entities with at least 5 attributes each. Also, you should have at least 5 connections. design an entity relationship (ER) model for a library management system. Your E-R model should include the following: 1.A list of entities and their attributes. (Section 1 of your document) 2.A list of relationships between entities, including the cardinality of each relationship. (Section 2 of your document) 3.A graphical representation of the ER model (hand drawn figure ONLY scanned clearly and included in your pdf document) (Section 3 of your document) In your design, consider the following requirements for the library management system: A library has many branches, and each branch has a unique name and address. Each branch has many books, and each book has a unique ISBN, title, author, and year of publication. Each branch also has many members, and each member has a unique member ID, name and address (add email address, phone number). Members can borrow books from the library, and each borrowed book has a unique loan number, loan date and return date.. Members can also place holds on books that are currently withdrawn, and each hold has a unique hold ID, suspension date, and expiration date. You should also include any additional entities and relationships that you deem necessary for the library management system. You should have at least 5 entities with at least 5 attributes each. Also, you should have at least 5 connections.
Expert Answer:
Answer rating: 100% (QA)
Solution Section 1 Entities and Attributes Entity Attributes Library Name address Branch Name addres... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
An investor expects a company to enjoy 8% compound annual growth for ever, and she thinks that the appropriate rate for discounting the companys dividends would be 14%. She knows that the companys...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Assume an organization of your own choice. Expose in detail about various traffic-filtering technologies that can be suitable for it with necessary examples.
-
How are writable CDs implemented?
-
Consider an ideal Sterling-cycle engine in which the state at the beginning of the isothermal compression process is 100 kPa, 25C the compression ratio is 6, and the maximum temperature in the cycle...
-
Answer all questions: 1. Describe accounting. 2. Explain on internal and external users of accounting information. 3. Explain the following: Asset Liability Owner's Equity Income Expense 4. Explain...
-
An option based on a variable that is not traded is called a real option or sometimes a soft option. Find the projection price of the soft option with the following parameters and compare with the...
-
The adjusted trial balance of Lisa Morgan, Attorney-at-Law, as of November 30, 2016, after the company had completed the first month of operations, appears below. Appropriate adjustments have been...
-
Order the simplification steps of the expression below using the properties of rational exponents. 567xyll (567xy11) (81) (7) (+) (+) 3x (7xy)* . (34). 7. x (2+). y(2+) 3. x. y (7. x. y) 31.7 2.x. y....
-
1. (40 points) For the open-loop plant dynamics from (2.3.2), determine the closed-loop transfer function from the reference input R(s) to the shaft angle output (s) when using a Proportional...
-
.2) The time between requests to a web server is exponentially distributed with mean 0.5 seconds. What is the value of the parameter ?? What Is the median time between requests? What is the standard...
-
Which statement is true? a) Prices are high because rents are high. b) Rents are high because prices are high. c) David Ricardo believed high rents would drive English farmers out of business. d)...
-
If there were no inflation, a dollar today would be worth _______. a) exactly the same as a dollar received in the future b) more than a dollar received in the future c) less than a dollar received...
-
According to the theory of the backward-bending labor supply curve, _________. a) first the substitution effect sets in, then the income effect b) first the income effect sets in, then the...
-
As interest rates rise ______. a) more borrowing will be undertaken b) less borrowing will be undertaken c) there is no change in the level of borrowing.
-
Which statement is true? a) The primary job market has most of the good jobs. b) The secondary job market has most of the good jobs. c) Neither the primary nor the secondary job market has the best...
-
Question 24 How do you write "Hello World" in an alert box? OA. msgBox("Hello World"); B. alertBox("Hello World"); C. alert("Hello World"); D. alert_msg("Hello World");
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
Brian and Kim have a 12-year-old child, Stan. For 2012, Brian and Kim have taxable income of $52,000, and Stan has nonqualifying dividend income of $4,500 and investment expenses of $250. No election...
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...
-
Karim Depak received a Form 1099-B showing the following stock transactions and basis during 2012: None of the stock is qualified small business stock. Calculate Karim's net capital gain or loss...
-
What methods can a company use to raise capital?
-
Does higher expected inflation increase, decrease, or have no effect on the required rate of return?
-
What are some of the advantages of equity financing?
Study smarter with the SolutionInn App