November 8, 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 (6.2.5) 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.
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 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.|
(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.|
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.
|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|
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.
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 it is your responsibility to schedule.
|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|
|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)|
|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|
|15||Tuesday||10-03||Mid-term exam||Advanced Practices Council|
|19||Tuesday||10-17||Spatial & Temporal data (11)|
|20||Thursday||10-19||Guest: Major-General Rajczak||Project #1|
|23||Tuesday||10-31||Organizational Intelligence (13) & Pivot Tables|
|27||Tuesday||11-14||Data structure and storage (19)||A7|
|28||Thursday||11-16||Data processing architectures (20)
|31||Tuesday||11-28||Data integrity (22)|