Database Project
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

Database Project PowerPoint PPT Presentation


  • 120 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

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

Database Project

Angie Wells


Database project

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.


Database project

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


Database project

Table #1

Alumni Membership

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


Database project

Table #2

Instruments

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


Database project

Table #3

Majors

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


Database project

Relationships

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


Database project

Before & After

Before:

The current Ole Miss Band Alumni Page

After:

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


Database project

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'


Sample search 1

Sample Search #1


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


Sample search 2

Sample Search #2


  • Login