130 likes | 166 Views
Established in 1982, Friendswood Driving School offers certified driver education services for teens and adults in Friendswood, Texas. From classroom instruction to behind-the-wheel training, our programs include drug and alcohol awareness for discounted insurance rates. Our data-driven approach allows us to track student progress and customize learning experiences. Join our safe driving community today!
E N D
Friendswood Driving school Group members: Bryan Parson Joe Miller
Company History • Located in Friendswood 126 South Friendswood Drive • Built in 1982 • Certified through Texas Education Agency • For both teen and adult driver education
Services • Drug and alcohol awareness programs for discounted insurance rates • Teen Program • 32 hours of classroom instruction • 14 hours of driving • Adult Program • 6 hours of driving instruction delivered in two hour blocks
Need for Automation • Need to have database for • Miles driven each session • If student is adult or teen • Which car they drove in • How many hours of lecture class attended • How many hours of driving time accumulated • If driving permit been attained
Reports • Students who still need more classroom hours • Divide students into groups with and without permits • Adult and Teen program • How far along each student is compared to others • Who is ready to graduate • What students have driven the furthest
Physical Design • Students (Student ID, Last Name, First Name, Graduated, Permit) • Classes (Class ID, Classroom, Type, Instructor ID) • Class Schedule (Class ID, Student ID) • Driving Lesson (Driving Lesson ID, Schedule, Instructor ID, Car ID) • Driving Lesson Schedule (Driving Lesson ID, Student ID) • Instructor (Instructor ID, Last Name, First Name) • Car (Car ID, Make, Model, Mileage) • Certificate (Certificate ID, Name, Type) • Completed Certificate (Certificate ID, Student ID)