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

Software/Tool Instructions

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.

 

How to Insert an Image in Word?

For some of the assignments and exercises, you need to put images into a Word document. Here are a few ways of inserting an image to a Word document.

  1. Inserting an image file into Word. If you have an image file (such as .png from ERDplus), follow the instructions here: Insert pictures in Office 2013 and Office 2016
  2. Capturing screen shots.
  3. Converting Powerpoint objects. You can copy objects from Powerpoint, and paste it into Word as an image. Here are the steps: How to Convert PowerPoint Objects to Word Pictures

Using ERDPlus to Creat Entity Relationship Diagrams (ERD)

We will use ERDPlus to create Entity Relationship diagrams (ERDs). It’s free, and easy to use.

Specifically, we will use the standalone version of ERDPlus (https://erdplus.com/#/standalone), which allows us to create an ERD within a browser.

This is a short YouTube tutorial on the site that shows you how to create a diagram, and export the diagram as an image which can be placed into a Word document.