rn

Make sure that you explain in detail all your steps - thoughts. You may get extra points for an appropriate observation, you may lose some marks due to an obscure solution. 1. Your task is to design a database for a School, considering only the following points: (a) Every INSTRUCTOR in the database will have also but not only a name (composite attribute (5 points)), an address, and a telephone number (multi valued attribute (5 points)). (b) An instructor may teach different COURSEs, and every course is taught by only 1 instructor (5 points) (c) Be careful because we want to be able to select the instructors by their surname, i.e. to query the database by instructor's surname (5 points) (d) A STUDENT follows different courses, and every course is followed by more than 1 student (5 points) (e) The database memorizes the grades of every student (10 points) (f) The database stores also special students, who do not follow any course (5 points) (g) Every course has pre-requisites, which are courses too (10 points) (h) Some courses are divided into SECTIONS (5 points) with the only (5 points) attributes "Section_id", "day" and "time". Please notive that the attribute Section_id is unique ONLY within the course entity, e.g. we may have 2 sections having Section_id = 1, day= Friday, time = 10.00 one for the course CMPE 351 and one for the course CMPE 561. Questions: (i) {5 + 5 points} Design the ER diagram and schema (ii) {5 + 5 points} Which type of relationships do you have? Discuss both the cardinality and the participation constraints (iii) {10 points} Give the corresponding relational schema of your database (iv) {5 points} Give a possible snapshot of your database containing at least 5 (If mean full 5 points more) entries