Test 1 – Part 4 - DB Design – Short Answer – Fall/09 (30%)1). Briefly described something that you learned (or observed, if already knew) from the Discussion Group on DBMS Selection (at most 1 page).2) Convert the following E-R Diagram into tables.13) Faculty-Course ScenarioFor the following scenario, draw an E-R DiagramA faculty (ssn, name, dept) teaches at least one section (offering) of a course and at most four sections. Each section is taught at a different day/time. A faculty can be a Computer Science faculty or a Math faculty. If it is a computer Science faculty, it has an attribute thesisArea, to identify the Area that the instructor advises thesis. A course (course number, course name, number of credits) may have at most three section (offering). A course may have at most one pre-requisite, but may be pre-requisites for several other courses. A student (ssn, name, gpa) may not be taking a course, but can be taking at most 5 different class offerings. You will need to show:1) A super class / Sub-class relationship2) An identifying relationship where one entity is a weak entity3) A non-identifying relationship4) A recursive relationship.24) Library Database (Draw an E-R Diagram)A Reader can be Faculty, a Staff or a Student. A book may have several copies. While the books is identified by an ISBN number, the copy is identified by the ISBN number and the copyNumber. A reader can Check out a maximum five instances of different books. An instance of a book can be checked out by many readers. We need to track alternative books for a reader in case all copies of a specific book is checked out. A reader has as attributes ssn and name. Faculty, Staff and Student also have their own individual attributes. Faculty has officeNum and PhoneNum. Staff has officeNum and Student has major and gpa. A book has an ISBN number, a Title, an Author, a Publisher and the Year of Publication.Draw the complete E-R Diagram of the Scenario. You will need to show:1) A super class / Sub-class relationship2) An identifying relationship where one entity is a weak entity3) A non-identifying relationship4) A recursive relationship.Question for you to think about : Does a reader checks out a book or a bookcoppy ?Is it a book or a bookcopy that has alternatives ?Hint: There should be the following entities: Books, BookCopy, Reader, Faculty, Staff, Student 35) Stolen Car Database Normalization. Put the database in 3NF by breaking up this one big table into several tables and Draw and E-R diagram that includes minimum and maximum cardinality. Hint: 4 answer should contain four tables.Vid -> vtype own_id -> own_nameSuspect_id -> Suspect_Name Vid -> own_id5Vid vtype owner_id owner_name Suspect_id Suspect_Name 207 Escort 17 Jack 10 John 205 Quest 22 Mary 10 John 336 Neon 17 Jack 14 Joe 208 Camry 15 Sue 18 James 207 Escort 17 Jack 19 Henry 6) Draw an ER diagram of an Example of a One to Many binary Relationship.7) Draw an ER Diagram of an Example of a Recursive or Unary Relationship. 48) The following E-R Diagram was obtained from MS-Access. It does not show the cardinality. However, it does show the Primary Keys and Foreign Keys for us to extract the cardinality. Please show the maximum cardinality of all relationships. Do not worry about the minimum cardinality. You may fill in the minimum also, but you will only be graded on the maximum.Also, list a possible order that the tables above may be created, assuming that they need to be created with a Foreign Key.[1]_____________________, [2] _____________________, [3] ________________________, [4] _________________________ , [5] ____________________59) Describe two advantages of using a Matrix like the one below (hint: go to ADbC)Draw an ER diagram for the following scenarios 10) A Customer orders one to many Products. A product may not be ordered by anycustomer, and may be ordered by many customers.11) A part may not contain any parts or may contain many parts. A part is contained in one and only one part.12) A branch has at least one department and may have many departments. Every department belongs to one and only one branch613) There are many ways to improve performance. Start by the OS, the DBMS, the Database, the Network, the Database Application, e.g. Oracle books and other literature encourages us to start with the Database Application. Describe two reasons why we should do so.14) Describe two mechanisms discussed in class to improve