Download
info 330 n.
Skip this Video
Loading SlideShow in 5 Seconds..
INFO 330 PowerPoint Presentation

INFO 330

235 Vues Download Presentation
Télécharger la présentation

INFO 330

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

  1. INFO 330 Reverse Engineering Activity Introduction and Instructions

  2. Steps • Dissect the site • Name the areas • Analyze the info areas • Model the info types from the analysis of info areas • Implement the info types in an RDB • Model and implement the Navigation • Turn pages into templates

  3. What’s your RDB? • Choose one you know and like • Must make schema diagrams • Must use SQL querying

  4. From info model to data model There is lots or room for judgment • Type • The set of tables it takes to properly implement part of the model • All tied together by DB relationships • Item • One set of data in the tables that implement the model tied together by key values • Access structure • Implemented in one or more tables • Connects org structure to items

  5. Structures to be aware of and use post id title text • Primary table • Each entity will have one • Lookup table for • Single-value controlled vocabularies • 1  many relationships (post comment) postType id name post id title text typeId post id title text comment name text postId

  6. Structures to be aware of and use • Bridge table (no extra columns) • Many  Many • Bridge table (extra columns) post id title text tag id name text post_tag postId tagId comment postId memberId text dateTime post id title text member id name text

  7. Info model vs. Data model Post • title • dateTime • text Comment • name • date • image • email • site • Text (p)

  8. Inside the text field • For single para text – varchar • For multi para text • Can just save <cr> • Can use <p> tags • For rich text • Can use unparsed HTML • Can use parsed HTML (xHTML) • Can use XML

  9. XML

  10. Types in Databases Activity Snopes.com

  11. Turn your Snopesinfo model into a data model