1 / 11

LS560 DATABASE PROJECT

LS560 DATABASE PROJECT. Janet L. McCraw. CURRENT WEBSITE.

lona
Télécharger la présentation

LS560 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. LS560 DATABASE PROJECT Janet L. McCraw

  2. CURRENT WEBSITE The optional schools page for the Memphis City Schools provides a scrollable listing of 44 optional schools arranged alphabetically by school name. Each school listing includes the type of curriculum offered by that school and the grade level taught by that school. The user can also click an individual school listing to view its address, which appears in a separate window.

  3. PROBLEMS • The scrollable list of optional schools does not provide a search option for the user to find schools by curriculum • This list also does not provide a search option for the user to find schools by grade level

  4. RECOMMENDATIONS Create a relational database that will allow users to retrieve a list of optional schools for the following criteria: • Curriculum offered • Grade level included

  5. Table 1 School, grade level, curriculum, and address

  6. Table 2 Grade level

  7. Table 3 Curriculum

  8. Relationships The diagram to the right depicts the relationships between the Name and Grade Level tables and between the Name and Grade Level and Curriculum tables.

  9. Solution Provide a search box on the optional schools home page to allow users to search for a school by curriculum or by grade level.

  10. SQL Statement #1 Retrieve a list of optional schools by grade level 1-5 with the following statement: SELECT "Name and Grade Level"."School", "Curriculum"."Curriculum", "Grade Level"."GradeLevel" FROM "Name and Grade Level", "Grade Level", "Curriculum" WHERE "Name and Grade Level"."GradeID" = "Grade Level"."GradeID" AND "Name and Grade Level"."CurriculumID" = "Curriculum"."CurriculumID" AND "Grade Level"."GradeLevel" = '1-5'

  11. SQL Statement #2 Retrieve a list of optional schools by grade level 9-12 and Curriculum of Creative and Performing Arts with the following statement: SELECT "Name and Grade Level"."School", "Curriculum"."Curriculum", "Grade Level"."GradeLevel" FROM "Name and Grade Level", "Grade Level", "Curriculum" WHERE "Name and Grade Level"."GradeID" = "Grade Level"."GradeID" AND "Name and Grade Level"."CurriculumID" = "Curriculum"."CurriculumID" AND "Curriculum"."Curriculum" = 'Creative and Performing Arts' AND "Grade Level"."GradeLevel" = '9-12'

More Related