Database Project
Download
1 / 15

Database Project - PowerPoint PPT Presentation


  • 180 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


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

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

  • 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


Table #1

Alumni Membership

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


Table #2

Instruments

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


Table #3

Majors

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


Relationships

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


Before & After

Before:

The current Ole Miss Band Alumni Page

After:

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


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



ad