Key Dates and Requirements

These are the key times when you absolutely should not miss class.

Welcome to BIT320!

The critical dates for this class are as follows:

• September 8, 2005: Lab meeting to start the BIT320 Remix Engine (36% of grade)
• September 29, 2005: Visit from John Nardini, Senior VP of Marketing, Denali Flavors.
• October 25, 2005: Mid-term Quiz (10% of grade)
• November 1, 2005: Project 1 Due (27% of grade)
• December 8, 2005: Project 2 Class Presentations
• Project 2 final due day of final at 5 PM (27% of grade)

Please let me know as soon as possible if there are any special circumstances that might impact your ability to participate in this class. You may have a disability, in which case we will work with the Office of Services for Students with Disabilities to find an accommodation.

Bud last edited this October 9, 2005 | Permalink | Comments (0) | TrackBack (0)

Introduction to BIT320 2005

Who I am. What you’ll go through. What class is generally about. What kind of assignments we’ll have. How you’ll be graded.

Topics: Remixing

In Class

1. Overheads for introduction
2. Read this article on remix culture. What is it? Is it hard to do? Would you yourself do it? Should companies let users do it?
3. Read this article on web mash-ups. What is a web mash-up? Is it hard to do? Why is business week writing about it?
4. Overall, do you think remixing and mash-ups are worth following? Why?

After Class

1. Go to bloglines.com. This site contains a web-based rss feed reader. Sign up for a bloglines account if you do not have one. It is free, and we will use it in class. Once, you have a bloglines account, add the class announcements page, BIT320 Announcements, and the class syllabus page, BIT320 Syllabus, using the buttons I provide.
2. Obtain a pubsub account.
3. Obtain a technorati account.

Bud last edited this August 31, 2005 | Permalink | Comments (0) | TrackBack (0)

Creating the BIT320 Remix (lab)

Launch the BIT320 Remix Site: SQL, XML, and Ice Cream. Learn about the technologies we will use in this class. Lots of little things to do here. Just get them done, and you will be well launched.

Topics: Remixing

Before Class

1. Go to bloglines.com. This site contains a web-based rss feed reader. Sign up for a bloglines account if you do not have one. It is free, and we will use it in class. Once, you have a bloglines account, add the class announcements page, BIT320 Announcements, and the class syllabus page, BIT320 Syllabus, using the buttons I provide.
2. Obtain a pubsub account.
3. Obtain a technorati account.

In Class

1. Read about how to best contribute to the remix engine.
2. Create a del.icio.us account.
3. Create a blog account.

After Class

1. Normalization (Chapter 1)

Bud last edited this September 9, 2005 | Permalink | Comments (0) | TrackBack (0)

Normalization 1/3

Intro to normalization

Topics: Normalization

Before Class

1. Normalization (Chapter 1)

In Class

1. Overheads for Normalization 1/3
2. Normalization exercise #1
3. Answer to Normalization exercise #1
4. Normalization exercise #2
5. Answer to Normalization exercise #2
6. Alternative Answer to Normalization exercise #2

After Class

1. Normalization process
2. Normalization (Chapter 2)
3. Read Concepts of Database Management, pp. 139–162 in the coursepack.
4. Normalization problems #1 (for practice if you want them)
5. Normalization problems #1 answer (for practice if you want them)

Other Resources

1. Database normalization & design techniques (PHP Builder)

Bud last edited this September 9, 2005 | Permalink | Comments (0) | TrackBack (0)

Normalization 2/3

More normalization

Topics: Normalization

In Class

1. Overheads for normalization 2/3
2. Normalization exercise #3
3. Normalization exercise #3 answer
4. Normalization exercise #4
5. Normalization exercise #4 answer

After Class

1. Have a peek at start.com and Google IG. What do you think about these services?
2. Read Concepts of Database Management, pp. 162–172.
3. Normalization problems #2 (if you want practice)
4. Normalization problems #2 answer (if you want practice)

Bud last edited this September 9, 2005 | Permalink | Comments (0) | TrackBack (0)

Normalization 3/3

Even more normalization

Topics: Normalization

Before Class

Answer the following questions for yourselves so we can discuss them:

1. What part of the normalizaton process actually gets implemented in the computer?
2. Normalization is a key component of the relational model. How do we relate data in a set of tables that have been put in 3NF?

In Class

1. Overheads for normalization 3/3

After Class

1. Based on what you have seen so far, how is the relational model adequate or inadequate for storing information about business processes?
2. Normalization (Chapter 3).

Other Resources

1. Normalization (Chapter 4). This chapter presents an alternative method of normalization and is entirely optional.
2. Normalization process using graphs

Bud last edited this September 18, 2005 | Permalink | Comments (0) | TrackBack (0)

ER modeling: Basics

Work through examples in class.

Topics: ERD

In Class

1. E-R Modeling Slides
2. ER exercise #1
3. Answer to ER exercise #1

After Class

1. Details for Project 1 are available
2. Entity-relationship modeling (Sections 1, 2, 3)
3. Read Concepts of Database Management, pp. 215–219.

Bud last edited this September 16, 2005 | Permalink | Comments (0) | TrackBack (0)

ER modeling: Advanced

Work through more advanced ER topics in class.

Topics: ERD

In Class

1. Download the class overheads
2. ER exercise #2
3. ER exercise #2 answer
4. ER exercise #3
5. ER exercise #3 answer
6. Table structures for University database

After Class

1. ER modelling (Sections 4, 5)

Bud last edited this September 25, 2005 | Permalink | Comments (0) | TrackBack (0)

John Nardini, Senior VP, Denali Flavors

John will discuss the projects with us.

Topics: Projects

Bud last edited this August 31, 2005 | Permalink | Comments (0) | TrackBack (0)