Masters of Accounting MIST7601 Data Management

Revised: 02-Nov-2011

Instructor

Rick Watson	voice: +1.706.621.6182
email: rwatson@terry.uga.edu	skype: rtw30606

Class: Tuesday and Thursday 2:00 - 3:15 Oct 11 to Dec 1 in Sanford 313

Exam: Thursday Dec 8 3:30 - 6:30pm

Subscribe to UGA-MIST7601-Fall2011

Email:

Visit this group

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 marketing research project of medium complexity;
3. be able to build and use a relational database;
4. be able to formulate complex relational database queries for accounting questions;
5. be able to apply technology used to manage and exploit organizational intelligence;
6. be able to apply the principles of XML to data exchange and presentation;
7. be able to use technology for data mining.

Topics

1. The organizational perspective on data management
2. Data modeling and SQL
3. Relational DBMS
4. Data storage devices
5. Organizational intelligence technology
6. XML
7. Data mining

Text

Watson, Richard T. 2006. Data management: databases and organizations. 5th ed. New York, NY: John Wiley. (text Web site).

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

Software

We will use MySQL Workbench (tutorial) for data modeling and SQL execution. Macintosh owners can also use Sequel Pro for browsing.

MySQL database

1. Laptop for individual assignments and exams
   MySQL Community Server.
   
   
2. Terry College server for group work.
   Hostname: mistsql.terry.uga.edu, Port: 3306,Username: student, Password: student, Default schema: Text
   You will get a group id and password.

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). Give the instructor a copy of your team agreement by the end of the second week of classes.

Freeloader policy

It occasionally happens in class and enterprise settings that someone in a group is not prepared to do his/her share. In the case of my classes, I recommend that the team give the freeloader one warning and then fire that person from the team. That person will then do group assignments individually or find another team to join. The team should notify me of the change in team composition immediately. I distribute a form to assess team participation at the end of the semester. If a major disparity in team contribution is reported, I will adjust team project grades.

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.

Problems

Database design (due 11/3) (Group project)

A group of researchers has decided to create a database of letters to the shareholder written by company leaders (e.g., CEOs) of firms who were in the FT500 any time during the last 15 years. Design a database to store these letters and relevant financial and other data. Set up the database and store details for five letters, with three from the same company and two from different companies.

SQL (due 11/10) (Individual project)

ClassicModels, a fictitious company, has given you access to its database (available online as ClassicModels). You have been given the following tasks

Answer the following queries using SQL (2 points each).

1. Report total payments by customer name
2. Report sales by year (hint: use the year function)
3. Report details of sales representatives of customers from whom no payments have been received.
4. Report the sales by month for 2004 in month order?
5. How many different customers does Classic Models have?

XML (due 11/17) (Group project)

Create an XML file containing three records describing a company's general ledger. Download a trial version of Oxygen and use it for creating a general ledger data schema and XML file.

OLAP (due 11/29) (Group project)

A tractor manufacturer has introduced a range of third-party implements that it sells through its North American dealer network and via the Web. The credit arm of the tractor manufacturer finances some of the sales and sometimes the customers use other means. What variable and identifier dimensions would you want reported?

State of the art report presentations will be made commencing 10/18 (there will be 2 per class).

A presentation is required from each group on the current state and future direction of a data management technology or product. You will give a 10 minute class presentation. Points will be deducted for exceeding 10 minutes. In each case, you must discuss the linkage to market research. Some suggested topics are (assigned topics are blue and have a date of presentation). You should submit your bid for a topic via e-mail. Those who bid early present early.

Grading

Schedule