1- Browse a dynamic website. While browsing it, think about what the basic table structure, column names, and other database details that involve the page. DELIVERABLE: URL and name of website.Tip: smaller e-commerce pages might be easier to define.

2- Write out the Schema of what you think the database “underneath” the website looks like. Remember that a Schema is words, it shows the table name in all caps, the primary key in bold or underlined, and the foreign keys in italics. All other fields follow. DELIVERABLE: Schema in a TXT or DOC file

3- Using this schema, create an ERD diagram showing the database. DELIVERABLE: Schema as a JPG or other image file. DO NOT SEND me the ERD file, just an image of it.

4- Visit 5 pages/articles on the site, and then using your ERD diagram, write out what the SQL statement might be to generate that page. DELIVERABLE – URL of a page, and the SQL script for it.

Please turn in deliverable for each step as a Word Document, PDF, and/or image file.