1 / 11

INFO 330

INFO 330. Reverse Engineering Activity Introduction and Instructions. 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.

rane
Download Presentation

INFO 330

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

More Related