Question: Draw an ER diagram and write a database outline for the scenario above. tive stu Central Jersey Adult Education: Central Jersey Adult Education (CJAE) s
Draw an ER diagram and write a database outline for the scenario above. tive stu Central Jersey Adult Education: Central Jersey Adult Education (CJAE) s a variety of night and weekend classes in cooking, exercise, stress management, gardening, art, and other popular topics at various loca- tions throughout central New Jersey. Each course CJAE offers is identified course code and has a name, description, tuition fee, and number of ourse meetings (some courses consist of just one meeting; others may consist of as many as ten meetings). Each course may be offered at multi- ple times and locations. Each time/location a course is offered is called a "class." For each class, your computer system must store its location, maximum number of students allowed, instructor, and date/time of first meeting. All CJAE classes with multiple meetings are held once per week, at 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 num- ber. For each instructor, you want to store a first name, last name, address by a
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
