Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm

Jing Gong

Jing Gong joins the Fox School on a tenure-track appointment from Carnegie Mellon University, where she studied for a PhD in Information Systems and Management. She is interested in using empirical models to analyze firm and consumer behavior in online markets, with primary focuses in electronic commerce, digital marketing, two-sided online markets, online labor markets, and business analytics. Her research uses interdisciplinary approaches such as econometrics, Bayesian statistics, economic structural modeling, field experiment, and text analytics. Jing’s work has appeared in several major conferences and workshops including International Conference on Information Systems (ICIS), Workshop on Information Systems Economics (WISE), Conference on Information Systems and Technology (CIST), Marketing Science Conference, and China Summer Workshop on Information Management (CSWIM). She was the 2014 recipient of the Best Student Paper Award at the Conference of Information Systems and Technology and the 2014 Best Paper Award runner-up, at the China Summer Workshop on Information Management. Jing holds a Bachelor's Degree in Information Management and Information Systems from Tsinghua University in Beijing, China.

Agenda for Week 5 (Week of 9/25)

Class Schedule:

  • Monday — We will wrap up ICA #4 – SQL Pen and Paper Query Exercise and start the slide deck SQL 1: Advanced Queries.
  • Wednesday — We will work on ICA #5 – SQL Part 1 (using MySQL Workbench).
  • Friday — We will work on a new module: SQL Part 2 – Putting information into a database.

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • Assignments
    • Bonus Assignment – Converting ERDs to Schemas: Monday 9/25.
    • Assignment #2 – SQL Part 1: Monday, 10/2
  • ICAs:
    • ICA #4 – SQL Pen and Paper Query Exercise: Monday, 9/25.
    • ICA #5 – SQL Part 1 (using MySQL Workbench): Friday, 9/29.

I also want to share this MySQL joke with you, just for fun:








Companies Using MySQL

You might be interested to know how popular MySQL is in the real world. What companies are running MySQL? Well, the list is quite long (see a complete list of companies using MySQL here), but here are some examples.

  • E-Commerce: Amazon, Airbnb, Alibaba,, craigslist, ebay, Google, Groupon, Uber, Yahoo
  • Telecom: Alcatel-Lucent, AT&T Wireless, Comcast, Verizon Wireless
  • Technology: Apple, Cisco, Dell, Hewlett-Packard, Intel, NEC, Symantec, Xerox
  • Web/Social: Facebook, LinkedIn, Twitter, Pinterest, Quora, Wikipedia, Yelp
  • Media/Entertainment: NBCUniversal, New York Times, Youtube
  • Retail: Sears, Walmart, Spirit, Macy’s West
  • Travel/Airlines: Continental Airlines, Virgin America, KAYAK, Orbitz

Bonus Assignment: Creating Schemas (Optional, Due Monday, Sep 25, 11:59 pm)

There is a bonus assignment about creating schemas. It is optional. This is worth an additional 1% toward your final grade, if you choose to do it.

Here are the instructions: Bonus Assignment – Creating Schemas

It is due Monday, Sep 25, 11:59 pm. Submit your solution as a word or PDF document through Blackboard > Assignment Submissions before deadline.

As this assignment is for extra credit, I will not be accepting late submissions.

Agenda for Week 4 (Week of 9/18)

Dear all,

Below is the agenda for Week 4.

Class Schedule:

  • Monday — We will work on In-Class Activity (ICA) #3 – Converting ERDs to schemas. It is due by Wednesday (9/20).
  • Wednesday — We will start a new module  –  “SQL 1: Getting data out of a database.”
    • Make sure that you have MySQL Workbench installed on your own computer;
    • Also, review the supplementary slides “MySQL and Workbench” on your own, before class.
  • Friday — We will work on ICA #4 (SQL Pen and Paper Query Exercise). It is due by Monday, 9/25.

Deadlines (unless otherwise mentioned, the due time is 11:59 pm):

  • Assignments
    • Assignment #1 – ER Modeling: Monday, 9/18.
    • I will post a bonus assignment on converting ERDs to Schemas, it will be due on Monday 9/25.
  • ICAs:
    • ICA #3 – Converting ERDs to schemas: Wednesday, 9/20.
    • ICA #4 – SQL Pen and Paper Query Exercise: Monday, 9/25.


Setting up MySQL Workbench by September 20

We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around September 20, 2017.

(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;

If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.

You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to setup your software and connection.

(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Grade Center of Blackboard.


Nathan’s office hour for Assignment #1

Our ITA, Nathan Pham (, will hold office hour to answers questions about the assignment or anything about the class.

Below is the location/time info.

  • Location: Breakout room Alter 236B
  • Time: Saturday (Sept 16, 2017) from 2:00 – 3:30 pm

As usually, my regular office hours are on Mondays/Wednesdays between 3:00-4:00 in SP 201C. Also feel free to make an appointment with me if you cannot make it to my regular office hours.

Agenda for Week 3 (Week of 9/11)

Dear all,

Below is the agenda for Week 3.

Class Schedule:

  • Monday — We will finish up entity relationship diagrams and work on In-Class Activity (ICA) #2 – ER Modeling. It is due by Wednesday (9/13) at 11:59 pm.
  • Wednesday — We will talk about the last component of relational data modeling — that is, how to convert an ERD to a “Database Schema.”
  • Friday — We will work on In-Class Activity (ICA) #3 – Converting ERDs to schemas. It is due by Monday (9/18) at 11:59 pm.


  • ICA #2 – ER Modeling: due by Wednesday, 9/13, at 11:59 pm.
  • ICA #3 – Converting ERDs to schemas: due by Monday, 9/18, at 11:59 pm.
  • Assignment #1 – ER Modeling: due by Monday, 9/18, at 11:59 pm.