Database II

INLS 623, Fall 2014, section 001

INLS 623, Fall 2014, section 001
Monday and Wednesday, 11:00am - 12:15m, 208 Manning Hall
School of Information and Library Science


Instructor:  Dr. Bradley Hemminger Email:



966-2998 (office) 942-2273 (home)

206A Manning Hall

Office Hours:


Office Hours
and by appointment

Course Outline and Objectives
Class Policies and Grading
Class Notes 
Resources Wiki
Class Work Wiki

Course Outline and Objectives


  1. Introduction and Database Design
  2. SQL and MySQL
  3. Database Tuning and Indexing
  4. Database Application Development and Internet Applications
  5. Introduction to XML
  6. XML, Databases, and Information Retrieval
  7. Non Text Databases


  1. To review database design principles and SQL, and establish a solid understanding in these areas.
  2. To learn the basics of MySQL
  3. To gain familiarity with database tuning, and choosing how to design and implement databases in a network environment.
  4. To learn XLM. To become familiar with the capabilities and limitations of XML, XSL, databases, and information retrieval, and how these relate.
  5. To learn about and work with nontextual databases.

Class Policies and Grading

Class Policies and General Instructions

  1. I will always be prepared for class and will start class on time. If unforeseeable circumstances prevent this for any reason, I will try to notify you beforehand if at all possible. I expect the same of my students: be prepared for class, be ready to start class on time, and try to let me know by email if you can't be there.

  2. My classroom is intended to be a place where you are encouraged to share your thoughts, think critically, and feel safe in expressing your views. I always welcome your viewpoint, and will be respectful of your opinion. Similarly, I ask that you are respectiveful of your classmates.

  3. Class notes and most materials, as well as the class syllabus, policies, and schedule are available on the web (via the top of this page). The class notes are available so that you don't have to write down the basic information presented during class, hopefully allowing you to concentrate on the discussions and additional information presented in class.

  4. You are expected to bring your laptop to class. We will work problems during class (SQL, MySQL, XML) that require a computer. We will also search out information during class. I will also ask members of the class to share their work (or homework) from their computer on the projection screen.

  5. Assignments should be turned in at the start of the class on which they are due. In general Assignments should be printed out and handed in. In some cases, where the assignment may contain large sections of SQL code or XML code I will ask you to email it to me or place at public URL (in addition to printout). In all assignments/exercise, unless otherwise indicated, you should demonstrate that your SQL code works by showing the output from your MySQL run. All work, printed out, or emailed or on web, should be labeled on each page to show your name and what assignement/exercise it is, like jones-A3. Exercises are also generally due when listed, although sometimes I'll tell you that I'll collect them later than listed. Please make sure everything is correct before turning in, so that I receive one and only one correct version of the your homework.
  6. Late assignments. Any assignment received after the start of class when it is due, will be considered late. Late assignments can still be turned in for credit. They are penalized by the following formula: they are docked 5 points for each day they are late (not counting weekends). Each assignment is graded on a 100 point scale. Thus, an assignment due Wed at 11:00am and turned anytime between Wed at 11:01am and Thursday at 11:00am would be graded on the usual 100 point scale, and then have 5 points (one day late) deducted from the total.

  7. You are expected and encouraged to participate in discussions and exercises in class. I will ask students to explain portions of what was to be read in preparation for a class, as well as to come to the board to work exercises. Part of your grade will be determined by the quality of your participation and your willingness to participate.

  8. Add yourself to the Class Roster BEFORE the first class. I need this information (particularly your google account), so I can add you to the class work and resources wikis. You'll need access to do Exercise 1 in first class.

  9. Please be sure to subscribe to the class listserv. Click here to join the INLS 623 Class Listserv. On the form just fill in your email address; leave the other fields set to their defaults, then click Save to add yourself to the list. To send a message to the listserv, you send it to "", and it will be distributed to everyone in the class. Sign up for the 623 listserv immediately after the first class!

  10. You will be expected place your work in our class work wiki, which is open to the class (but no one else). Please try to post your wiki on the wiki 2 hours before class starts. This helps me review everyones work so I can give you fedback in class. We will learn MySQL in class, but you will be expected to learn a large part of it yourself outside of class. There are lots of references on the web. To get started read the MySQL tutorial . Please see the Resources section below for pointers to workshops and other materials for learning MySQL.

  11. You will be given MySQL accounts on Your account name and login will be db2_X where X is a number between 1 and 24. Your number can be found in our Class Work Wiki, under the "Class_MySQL_IDs" page. We will cover how to use it in class, and as well as in our MySQL Notes.

  12. Reading assignments should be done before the class for which they are assigned so you can ask questions and participate in discussions. The textbook is not light reading. You may find it easier to skim the reading before class and then read it again in more detail after we have discussed it. If you do this, do not skip the second reading.

  13. If there is something you don't understand, please ask about it! If you don't want to ask during class, you may ask me during office hours, come see me at some other time, post your question to the listserv, or ask me over email. Your classmates may well be your best resource for MySQL or XML questions.

  14. With the exception of group assignments (1 and 7), all assignments are to be completed individually. You are, however, encouraged to talk to one another about application issues of a general nature (for example, for questions like "How do I do <fill in the blank> in MySQL or XML?"). 

  15. Honor Code: The principles of academic honesty, integrity, and responsible citizenship govern the performance of all academic work and student conduct at the University as they have during the long life of this institution. Your acceptance of enrollment in the University presupposes a commitment to the principles embodied in the Code of Student Conduct and a respect for this most significant Carolina tradition. Your reward is in the practice of these principles. Your participation in this course comes with the expectation that your work will be completed in full observance of the Honor Code. Academic dishonesty in any form is unacceptable, because any breach in academic integrity, however small, strikes destructively at the University's life and work. (From the 8/1/1992 letter to the faculty, signed by Paul Hardin, Chancellor, and John Moody, Student Body President.)

  16. Resources: I make every attempt to use high quality, current, freely available resources for our class. This allows you to always have convenient access to a resource, and saves trees :-). There may be times that I utilize a resource or material from the SILS library or lab during the course of the semester. Please remember that many of your fellow students also need to use the same material. Follow the proper checkout procedures and return materials promptly to be a good SILS citizen.


Assignments: 56%

    A1    8%
    A2    8%
    A3    8%
    A4    8%   
    A5    8%
    A6    8%
    A7    8%

Exercises: 12%

There are 10 exercises (1-10). Each counts 1.2% of your grade. These are used to gauge your progress in class. Exercies completed well get FULL credit; those partially successfully completed receive a PARTIAL credit, and those not done well or not turned in receive NO credit.

Take-Home Final Exam:  28%
Class Participation   4%

All assignments and your final grade will be graded on the following scale:

A 95-100
P+ A- 90-94
P B 85-89
P- C 80-84
D 70-79
F F 69 and below


The INLS 623 Resources Wiki
is now used to maintain an ongoing collection of information about resources related to the INLS 623 class.


This page was last modified on July 20, 2014, by Bradley Hemminger. Address questions and comments about this page to him at
Bradley M. Hemminger