1 / 15

Database Project

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.

angelo
Télécharger la présentation

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. Database Project Angie Wells

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

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

  4. Table #1 Alumni Membership This main table houses the data for all alumni of the band.

  5. Table #2 Instruments This table shows the different instruments, each with its own identifier number, used by the band members.

  6. Table #3 Majors Each major held by individuals has been assigned a number as its unique identifier.

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

  8. Before & After Before: The current Ole Miss Band Alumni Page After: The Ole Miss Band Alumni Page with the new Find Alumni search feature.

  9. Mock-Up Search Feature Search for Band Alumni by Name, Hometown, Major or Instrument Name Hometown Major Instrument Search Alumni

  10. Query #1Alumni who played Flute To search for alumni who played flute in band

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

  12. Sample Search #1

  13. Query #2Alumni music majors and instrument To search for alumni music majors and what instrument they played.

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

  15. Sample Search #2

More Related