• Course syllabus (.pdf)
• Introduction to course project (.pdf)

• Introduction to Databases (.ppt)
• Examples of past projects:
  1. Construction tool tracking
  2. Recycled materials in highway construction
  3. Automobile commuters to the Berkeley campus
  4. Library for CH2MHill
  5. Construction software DB
  6. Concrete construction company's previous projects
  7. Project management library

• Current Student Teams:
  1. TEAM 1: Arman Shehabi, Tyler Williams, Mark Chang, Pedro Vieira: DB of Green Buildings and LEED Certification at UC Berkeley
  2. TEAM 2: Sara Garrett, Jeff Coon, Eric Wu: UC Berkeley Textbook Sharing Database
  3. TEAM 3: Andrew Campbell, Long Duy Nguyen, Martin Chandrawinata, Edwin Limanto: Toxic Risk Research Engine
  4. TEAM 4: Zofia Rybkowski, Nishil Bali, Justin Chen, Tai-Lin Huang: Graphic Illustration and Description of First LEED-certified Building on Berkeley Campus
  5. TEAM 5: Lauren Kuntz, Miriam Son, Cameron Pinkerton, Manish Dalia: ASCE Membership and Events DB
  6. TEAM 6: David Rosenberg, Tarun Singh: Middle East Water Resource Management
  7. TEAM 7: Dwito Hindharto, Gletwin Shanahan, Indra Wong: Hotel Management DB

• Database Design (.ppt)
• Student grades DB design example (.pdf)

Homework 1 (due September 30, 5:00 PM): Determine the data objects/entities, attributes, types, and dependencies, and create a dependency diagram and resulting tables for a database for a bookseller client who has the following requirements: "I would like my customers to be able to browse my catalog of books and place orders over the Internet. Currently, I take orders over the phone. I have my mostly corporate customers who call me and give me the ISBN number of a book and a quantity. I then prepare a shipment that contains the books they have ordered. If I don't have enough copies in stock, I order additional copies and delay the shipment until the new copies arrive; I want to ship a customer's entire order together. My catalog includes all the books I sell. Most of my customers are regulars, and I have records with their name, address, and credit card number. New customers have to call me first and establish an account before they can use my web site. On my new web site, customers should first identify themselves by their unique customer identification number. Then they should be able to browse my catalog and to place orders online."

Homework 2 (due October 7, 5:00 PM): Determine the data objects/entities, attributes, types, and dependencies, and create a dependency diagram and resulting tables (on paper) FOR YOUR PROJECT!

• Bridge DB design example (.ppt)
• Answering questions about database design examples

• Normalization (.ppt)
• Implementing tables in MS Access
• Structured Query Language (.ppt)

• SQL 2 (.ppt)
• Example queries (.doc)

Homework 3 (due October 21, 5:00 PM): Generate SQL statements for your project using the following:

• (SUM or MIN or MAX or AVG) + WHERE clause
• COUNT
• GROUP BY
• ORDER BY
• TOP [PERCENT]
• Make Table Query (INTO clause)

• Using the CE169 MySql Server (.ppt)
• Example web pages and source code
• How to port tables between MS Access and the CE169 MySql Server
• For PHP information, see the Oct. 12th notes for CE 169A

• Also: compacting DB, security, replication, getting external data/exporting

• Arman Shehabi, Mark Chang, Pedro Vieira, Tyler Williams: DB of Green Buildings and LEED Certification at UC Berkeley
• Andrew Campbell, Long Duy Nguyen, Martin Chandrawinata, Edwin Limanto: Toxic Risk Research Engine
• Lauren Kuntz, Miriam Son, Cameron Pinkerton, Manish Dalia: ASCE Membership and Events DB

• Sara Garrett, Jeff Coon, Eric Wu: UC Berkeley Textbook Sharing Database
• Zofia Rybkowski, Nishil Bali, Justin Chen, Tai-Lin Huang: Graphic Illustration and Description of First LEED-certified Building on Berkeley Campus
• David Rosenberg, Tarun Singh: Middle East Water Resource Management
• Dwito Hindharto, Gletwin Shanahan, Indra Wong: Hotel Management DB