Rick Watson
Skype: rtw30606
Class: Tues/Thurs 8:00 - 9:15 am Correll 214
Exam: 12/7 8:00 - 11:00

Course description

This course provides a basic understanding of information management in organizations and specifically the design and use of database systems. Topics include data modeling, relational databases, and structured query language. The course is divided into four sections: (1) information management concepts and procedures for Web-based systems; (2) data modeling and database design; (3) data analytics; (4) data management.

The syllabus is a general plan for the course; deviations announced to the class by the instructor may be necessary.

Prerequisites, corequisites



Students completing this course will

  1. understand the organizational issues involved in data management
  2. be able to develop a valid data model for a business system of medium complexity
  3. be able to build and use a relational database
  4. be able to formulate complex relational database queries
  5. be able to apply the principles of XML to data exchange and presentation
  6. be able to use a GUI for elementary data analytics
  7. be aware of the principles of cluster computing and big data
  8. be familiar with the principles of managing and exploiting organizational data


  1. The organizational perspective on data management
  2. Data modeling and SQL
  3. Relational DBMS
  4. Organizational intelligence technologies
  5. XML
  6. Data analysis
  7. Data structure and storage
  8. Data processing architectures
  9. Data integrity and data administration


Watson, R. T. (2013). Data management: databases and organizations (6th ed.). Athens, GA: eGreen Press. (text Web site).

Watson, Richard T., and others. 2006. XML: managing data exchange: Wikibooks.


MySQL Workbench (6.2.5) for data modeling and SQL execution. Macintosh owners can also use Sequel Pro for SQL execution.

MySQL database

  1. Laptop for individual assignments and exams
    MySQL Community Server

  2. Terry College server for SQL exercises
    Hostname:, Port: 3306,Username: student, Password: student, Default schema: Text

  3. Terry College server for group work.
    Hostname:, Port: 3306. You will get a group id and password.

Virtual Private Network (VPN)

When off campus, you must use a Virtual Private Network (VPN). See Remote Access VPN and install the Cisco AnyConnect app for your OS (scroll down the page to find details). You must run the AnyConnect app on your machine prior to accessing a UGA server.

You also need a device enrolled in ArchPass Duo, a two-factor authentication system, to access UGA servers. To enroll a mobile phone, landline or tablet in ArchPass Duo, use the ArchPass Duo Self-Service Portal on the EITS.


oXygen XML editor (30 day trial).

Data analytics

Exploratory, a GUI for selected R packages.

Group size

Groups should contain three-four persons.

Academic honesty

As a University of Georgia student, you have agreed to abide by the University's academic honesty policy, "A Culture of Honesty, " and the Student Honor Code. All academic work must meet the standards described in "A Culture of Honesty." Lack of knowledge of the academic honesty policy is not a reasonable explanation for a violation. Questions related to course assignments and the academic honesty policy should be directed to the instructor.

Team work

In this class, you will work in teams. As a result, review a short report on team effectiveness and establish a team agreement (sample agreement) for use by the team.

Laptop policy

Students are welcome to use laptops in class for note taking and completing class exercises, exclusively. If you plan to take notes, please advise and email a copy of the notes at the end of each class.


Attendance and participation are required for this course. Excessive unexcused absences (i.e., greater than 4) will result in a Drop or Withdrawal for Non-Attendance according to UGA policy.

Due date and time

See the class schedule for the due date for all deliverables. The due time is 11:59pm on the due date.


Identifier Chapter Exercise
A1 Single Entity Data modeling
Chapter 3, exercise 1d (abbreviated form is 3/1d)
SQL (ClassicModels)
Report those products with an MSRP greater than 150.
List the customers in Spain or Portugal in order by country first and name second.
A2 One-to-Many relationship Data modeling
Chapter 4/10
Report the total payments received for each country.
Who is the representative for firms with ‘kk’ in their names? Report the name of the firms as well.
A3 Many-to-Many relationship Data modeling
Report the value of each canceled order for each customer. Sort by customer name and order number.
Determine the product(s) with the highest markup, where markup is ((sell price - buy price)/buy price). Report the product(s), selling and buying prices, and the markup.
A4 One-to-One and Recursive Relationships Data modeling
Chapter 6/1f
Who reports to William Patterson?
Report those orders where the ship date is more than 10 days after the order date and report by customer. Indicate the number of days late.
A5 XML An art gallery wants to send details of its collection to other galleries. It has many exhibit halls, and each hall has many pieces of art. A piece of art can be a sculpture or painting. For each painting, it wants to record the title, artist, height and width in centimeters. For each sculpture, it records the title, artist, and height in centimeters. Develop an XML schema for this situation, and prepare a sample XML document with one hall containing two paintings and one sculpture. Submit the xsd and xml files to both dropbox and via email as both files will be validated.
A6 Normalize and report A file contains details of CO2 emissions per capita for the four largest economies in the Americas. Use Exploratory to read the file, convert it into a format suitable for use with R. (1) Report the average CO2 per capita for each country in descending order, and (2) prepare a bar chart showing the average CO2 per capita for each country.
A7 Visualize

(1) Use Exploratory to graph CO2 emissions per capita by year for each of the four countries in the prior exercise. Show separate lines for each country.

(2) Read the temperature data for Central Park, Compute the average temperature for each year, and create a scatter graph with a linear regression line.

A8 Report Using Delta’s performance data for February 2013, (1) compute the minimum, average, and maximum departure delay in minutes (DepDelayMinutes) for each origin airport; (2) create an ABC analysis for Delta showing the origin airports by average delay (top 10% A, next 25% B, and remaining C); and (3) create a bar chart showing origin airport and its rating for A and B categories.

State of the art presentations will be made commencing 8/29 (group) (there will be two per class).

A presentation is required from each group on a data management technology, with a particular concentration on open source products.

Some suggested topics are listed below (assigned topics have a date of presentation), and you can propose other topics. You should submit your bid for a topic via e-mail. When submitting a bid, also specify your team's name. Those who bid early present early.

Topic Group Date
3D printing Sophie Nolan, Katie Kish, Drew Gryder, Tarleton Woodson (2) 8/29
Autonomous vehicles Joe Duffey, Jordan Heath, Charley Gu, Ryan Depew (8) 9/7
Blockchain Gyutae Park, Josh Wallace, Jeff Xu, Trey Wood (3) 8/31
Cognitive computing Eli Shankman, Orrin Mitchell, Matthew Kinsman, Katie Hauldren (7) 9/7
Digital twinning Sona Bah, Alexandra Bonifay, Elizabeth Chambers, Megan Feight (6) 9/5
FinTech Evan Melioris, Adarsh Patel, John Hardin,  Holden Buckner (4) 8/31
Industrial Internet of things York Delloyd, Chad Clauson, Jackson Wall, Tristen George (5) 9/5
Robotic process automation (RPA) Vivek Balakrishnan, Conor Peterson, Emily Cardin, and Rayah Shaikh (10) 9/14
Sensor networks John Calhoun, Marcos Diaz, Trey Davis, Yirae Ryu (9) 9/14
Smart cities Ayman Khan, Devin Orrell, Joi Waldsmith, David Ajayi (1) 8/29
iBeacon William Bowen, Dennis Griffeth, Virgille Sonon (11) 9/19

Database design and implementation project #1 (group) Due 10/17

Cell phones have replaced landlines in many situations, except hotels, yet the guests of most hotels have a cell phone. Design the database for an app to replace a room's landline and the various paper documentation you find in a hotel room. Convert the data model to a relational database and write 10 queries to access the database. The queries should demonstrate your breadth of understanding of SQL (i.e., 10 simple queries will not score as well as say 4 simple queries and 6 nontrivial queries).

Follow the guidelines for database projects.

Data modeling is difficult and to facilitate learning an initial model must be submitted on 9/28.

Database design and implementation project #2 (group) Due 11/28

Develop a data model for an application of your choice. The problem must be at least of the same order of magnitude as for project #1. Please discuss your proposed project with the instructor before making substantial progress. You must file a brief written outline of the project's scope. You might find an examplar project and associated data useful for this assignment.

An initial model must be submitted on 11/21.

Follow the guidelines for project submissions.

Professional Development

Completion of the Arch Ready Professionalism Certificate (Requires attending five events offered by the UGA Career Center or the Terry College of Business).  

If you have potential conflicts with meeting the professional development requirements or if you think that there are better development activities for your situation, meet with your instructor to discuss the possibilities. This meeting must be at the start, and not the end, of the semester and it is your responsibility to schedule.


Item Points
Exercises 16
Professional Development 4
State of the art report 10
Database design and implementation 1 15
Database design and implementation 2 15
Mid semester exam 15
Final exam (sample) 25
Total 100
If you are unable to complete an exercise on time or take an exam at the specified time, please advise the instructor as soon as possible so that alternative arrangements can be made.


Class Day Date Chapter Assignments/Class exercises
1 Tuesday 08-15 Data (1) WASH laundromat mini-case
World's best job
2 Thursday 08-17 Information (2)  
3 Tuesday 08-22 Single Entity (3)  
4 Thursday 08-24 Single Entity (3)  
5 Tuesday 08-29 One-to-Many relationship (4) A1
6 Thursday 08-31 One-to-Many relationship (4)  
7 Tuesday 09-05 Many-to-Many relationship (5) A2
8 Thursday 09-07 Many-to-Many relationship (5)  
9 Tuesday 09-12 Recursive Relationships (6) (Carolina Salge) London shipping conference
10 Thursday 09-14 Recursive Relationships (6)  
11 Tuesday 09-19 Data modeling (7) A3
12 Thursday 09-21 Data modeling (7)  
13 Tuesday 09-26 SQL (10) Furniture purchase mini-case
14 Thursday 09-28 SQL (10) A4
15 Tuesday 10-03 Mid-term exam Advanced Practices Council
16 Thursday 10-05 Mid-term exam  
17 Tuesday 10-10 SQL (10)  
18 Thursday 10-12 SQL (10)  
19 Tuesday 10-17 Spatial & Temporal data (11)  
20 Thursday 10-19 Guest: Major-General Rajczak Project #1
21 Tuesday 10-24 XML (12)  
22 Thursday 10-26 XML  
23 Tuesday 10-31 Organizational Intelligence (13) & Pivot Tables  
24 Thursday 11-02 Exploratory A5
25 Tuesday 11-07 Exploratory  
26 Thursday 11-09 Exploratory A6
27 Tuesday 11-14 Data structure and storage (19) A7
28 Thursday 11-16 Data processing architectures (20)
Cluster computing
29 Tuesday 11-21 Thanksgiving  
30 Thursday 11-23 Thanksgiving  
31 Tuesday 11-28 Data integrity (22)  
32 Thursday 11-30 Review Project #2