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.
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.