Consider the following ER model about editing books written by authors. Assuming there are 30 authors,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following ER model about editing books written by authors. Assuming there are 30 authors, 1000 books and 10 editors, answer these questions: Editors eid aid R Authors Books bid 1) Modify the ER model such that each author writes at most one book and works with at most one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R 2) Modify the ER model such that each author writes exactly one book and works with exactly one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R 3) Modify the ER model such that each author writes at least one book and works with at least one editor. Each editor edits at least one book and works with at least one author. Each book is written by at least one author and is edited by at least one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R Consider the following ER model about editing books written by authors. Assuming there are 30 authors, 1000 books and 10 editors, answer these questions: Editors eid aid R Authors Books bid 1) Modify the ER model such that each author writes at most one book and works with at most one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R 2) Modify the ER model such that each author writes exactly one book and works with exactly one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R 3) Modify the ER model such that each author writes at least one book and works with at least one editor. Each editor edits at least one book and works with at least one author. Each book is written by at least one author and is edited by at least one editor. a. What is the maximum number of triples in R b. What is the minimum number of triples in R
Expert Answer:
Answer rating: 100% (QA)
Question 1a What is the maximum number of triples in R The maximum number of triples in R is 1000 30 ... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0071339476
Volume 1, 6th Edition
Authors: Beechy Thomas, Conrod Joan, Farrell Elizabeth, McLeod Dick I
Posted Date:
Students also viewed these computer network questions
-
1. (25 marks) The financial year end for a large machine parts manufacturer will end in a week's time. The manager, Rebecca who is in charge of 10 salespersons is overwhelmed with work as is usual...
-
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...
-
This lab requires you to develop a solution using Java object-oriented programming that simulates an order system for children's toys. The child will manage a collection/list of toys (each child owns...
-
Kenneth Tully and Toby Benning began a new consulting business on January 1, 2020. They organized the business as a C corporation, KT, Inc. During 2020, the corporation was successful and generated...
-
Is the following label on a household product cause for concern? "Caution: This product contains tiny, electrically charged particles moving at speeds in excess of 100,000,000 kilometers per hour."
-
On October 1, 2017, Vaughn, Inc., leased a machine from Fell Leasing Company for five years. The lease requires five annual payments of $10,000 beginning September 30, 2018. Vaughn's incremental...
-
Kent Oil, a small Texas oil company, holds huge reserves of oil and gas assets. Assume that at the end of 2010, Kent Oils cost of mineral assets totaled approximately $18 million, representing 2.4...
-
(Conceptual FrameworkGeneral) The Financial Accounting Standards Board (FASB) has developed a conceptual framework for financial accounting and reporting. The FASB has issued seven Statements of...
-
Throughout this course, you will work towards creating a financial plan for a company as if you were its business manager . Research financial information and key performance indicators (KPIs) for...
-
Thames Company's inventory records for its retail division show the following at December 31: E (Click the icon to view the accounting records.) At December 31, 10 of these units are on hand. Read...
-
[24] What is the output of the following code? X = 7 if x == 7: else: print ("This is true!") print ("This is false!") print ("This is all folks!")
-
Sales roles can be very demanding, highly competitive, and stressful. Consider the steps to a healthy lifestyle as advocated by Dr. Beth Frates, MD, on her website (www .bethfratesmd.com). Based on...
-
Carry out some research online to investigate the main types of devices and software tools or platforms that may be useful to salespeople in territory management and record keeping. Select one which...
-
Aggie Oil Corporation, a new successful efforts company, incurred the following costs and made the other transactions shown below for the years 2018 and 2019. 2018 a. Paid $225,000 for G&G costs...
-
The following are costs incurred on Erath lease: REQUIRED: Treat each of the following independently: a. A fourth well, an exploratory well, was drilled at a cost of $2,010,000 and was determined to...
-
Garber Oil Company owns 100% of the working interest in the Williams lease. The lease is a fully developed lease located in New Mexico. As of 12/31/18, the lease had proved developed reserves of...
-
You have been the auditor of Crossborder Trading Company Ltd for a number of years. The company's head office is in Nairobi, Kenya and has considerable overseas operations. At each accounting year...
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
Distinguish between a weighted average and a moving average in determining inven-tory unit cost. When is each generally used? Explain.
-
You are presented with the following data from Jake Doyle Inc. for the year ended 31 December 20X1. Additional information: a. Sold property, plant, and equipment for cash. Cost of the assets was $...
-
Which underlying assumption is not appropriate in a country that suffers triple- digit annual inflation?
-
Which of the following procedures would an auditor normally plan only for a first-time audit? a. Review litigation against the company that was settled in prior years. b. Review capital stock...
-
Match the term or terms that relate to each description. Each term may be used once, more than once, or not at all. Description 1. The confirmation of a CPA's responsibility for an audit. 2. In all...
-
Before applying substantive tests to the details of asset accounts at an interim date, an auditor should assess a. Control risk at below the maximum level. b. Inherent risk at the maximum level. c....
Study smarter with the SolutionInn App