Reference no: EM132241492

Central Jersey Adult Education: Central Jersey Adult Education (CJAE) runs a variety of night and weekend classes in cooking, exercise, stress management, gardening, art, and other popular topics at various locations throughout central New Jersey. Each course CJAE offers is identified by a course code and has a name, description, tuition fee, and the number of course meetings (some courses consist of just one meeting; others may consist of as many as ten meetings). Each course may be offered at multiple times and locations. Each time/location a course is offered is called a “class.” For each class, your computer system must store its location, the maximum number of students allowed, instructor, and date/time of the first meeting. All CJAE classes with multiple meetings are held once per week, on the same day of the week and time of day as the first meeting. For each location, you want to store a name, address information, and phone number. For each instructor, you want to store the first name, last name, address information, phone number, mobile phone number, and e-mail address. Each class has only one instructor, but instructors can teach more than one class. Students can enroll in more than one class, including classes that are offerings of the same course. For example, somebody might take “pottery studio” several times over the span of a year. However, it makes no sense for a student to enroll more than once in the same class. For each student, your system should store the first name, last name, address information, phone number, mobile phone number, and e-mail address. Students do not receive grades or college credits for CJAE’s courses. Assume that you do have access to a zip code table. Draw an ER diagram, and write a database design outline. (You may add “ID” fields wherever necessary)