1 / 15

Shannon Petty CCHS Database Project

Shannon Petty CCHS Database Project. Recommendations for improvement to the CCHS School Website for teacher use. Current Website.

lola
Download Presentation

Shannon Petty CCHS Database Project

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. Shannon PettyCCHS Database Project Recommendations for improvement to the CCHS School Website for teacher use

  2. Current Website The current CCHS website is used primarily by parents and students to keep up with school information. The website contains information regarding teachers, classes, events, sports, and contact information

  3. The problem…. • The current website provides a valuable service to the parents and students of CCHS, but not the teachers. Often there is information needed by a teacher, but there is not a way to access that information from the classroom. This includes other teacher’s room numbers, prep periods, lunch times, and years at CCHS. Since the website has already been created, this information could easily be added in a database for teacher use from their classrooms and homes.

  4. Recommendation • Add a database to the teacher section entitled “Teacher section” that has a database to allow teachers to find other teachers’ prep periods, lunch periods, room numbers, etc.

  5. Table 1 – Teacher Info

  6. Table 2 – Lunch Groups

  7. Table 3 – Even Preps

  8. Table 4 – Odd Prep

  9. Relationships

  10. Query 1 – Teacher Lunches by subject

  11. SQL 1 – Teacher lunch by subject • SELECT "Teacher Info"."Last Name", "Teacher Info"."First Name", "Lunch"."Lunch", "Teacher Info"."Subject" FROM "Teacher Info", "Lunch" WHERE "Teacher Info"."LunchID" = "Lunch"."LunchID"

  12. Query 2 – Teacher Prep by subject

  13. SQL2 – Teacher Prep by subject • SELECT "Teacher Info"."Last Name", "Teacher Info"."First Name", "Odd Prep"."Odd Prep", "Even Prep"."Even Prep", "Teacher Info"."Subject" FROM "Teacher Info", "Even Prep", "Odd Prep" WHERE "Teacher Info"."EvenID" = "Even Prep"."EvenID" AND "Teacher Info"."OddID" = "Odd Prep"."OddID"

  14. Query 3 – Teacher Prep by room number

  15. SQL3 – Teacher prep by room number • SELECT "Teacher Info"."Last Name", "Teacher Info"."Room ", "Even Prep"."Even Prep", "Odd Prep"."Odd Prep" FROM "Teacher Info", "Even Prep", "Odd Prep" WHERE "Teacher Info"."EvenID" = "Even Prep"."EvenID" AND "Teacher Info"."OddID" = "Odd Prep"."OddID"

More Related