Reference Book: Fundamentals of Database Management Systems

Draw an entity-relationship diagram that describes the following environment The city of Chicago, IL, wants to maintain information about its extensive system of high schools, including its teachers, its students, and the subjects that it teaches. Each school has a unique name, plus an address, telephone number, year built, and size in square feet. Students have a student number, name, age and GPA. Regarding a student's school assignment, the school system is only interested in keeping track of which school a student currently attends. Each school has several teachers. Teachers are identified by an employee number and each has a name, age, subject specialty such as English (assume only one per teacher). Teachers tend to periodically move from school to school and the school system wants to keep track of the history of which schools the teacher has taught in, including the current school. Included will be the year in which the teacher joined a school and the highest pay rate that the teacher attained at the school. The school system also wants to keep track of the subjects that it offers (e.g. French I, Algebra III, etc). Each subject has a unique subject number, a subject name, the grade level in which it is normally taught. The school system wants to keep track of which teacher taught which student which subject, including the year this happened and the grade received. The school system also wants to record the year in which a subject was introduced in the school system. Allow for a new student (who has not taken any subject) or a new teacher (who has not taught any subject) or a new subject (that no student has taken yet). a. You need six entities. What are they? b. Specify all attributes of each entity. c. Specify the primary key of each entity. d. Specify all foreign keys e. Make sure all cardinalities or crow feet symbols are correctly specified f. How many strong and associative entities do you need