AnnouncementsNotational NoteSlide 3Slide 4Slide 5Slide 6Possible ERD for Epidemiological DatabaseSlide 8Progress Report (design document)LAMP ProjectsExampleExample 2Tips for LAMP projectsMenu ProjectsAnnouncements•Progress Reports (mini design document) due Tuesday Dec 4 in class. It will be graded and count to the final grade of the project.•Homework 3 due next Friday•Next week advanced topics: Chapters 15, 17-19, 28-29•Textbook lab files at ~joebock/Courses/557/EN_lab•Data for populating databases is in there.Notational NoteSRELTSRELT1NCardinality Ratio Notation“Each entity of S can be related to any number of entities of T. An entity of T can be related to 1 (or zero) entities of S.”(0,N)(0,1)Participation Notation“Each entity is S participates in the relation either zero of one times”patientID nameb_datesexHLAHLA_AHLA_BHLA_Cisolateinfectiondateseverity(1,1)(0,N)drugsGene sequenceReactivitytest(0,M)(0,N)Test resultPossible ERD for Epidemiological DatabaseProgress Report (design document)•All Progress Reports Should Contain:–Names of all group members–Project title–A one paragraph overview of the project–Schema diagram of database (follow book conventions for key and foreign key constraints). If you must, this can be hand drawn, but why not use software (eg, xfig, adobe illustrator, or visio. Also powerpoint works just fine for a project of this scale)?LAMP Projects•For each webpage list:–Relative URL –Title of page–One sentence description of the page–Inputs (eg, GET parameters)–HTML Overview–English descriptions of SQL statementsExampleTitle: Roster for <team>URL: /roster.phpDescription: Display roster of players for a single teamInputs: teamID - the ID of the team whose roster is to be shownHTML overview: the primary content of the page is a table containing first name, last name, position and # of games played for each player on team. First and last name are links to stats.php. Include navigation links at top of page SQL statements: 1) select statement on teams table to retrieve full name of tea2) Select statement on event and player tables to retrieve info on all players that played for that team.Example 2Title: Season Statistics for <player name>URL: /stats.phpDescription: Display the season statistics for a single playerInputs: playerID: the ID of the player whose statistics are to be displayedHTML overview: display statistics info. The only links are navigations back to the main pageSQL statements: 1) select statement to retrieve name and position of player. Name is used in page title. 2) Select statement to retrieve stats (either pitching or hitting)Tips for LAMP projects•Write code to authenticate w/ the DB once–Without persistence, you’ll need to use authenticate with the DB each time a page is requested, but you should use the same code to do this.–You may want to code up a DB object•See require() or include() PHP commands•Write functions for re-used HTML elementsMenu Projects•For each menu, list–All menu options–Brief description of what option does including English description of SQL
View Full Document
Unlocking...