Information Science for Bioinformatics
GNET 712, section 001, Fall 2007
Instructor: Dr. Hemminger

This planned schedule lists the assignments and readings for each of the topics we'll cover. The textbook for this course is Elmasri, R. & Navathe, S.. Fundamentals of Database Systems 4th edition (although you can manage with any of the 3-5 editions). Reading, MA: Addison-Wesley. Unless otherwise stated, the chapters listed in the schedule come from this book. All other readings are on reserve in the SILS Information and Technology Resource Center on the first floor of Manning Hall. Readings are listed in the order they should be read. Other readings or assignments may be assigned as appropriate.

.

 

Thursday
11/01

 Introduction Intro Notes  Entity Relation Modeling   Lecture Notes

Chapter 1
Chapter 10.1, 10.7-10.9 (pp. 324-325, 344-355)
Chapter 3
Chapter 4.1-4.7

Tuesday
11/06

Relational Model Lecture Notes , ER diagram Example1 , ER diagram Example1 , ER diagram to DDL Example , Assignment #1

Chapter 7
Chapter 9.1-9.2 (pp. 289-299)

 
Thursday
11/08

SQL Lecture Notes (assignment #2: express questions a,b,c,d,g,h in SQL from Exercise 7.18 on page 235 of the textbook edition 3 using the tables from that chapter)

Chapter 8, DDL exercise

Tuesday
11/13

 Assignment 1 is due. SQL practice, SQL practice with answers, Company Database in Access format

Thursday
11/15

 NO CLASS

Tuesday
11/20

 Assignment 2 is due. Database Lab. Assignment 3 assigned. (Assignment 3 database) Information Retrieval, Classification, Indexing, Searching

Thursday
11/22

 NO CLASS Thanksgiving

Tuesday
11/27

 Information Retrieval Lab: guest lecturer: Barrie Hayes of HSL. Assignment 3 is due. Assignment #4,

Thursday
11/29

 Digital Libraries, Standards, Scholarly Publishing, Open Access. Final Project assigned.

Tuesday
12/04

 Metadata, Ontologies, Wrap-up. Assignment #4 is due at the start of class. Final Project is due 12/07 4pm. In-class exercise

 

Return to the top of the page

This page was last modified on 2006-01-03 by Bradley Hemminger. Address questions and comments about this page to him at bmh@ils.unc.edu.
©2003 Bradley M. Hemminger