1 / 13

Friendswood Driving school

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.

cheche
Télécharger la présentation

Friendswood Driving school

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Friendswood Driving school Group members: Bryan Parson Joe Miller

  2. Company History • Located in Friendswood 126 South Friendswood Drive • Built in 1982 • Certified through Texas Education Agency • For both teen and adult driver education

  3. 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

  4. 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

  5. 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

  6. Entities and Attributes

  7. Data Model

  8. 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)

  9. Relationships

  10. Student Form

  11. Instructor Form

  12. Graduating Status

  13. Certificates Recieved

More Related