August 4, 2017
Class: Tues/Thurs 8:00 - 9:15 am Correll 214
Exam: 12/7 8:00 - 11:00
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.
Students completing this course will
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 for data modeling and SQL execution. Macintosh owners can also use Sequel Pro for SQL execution.
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).
Exploratory, a GUI for selected R packages.
Groups should contain three-four persons.
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.
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.
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.
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.
See the class schedule for the due date for all deliverables. The due time is 11:59pm on the due date.
|A1||Single Entity||Data modeling
Chapter 3, exercise 1d (abbreviated form is 3/1d)
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
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
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.|
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.
|Industrial Internet of things|
|Robotic process automation (RPA)|
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.
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.
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.
|State of the art report||10|
|Database design and implementation||15|
|Data analytics project||15|
|Mid semester exam||15|
|Final exam (sample)||25|
|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.|
|1||Tuesday||08-15||Data (1)||WASH laundromat mini-case
World's best job
|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|
|14||Thursday||09-28||SQL (10)||Project #1|
|15||Tuesday||10-03||Mid-term exam||Advanced Practices Council|
|17||Tuesday||10-10||Spatial & Temporal data (11)|
|20||Thursday||10-19||Organizational Intelligence (13) & Pivot Tables|
|26||Thursday||11-09||Data structure and storage (19)||A7|
|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|