Question: need help with constraints Question2. (24 points, 6 points each) Consider the following ER model about books written by authors. Assuming there are 20 authors,
need help with constraints


Question2. (24 points, 6 points each) Consider the following ER model about books written by authors. Assuming there are 20 authors, 100 books and 10 editors, answer these questions: 1) 2 points each part a. Modify the constraints in the ER model such that each author writes at most one book and works with at most one editor. b. What is the maximum number of triples in R: c. What is the minimum number of triples in R 2) 2 points each part a. Modify the constraints in the ER model such that each author writes at most one book and works with at most one editor. Each editor edits at most one book and works with at most one author b. What is the maximum number of triples in R: c. What is the minimum number of triples in R 3) 2 points each part a. Modify the constraints in the ER model such that each editor edits at least one book and works with at least one author. Each author writes exactly one book and works with exactly one editor. b. What is the maximum number of triples in R c. What is the minimum number of triples in R 4) 2 points each part a. Modify the constraints in the ER model such 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 edited by at least one editor and is written by at least one author b. What is the maximum number of triples in R c. What is the minimum number of triples in R
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
