please answer all questions

Match the term to the example. Departments of UNC Charlotte Computer science department Course Name 3160 (Assuming this is the Course number for Database System) Courses offer by departments Database offers by Computer science department Based on this EER diagram. which of the following statements about Author are correct? An author may have written nothing Every book has up to one author An author who has written a book has also contributed to an article An author can write a book or contribute an article, but not both Determine the cardinality for each relationship. The correct answer may depend on business rules. Person to Biological mother Author to Book Country to Capital State to City City to State School to District Student to Class Based on this EER diagram, which of the following statements are incorrect? An article may be part of more than one collection A book or article must have an author An author may not write a book or contribute in an article A collection may include no article A publication can be both book and collection A publication has a volume A collection has a publication title. A publication is either book or collection but not both We can have a publication that is neither book nor collection Suppose we have an EER design that has superclass Movies with subclasses. Consider the following possible pairs of subclasses: 1. [B,NB]:B= movies in which Kevin Bacon appears: NB= movies in which Kevin Bacon does not appear 2. {B,R}:B= movies in which Kevin Bacon appears; R= movies in which Julia Roberts appears 3. [B,K]:B= movies in which Kevin Bacon appears; K= movies in which Val Kilmer appears 4. [L,S]:L= movies more than 100 minutes long; S= movies less than 105 minutes long Consider whether each pair of subclasses is complete or incomplete (partial), and whether the pair is overlapping or disjoint (exclusive). Which of the following statements is correct? Hint: You can use this assumption to answer this question: Both Bacon and Roberts appear in Flatliners. There are movies in which neither Bacon nor Kilmer appears. There is no movie in which both Bacon and Kilmer appear. Every movie has a length, and some movies have a length of 101-104 is complete or incomplete (partial), and whether tric pollowing statements is is overlapping or disjoint (exclusive). Which of the correct? Hint: You can use this assumption to answer this question: Both Bacon and Roberts appear in Flatliners. There are movies in which neither Bacon nor Kilmer appears. There is no movie in which both Bacon and Kilmer appear. Every movie has a length, and some movies have a length of 101-104 minutes. [B,R] is incomplete and disjoint \{B, NB\} is complete and overlapping [B, NB] is complete and disjoint. [B, K] is complete and disjoint