Masters of Accounting MIST7601 Data Management

Revised: 16-Sep-2007

Instructor

Rick Watson	office: +1.706.542.3706
email: rwatson@terry.uga.edu	home: +1.706.546.8590 (no calls after 10pm)
skype: rtw30606	mobile: +1.706.201.1247

Class hours: Tuesday and Thursday 11:00 - 12:15 Aug 16 to Oct 9.

Subscribe to UGA-MIST7601

Email:

Visit this group

Academic honesty

Please be familiar with the University's academic honesty policy.

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).

Software

You can access MySQL via a browser or MySQL Query Browser, which you will need to install and configure (settings Hostname: mistsql.terry.uga.edu, Port: 3306, Default schema: text).

Your userid is first character of your first name and first six characters of your last name in lowercase (e.g., rwatson for Rick Watson).
Your password is the first three characters of your last name and last 4 digits of your id (e.g., wat9999 for watson 999-99-9999).
A database has been created for you. It is your last name (e.g., Watson).

• If your lastname is less than six characters, then the userid is correspondingly shorter.
• If your lastname has an apostophe, then it is ignored (e.g., O'Hara is treated as OHara)
• If your lastname has a hypen, then the first part is ignored (e.g., Smith-Jones is treated as Jones)

Problems

Database design (due 9/18) (Group project)

You have been asked to design a general ledger for a retailer. You are required to keep track of all transactions, including those with suppliers and customers.

SQL (due 9/27) (Individual project)

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

1. Draw the data model for the database (5 points).
2. 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. Who are the employees who have more than five direct reports?
   5. Report details of orders where the order price is less than the buy price.

XML (due 10/2) (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 10/4) (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 8/23 (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