Database essay and problem

**_PART - A:_** Explain what is meant by the terms **ER and Enhanced ER (EER) modelling** and where they fit into the database development lifecycle. 1) You should write a short **essay** on this topic, approx **1500 words**, EXCLUDING any diagrams or appendices. 2) The Essay must have an **introduction**, **body** and a **conclusion** 3) You have to include **5 references** and it should be acknowledged in the body of the essay. 4) You will have to make a **powerpoint slideshow** of this essay and it should contain **6 slides**. **_ PART - B: _**1)Draw and EER model for the following problem(given in the deliverables) using traditional EER notation. 2) Also prepare sample definitions for two entity types, their attributes and the relationships in which they participate on your diagram. One of the relationships must be a M:N 3) You must also provide the logical model resulting from this ER diagram. ie. a set of relational tables. ## Deliverables **_PART - A: _**Explain what is meant by the terms **ER and Enhanced ER (EER) modelling** and where they fit into the database development lifecycle. **1)** You should write a short **essay** on this topic, approx **1500 words**, EXCLUDING any diagrams or appendices. **2)** The Essay must have an **introduction**, **body** and a **conclusion 3)** You have to include **5 references** and it should be acknowledged in the body of the essay. **4)** You will have to make a **powerpoint slideshow** of this essay and it should contain **6 slides**. **_PART - B: _**1)Draw and EER model for the following problem(given below in the problem specification) using traditional EER notation. 2) Also prepare sample definitions for two entity types, their attributes and the relationships in which they participate on your diagram. One of the relationships must be a M:N 3) You must also provide the logical model resulting from this ER diagram. ie. a set of relational tables. **_PROBLEM SPECIFICATION:_** An international school of technology has hired you to create a database management system in order to assist in scheduling classes. After several interviews with the president you have come up with the following list of entities, attributes and initial business rules: **1)** Room is identified by Building_ID and Room_NO and also has a capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called board_type. **2)** Media is identified by Mtypeid and has attributes of MediaType and TypeDescription. Please **NOTE**: Here we are tracking type of media(such as a VCR, projector etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project. **3)** Computer is identified by Ctypeid and has attributes ComputerType, TypeDescription, DiskCapacity and ProcessorSpeed. Please **NOTE**: As with MediaType, we are tracking only the type of computer, not an individual computer. You can think of this as a class of computers (eg. PIII 900Mhz) **4)** Instructor has been identified by Emp_Id and has attributes- Name, Rank, and Office_Phone **5)** Timeslot has identifier TSID and has attributes sDayofWeek, StartTime and EndTime **6)** Subject has identifier SubjectID and has attributes Subject Description and Credits. Subjects can have one, none or many prerequisites. **7)** Subjects also have one or more sections. Section has identifier SectionID and attribute EnrollmentLimit. After some further discussions, you have come up with some additional business rules to help you to create the initial design: **1)** An instructor teaches one, none or many sections of a subject in a given semester. An instructor specifies preferred timeslots. Scheduling data are kept for each semester, uniquely identified by semester and year. **2)** A room can be scheduled for one section or no section during one timeslot in a given semester of a given year. However, one room can participate in many schedules, one schedule or no schedules; one timeslot can participate in many schedule, one schedule or no schedule; one session can participate in many schedules, one schedule or no schedules. **3)** A room can have one type of media, several types or no media. **4)** Instructors are trained to use one, none or many types o media. **5)** A lab has one or more computer types. However a classroom does not have any computers. **6) **A room cannot be both a classroom and a lab. There also are no other room types to be incorporated into the system. PART - A and PART - B have to be finished taking all what is given under them into consideration. This project is very much a hurry(just 1 day). Price negotiable upto a limit. Thank you! ## Platform windows xp