ls560 database project
Download
Skip this Video
Download Presentation
LS560 DATABASE PROJECT

Loading in 2 Seconds...

play fullscreen
1 / 11

LS560 DATABASE PROJECT - PowerPoint PPT Presentation


  • 96 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' LS560 DATABASE PROJECT' - lona


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ls560 database project

LS560 DATABASE PROJECT

Janet L. McCraw

current website
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.

problems
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

slide4

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

table 1
Table 1

School, grade level, curriculum, and address

table 2
Table 2

Grade level

table 3
Table 3

Curriculum

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

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

sql statement 1
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\'

sql statement 2
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\'

ad