a place for independent study

Wednesday, January 25, 2012

Library and Information Studies @ FIX University

LIS 533: Database Design for Information

Course Outline (Fall  )

Calendar Description

An introduction to core concepts, principles, and techniques of
database design for information management, from user requirement
analysis, to data and information modeling and querying.


At the completion of this course, the students will be able to:

  1. Explain features and strengths of database technology for
    information management;
  2. Elaborate on the importance of discovering and analyzing users’
    information management needs and requirements in developing database
  3. Apply database design methodologies and associated techniques to
    real world information management situations;
    • Use ER modeling in database design;
    • Use a particular relational DBMS to implement database

    • Use SQL for basic database queries and data manipulation;

    • Understand normalization;
  4. Explain key concepts of relational database model;
  5. Discuss contemporary issues in database design and management.


  • Database application lifecycle
  • User requirement analysis and fact-finding techniques
  • Entity-Relationship modeling
  • Developing relational models
  • Normalization
  • Defining relational databases with MS Access and SQL
  • Manipulating database content using Query-By-Example and SQL
  • XML and relational databases
  • Web technology and DBMSs


A combination of lectures, in-class discussions and exercises,
hands-on labs, group work, and computer demonstrations will be used
throughout this course.

Recording of lectures

Recording of lectures is permitted only with the prior written
of the professor or if recording is part of an approved accommodation

Required Text

Connolly, T.M. & Begg, C.E. (2010). Database
Systems: A Practical Approach to Design, Implementation and Management.
Addison Wesley Publishing Company, 5th edition. (4th edition

is also okay.)
You may also want to find a resource on MS Access.

Check the Resources page for
online resources on database technology.

Course Relationships

Elective course; Pre- or co-requisite: LIS 501

Inclusive Language & Equity

The Faculty of Education is committed to providing an environment of
equality and respect for all people within the university community,
and to educating faculty, staff, and students in developing teaching
and learning contexts that are welcoming to all. The Faculty recommends
that students and staff use inclusive language to create a classroom
atmosphere in which students’ experiences and views are treated with
equal respect and value in relation to their gender, racial background,
sexual orientation, and ethnic background. Students who require
accommodations in this course due to a disability affecting mobility,
vision, hearing, learning, or mental or physical health are advised to
discuss their needs with Specialized Support and Disability Services.


Assignments and Evaluation (Fall  1)

There will be no exams in this course. You will be assessed on your
participation in class activities and on your practical application of
the content covered. Below is a list of the specific assignments and
their weights. Due dates of these assignments are listed in your blog. 
  •   Class contribution (10 marks)
  •   Small assignments (10 marks each = 40 marks total;)

    • ER Modeling assignment

    • MS Access assignment

    • SQL assignment

    • Normalization assignment

  • Term Project (50 marks)
All assignments are due by 9:00am on the due date and must be
to the instructor’s mailbox except the database files which should be
compressed into a zip file and then the zip file submitted as an email
attachment. Extensions will only be granted with appropriate
documentation (e.g., a doctor’s note) in advance of an assignment’s due
date. Late assignments will be assessed a penalty of 10% of the
assignment value per day (i.e., if the assignment value is 10 marks,
the late penalty is 1 mark per day).
* Marks are raw scores that are totaled at the end of the course and
converted to the University of Alberta’s letter grading scale.

Class contribution

This represents individual contribution for the benefit of the
entire class, and is intended to encourage all students to actively
participate in the learning process. This includes (but is not limited
to): class discussion, small-group interaction, preparatory reading,
attendance, attitude, providing additional resources, etc. Comments,
criticism, and questions are expected to be relevant to the topic, to
reflect preparatory reading on the topic, and are expected to be
respectful of other students and the instructor. Anticipated absence
from class must be communicated to the instructor prior to the class.

At the end of the course, in class time, you will be given the
opportunity to submit a brief self-assessment of class contribution
which will be considered when assigning your class contribution marks.

Small assignments

These small assignments provide you with opportunities to practice
individual methods and techniques of database design and

    Term project

    This project is designed to give you an opportunity to apply database
    theory as well as design methodology and techniques to a real world
    You are required to create a database application for an
    (e.g. a library, a movie rental company, a law firm, a driving school,
    or a company that specializes in IT training). You will research how
    such an organization typically operates, and identify the part of the
    organization for which you are going to create a database application.
    You will then design and create this database application.

    LIS 533 - Database Design for Information

    Tentative Schedule (Fall )N/A

    Fridays 9:00 - 11:50pm, Rm. 3-01, Rutherford South

    September 9

    • Introduction
    • Readings: Chapter 1

    September 16

    • Database system development lifecycle; Database analysis

    • Readings:
      • Chapters 10 & 11
      • Appendix B: Examples of user requirement specification -

      September 23

      • Entity-Relationship (ER) modeling

      • Readings: Chapter 12

      • Assignment: ER modeling

      September 30

      • Entity-Relationship (ER) modeling - ctd.

      • Readings: Chapters 13 & 16

      October 7

      • The relational model; Develop relational models from ERDs

      • Readings: Chapters 4 & 17 (skip step 2.2)
      • Assignment due: ER modeling

      October 14

        • Defining and querying relational databases with MS Access
        • Readings:

        • Lab: MS Access tables and relationships

        • Assignment: MS Access

        October 21

        October 28

        • Manipulating database content using SQL

        • Readings:
        • Assignment: SQL
        • Assignment due: MS Access

        November 4

        • Manipulating database content using SQL - ctd.
        • Readings: Chapter 7 (focus on 7.3 & 7.4; scan the rest)
        • Assignment due: Term project topic must be approved by

        November 11

        No class - Remembrance Day;
        University Buildings closed.

        November 18

        • SQL - ctd.

        • Understanding normalization

        • Readings:
          • Chapter 14
          • Chapter 17 (focus on step 2.2)
          • Chapter 15 - optional

        November 25

        • Understanding normalization - ctd.

        • Assignment: Normalization
        • Assignment due: SQL

        December 2

        • XML and relational databases
        • Web technology and DBMSs; Issues and trends
        • Readings:
          • Chapters 30 & 31
          • Bourret, R. (2005). XML and
          • Chapters 20-23 (scan these chapters)
        • Optional readings:

          • Seligman,
            L. and Rosenthal, A. (2001). XML's impact on databases and data
            Computer, vol. 34, no. 6, pp. 59-67, June, 2001 -optional
          • Jung, F. (2000). XML
            backgrounder: technology and applications
            - optional
          • Tutorials on XML at w3schools.com - optional
          • Chapters 32 & 35 - optional
          • Tutorials on PHP at w3schools.com - optional
        • Assignment due: Normalization
        • Term project due: December 7



        Companion website for the text

        Tutorials on selected chapters, MS Access lab manual, DreamHome Web implementation, etc.

        Databases (General and History)

        • Databases at about.com
        • Basics and tutorials
        • Database
        • "This material is designed for students with little or no formal database education, training, or experience. The goal of this course is to prepare you to learn how to develop database applications using tools such as Microsoft Access, FoxPro, or Oracle."
        • Database Directory
        • "... a website devoted to the most popular Relational Database Management Systems like MS SQL Server, Oracle, DB2, MySQL, PostgreSQL, and MS Access." "... short reviews of each of these databases describing their features, application, scalability, performance," and "... various database related articles discussing topics like Data Warehousing, Data Mining, Text Mining, Database Development, SQL, Data Recovery and many more."
        • Database
          Scalability and Clustering
        • How Data Clustering Can Benefit Performance?
        • Database Security
        • "... the World's Leading Resource on Database Security"
        • Introduction
          to Data Modeling: Overview of the Relational Model
        • "This document is an informal introduction to data modeling using the Entity-Relationship (ER) approach. It is intended for someone who is familiar with relational databases but who has no experience in data modeling. The basic techniques described are applicable to the development of microcomputer based relational database applications as well as those who use relational database servers such as MS SQL Server or Oracle."
        • MS Access 2007
        • "This web site is dedicated to Microsoft Office Access 2007, providing lessons, articles, and links to assist you with creating wonderfully functional databases."
        • Wikipedia article
          on Databases
        • Vocabulary, History, and Models
        • Wikipedia
          article on Database Management Systems
        • Note: there are many other related Wikipedia articles: follow the above links and then "see also"


        No comments:

        Post a Comment


        Blog Archive

        Powered by Blogger.