slide1 n.
Download
Skip this Video
Download Presentation
Database Project

Loading in 2 Seconds...

play fullscreen
1 / 15

Database Project - PowerPoint PPT Presentation


  • 186 Views
  • Uploaded on

Database Project. Angie Wells. Current Website The Ole Miss Band Website has an alumni page, but doesn’t list any alumni. The only way to check alumni is through the Ole Miss Band Alumni Facebook page, and there are very few members. Recommendations.

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 'Database Project' - angelo


Download Now 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
slide1

Database Project

Angie Wells

slide2

Current Website

The Ole Miss Band Website has an alumni page, but doesn’t list any alumni. The only way to check alumni is through the Ole Miss Band Alumni Facebook page, and there are very few members.

slide3

Recommendations

  • Create a relational database that allows alumni to search the following criteria about Ole Miss Band Alumni:
  • By name
  • By Instrument
  • By Hometown
  • By Major
slide4

Table #1

Alumni Membership

This main table houses the data for all alumni of the band.

slide5

Table #2

Instruments

This table shows the different instruments, each with its own identifier number, used by the band members.

slide6

Table #3

Majors

Each major held by individuals has been assigned a number as its unique identifier.

slide7

Relationships

The main table, Alumni Membership, is linked to the other two tables, Instruments and Majors.

slide8

Before & After

Before:

The current Ole Miss Band Alumni Page

After:

The Ole Miss Band Alumni Page with the new Find Alumni search feature.

slide9

Mock-Up Search Feature

Search for Band Alumni by Name, Hometown, Major or Instrument

Name

Hometown

Major

Instrument

Search Alumni

query 1 alumni who played flute
Query #1Alumni who played Flute

To search for alumni who played flute in band

sql statement 1
SQL Statement #1

SELECT "Members"."FirstName" AS "First Name", "Members"."LastName" AS "Last Name" FROM "Members", "Instrument"

WHERE"Members"."Instrument" = "Instrument"."ID"

AND"Instrument"."Instrument" = 'Flute'

query 2 alumni music majors and instrument
Query #2Alumni music majors and instrument

To search for alumni music majors and what instrument they played.

sql statement 2
SQL Statement #2

SELECT "Members"."FirstName" AS "First Name", "Members"."LastName" AS "Last Name", "Instrument"."Instrument" AS "Instrument" FROM "Members", "Instrument", "Major“

WHERE "Members"."Instrument" = "Instrument"."ID"

AND"Members"."Major" = "Major"."MajorID" AND "Major"."MajorID" = 2

ORDER BY "Last Name" ASC