I just need an ERD Diagram based on the following case with proper attributes and connection. You can also take the help of the ADEPT and DFD screenshot posted under the case for more detailed info.
CASE: Dominique’s Driving School
Dominique’s Driving School is a small local company that offers car, pickup truck and motorcycle driving classes to students. The company plans to expand and offer classes for large trucks next year. The company currently uses spreadsheets and contact lists to document much of its business data and transactions.
About six weeks before the start of each semester, Dominique compiles a ‘draft’ master class list that displays the classes that could be offered to students during the upcoming semester if he can find instructors to teach them. He uses ‘instructor courses taught’ information from the Instructor file, and class information from the Class datastore to develop this ‘draft’ master list. Once he has ‘fleshed out’ the ‘draft’ master class list, he emails each instructor on the Instructor file a copy, asking them if they would be interested in teaching any of the courses on the ‘draft’ class list proposed for the upcoming semester. Instructors have one week to respond. When he receives their response, Dominique updates the draft master Class list for the current semester.
Dominique only uses instructors who are under contract to the company. Each contract lasts for the duration of the semester. Each instructor who accepts will need to sign a new contract for each course taught for the upcoming semester. For each course the instructor agrees to teach this semester, Dominique sends a contract to be signed by the instructor who must return the signed contract to Dominique before the semester commences.
The master class list includes a description of each class, including the knowledge level of the student (i.e. beginner, intermediate, etc.), vehicle type to be used (E.g. car, motorcycle, truck, etc.), instructor name, course hours, pre-requisites, start time and start date of course, the day of week course will be held, and student cost for the course.
Information maintained for all driving instructors includes, but is not limited to: full name, mailing address, phone numbers – home, bus, res; Driver’s License number, email address, credentials, years of experience, courses taught.
Instructor contract information includes, but is not limited to: contract number, class id, contract date, course name and number, instructor availability [days of week and hours of day], and instructor contract fee.
Dominique emails the updated master Class list to all students in the Student database and to each driving instructor in the Instructor database who is scheduled to teach this coming semester. He also sends the Class list to community newspapers and updates the company’s website.
Currently, students either phone or come to the office to register for a scheduled driving class. A student must be in the database to register for any classes. Therefore, the clerk determines if the student is an existing student on the database. IF a new student, the student is added to the database before beginning the registration process. For existing students, the clerk updates student information, if necessary, before beginning the registration process.
When the registration process is completed, the clerk sends an electronic confirmation of registration to the student, prints an invoice for the student and invokes the system to send an electronic copy to Accounting. The student will receive one invoice for each course for which they register. The clerk directs the student to make payment directly to the Accounting department.
Some students pay their fees at the time of registration, by cheque, cash or credit card. However, most students pay their fees on the first day of classes. After the first day of class, students cannot attend class or reserve a vehicle until payment for the class has been received in full by Accounting.
Each week, until the semester commences, Dominique accesses the Master Class File to determine if there are enough student numbers in each class to run the class. Dominique cancels those classes with low attendance, notifies instructors and students of the cancellations, and informs these students that a refund, if applicable, will be sent in the mail. Dominique notifies Accounting about the cancelled classes and any refunds outstanding. Finally, he posts the updated Class list to the website and voids the instructor contract for that specific course.
Classes are held weekly. Some students register for more than one class in a semester if their schedule permits. For example, a student may take a Beginner Motorcycle on Mondays and Intermediate Car on Thursdays. If fewer than 6 students register for a class, the class is cancelled. Any fees paid by the students whose classes are cancelled are refunded by mail. The maximum class size is 14.
The company maintains a small inventory of vehicles that students may reserve if need be. Many students use their own vehicle, so the vehicle inventory is relatively small. All vehicles are reserved on a ‘first-come’ basis for the semester and remain reserved for that student for that day and time slot for the entire semester. Students must pay for the course in full before being eligible to reserve a vehicle.
To reserve a vehicle, the student must come to the office. The clerk ensures the student has paid in full before proceeding further. If there is an outstanding balance, the clerk directs the student to the Accounting department to pay in full before a vehicle can be registered for this student for this course. If there is no outstanding balance for the class, the vehicle reservation process begins. Each vehicle reservation is assigned a unique vehicle reservation number. The information included in the vehicle file includes, but is not limited to, the following fields: application date, student name, class name, vehicle type, Dominique’s Vehicle ID [DOM_V_ID], VIN, course start and end date, time of day, damage deposit amount, and last day of course.
A damage deposit is required for each vehicle reserved. When the reservation process is completed, the clerk forwards damage deposit information to Accounting; hands the student a completed vehicle reservation form that the student uses to begin the damage deposit process in the Accounting department. At this point the damage deposit status is given a value of ‘O’ for ‘outstanding’ until the student pays the damage deposit. A damage deposit must be paid in full before the student can use a vehicle. A vehicle list by course ID, section and semester, and student id is emailed to the instructor to inform him/her about which reserved vehicles are to be used for his/her course.