1. Draw any ER Diagram which demonstrates the following (15 Marks) The library management system has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Draw any ER Diagram which demonstrates the following (15 Marks) The library management system has a database that shows the relationships between the entities such as a book, publisher, and member. Since this is a simple system, it has only four entities. Entities and Attribute Book Entity: It has book_ID, Publisher_Id, Author, title, price, and availability. Publisher Entity: It has Publisher_ID, publisher_address, and publisher_name. Member Entity: It has member_ID, member_date, member_type, member_address, member_name, and expiry date ● ● ● Book Issue Entity: Member_ID, Book_ID, Issue Date. (Rubrics: 15 Marks-12 Marks for the ER Diagram with correct entities and Attributes and 3 marks for correct cardinality) MORE 1. Draw any ER Diagram which demonstrates the following (15 Marks) The library management system has a database that shows the relationships between the entities such as a book, publisher, and member. Since this is a simple system, it has only four entities. Entities and Attribute Book Entity: It has book_ID, Publisher_Id, Author, title, price, and availability. Publisher Entity: It has Publisher_ID, publisher_address, and publisher_name. Member Entity: It has member_ID, member_date, member_type, member_address, member_name, and expiry date ● ● ● Book Issue Entity: Member_ID, Book_ID, Issue Date. (Rubrics: 15 Marks-12 Marks for the ER Diagram with correct entities and Attributes and 3 marks for correct cardinality) MORE
Expert Answer:
Answer rating: 100% (QA)
Step 1 Lets create an EntityRelationship ER Diagram based on the provided information 1 Entities and Attributes BookEntity bookID PublisherId Author t... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...
-
FIGURE P15.62 is a top view of an object of mass m connected between two stretched rubber bands of length L. The object rests on a frictionless surface. At equilibrium, the tension in each rubber...
-
An FCC iron-carbon alloy initially containing 0.10 wt% C is carburized at an elevated temperature and in an atmosphere in which the surface carbon concentration is maintained at 1.10 wt%. If after 48...
-
Robinson Corporation purchased all the outstanding common stock of Hoffman Plastics, Inc. on December 31, 2014. Just before the purchase, the condensed balance sheets of the two companies appeared as...
-
Refer to the table developed in problem 15.5 for University Health Center. Assume the Managed Care Division is evaluating a project with the net cash flows and probabilities shown in the table below....
-
Paul Mincin, CPA, is the auditor of Raleigh Corporation. Mincin is considering the audit work to be performed in the accounts payable area for the current-year engagement. The prior year...
-
You can find this question from Excel worksheet "poison pill question". Twilight has 1,000,000 shares outstanding, and the current stock price is $25 per share. Yesterday, Activist Apollo made a...
-
Presented below is information related to the sole proprietorship of Helen Archer, attorney. Legal service revenue2020 ...........$330,000 Total expenses2020 ........................211,000 Assets,...
-
Because India has a lot less for each worker, it's workers are less productive than those in Japan, Japanese workers just have more tools to do their work. Laptops contain a large number of computer...
-
Make a business report on the establishment of a new franchisee that was opened by you as the Manager. Also cite why the previous one was closed. Please follow the following format: Introduction...
-
1. I have a 2015 Cayenne that is affected by the TDI emissions mess. I love my Cayenne and am upset that Porsche lied to me about its performance. I plan on keeping the car, but my friends, family,...
-
Given the following Adjustable Rate Mortgage (ARM): Loan amount: Term: $100,000 20 years, monthly payment Discount point and fee: $8,000 Teaser rate: Margin: 7.25% 225 basis points Rate caps: 2.5%...
-
Ashley, a twenty-one-year-old college graduate with a 3.5 GPA, was hired for her first job. She was a fast learner on all the soft-ware, but her supervisor had to help her with punctuation. On the...
-
Air enters an adiabatic nozzle at 60 ft/sec, 180 psia and 480 F and, after expansion, leaves the nozzle at 15 psia. Use constant specific heats to calculate the nozzle exit velocity (use a reference...
-
1. "Find the bowlers who had a raw score of 165 or better at Thunderbird Lanes combined with bowlers who had a raw score of 150 or better at Bolero Lanes." (Hint: This is another of those problems...
-
Explain the Hawthorne effect.
-
Match the terms in the left column with their appropriate definition in the rightcolumn. Terms Definitions 1. Economic order quantity a. A document that creates a legal ob EOO) ligation to buy and...
-
What are the advantages and disadvantages of having the person responsible for information security report directly to the chief information officer (CIO), who has overall responsibility for all...
-
Clint Grace has been in business over 30 years and has definite ideas about how his 10 retail stores should be run. He is financially conservative and is reluctant to make expenditures that do not...
-
A sound organization Prevents corruption Enhances creativity None of the above All of the above
-
Which of these operates on group psychology? Formal organization Informal structures Functional structure Divisional structure
-
The ________ networks are usually temporary in nature. Line-and-staff organization Network organizational Virtual organization Tall organizational
Study smarter with the SolutionInn App