Instructor

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

MIST2090

Objectives

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

Topics

  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

Text

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.

SQL

MySQL Workbench 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: wallaby.terry.uga.edu, Port: 3306,Username: student, Password: student, Default schema: Text

  3. Terry College server for group work.
    Hostname: wallaby.terry.uga.edu, 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.

XML

oXygen XML editor (30 day trial).

Data analytics

Exploratory, a GUI for selected R packages.

Group size

Groups should contain three-four persons.

Stress reduction policy

Emotional reactions to stressful situations can have profound consequences for all involved. In order to avoid such situations in this class, the following policies will apply:

While this policy might hinder the development of group skills and mastery of the class material, ultimately these are your responsibility. I will provide every opportunity for you to gain high level mastery.

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

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.

Exercises

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
SQL
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
5/8
SQL
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
SQL
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 a spreadsheet 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 and report the average CO2 per capita for each country in descending order.
A7 Visualize 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.
A8 Reporting Using Delta’s performance data for February 2013, compute the minimum, average, and maximum departure delay in minutes (DepDelayMinutes) for each origin airport.

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    
Autonomous vehicles    
Blockchain    
Cognitive computing    
Digital twinning    
FinTech    
Industrial Internet of things    
Robotic process automation (RPA)    
Sensor networks    
Smart cities    
iBeacon    

Database design and implementation project #1 (group) Due 9/28

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/21.

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 is your responsibility to schedule.

Grading

Item Points
Exercises 16
Professional Development 4
State of the art report 10
Database design and implementation 15
Data analytics project 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.

Schedule

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) A3
11 Tuesday 09-19 Data modeling (7) Furniture purchase mini-case
12 Thursday 09-21 Data modeling (7) A4
13 Tuesday 09-26 SQL (10)  
14 Thursday 09-28 SQL (10) Project #1
15 Tuesday 10-03 Mid-term exam Advanced Practices Council
16 Thursday 10-05 Mid-term exam  
17 Tuesday 10-10 Spatial & Temporal data (11)  
18 Thursday 10-12 XML (12)  
19 Tuesday 10-17 XML  
20 Thursday 10-19 Organizational Intelligence (13) & Pivot Tables  
21 Tuesday 10-24 Exploratory A5
22 Thursday 10-26 Exploratory  
23 Tuesday 10-31 Exploratory A6
24 Thursday 11-02 Exploratory  
25 Tuesday 11-07 Cluster computing  
26 Thursday 11-09 Data structure and storage (19) A7
27 Tuesday 11-14 Thanksgiving  
28 Thursday 11-16 Thanksgiving  
29 Tuesday 11-21 Data structure and storage (19)  
30 Thursday 11-23 Data processing architectures (20) A8
31 Tuesday 11-28 Data integrity (22) Project #2
32 Thursday 11-30 Review