1Principles of Information and Database Management198:336Week 7 – Mar 21Matthew StoneProject OverviewThree phases– Project Design– Database implementation– Web interface2Project OverviewTimeline – two week increments – For the rest of the semesterDesign – due April 4 – 2 weeks from todayDatabases – due April 18Interface – due May 2 (last day of class)Outline in More DetailDesign – Form teams of two (or maybe one or maybe three)– Find an application topic(either a sports team management ORsomething personally important to you)– Map out some application scenarios(illustrate what you want to do through specific examples)3Outline in More DetailDatabase implementation– Build ER diagram– Write SQL code to create database– Formulate, test and debug queriesthat will allow your application to carry out example scenariosOutline in More DetailWeb interface– Write code to access the database and show the results over the web–UsingJava serverlets and html orJava server pages orPHP…4Conceptual RoadmapSuppose you have this interface:Search by authorConceptual RoadmapThat corresponds to a browser program– It says you have a form to fill out– It gives another page on the server– When the form is filled out, that page gets called with the new dataA few lines of HTML– We’ll see more of this next week.5Conceptual RoadmapYou now have a request– Do a search by author, with author “rowling”– This is implemented by connecting to a DBMSposing an SQL requestvisualizing the resultsFor exampleHere you want to:– Open a connection to the books database– Construct a queryselect * from books where author=rowling• This is partly prewrittenselect * from books where author = ?• And partly assembled based on form data– Explore the resulting table6Conceptual RoadmapFinally, visualizing the table means– Looping over the returned results– Formatting a display in HTMLLaying things out in a tableDescribing individual elementsAdding links to additional scriptsSo you get something like thisSearch by authorRowlingHarry Potter and the Sorcerer’s StoneBuy it nowSee similar titlesHarry Potter and the Goblet of FireBuy it nowSee similar titlesMore