AFI Top Ten Database - PowerPoint PPT Presentation

serena-curry
afi top ten database n.
Skip this Video
Loading SlideShow in 5 Seconds..
AFI Top Ten Database PowerPoint Presentation
Download Presentation
AFI Top Ten Database

play fullscreen
1 / 6
Download Presentation
AFI Top Ten Database
70 Views
Download Presentation

AFI Top Ten Database

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. AFI Top Ten Database Ben English Emma Backman

  2. The Tables

  3. The Relationships

  4. Sample SQL Statements • SELECT * FROM [Purchasing Info] WHERE price < 15.99; • This SQL command string will return cheaper items from among the ten films listed. • SELECT * FROM Financials WHERE [Budget] > 2000000 • -This SQL command string will return all films with a budget in excess of two million dollars. • SELECT Title FROM [Title Info] WHERE [Runtime (minutes)] > 120 AND [Format for purchase] = ‘DVD’; • This SQL command string will return longer films (over two hours), and only those which are also on DVD. • UPDATE Financials SET Gross = 20000 WHERE ID=2; • This SQL command string will update (essentially rounding up) the listed gross amount for film number two – “City Lights”.

  5. Sample Report

  6. The Model