FIT 100Skip Navigation

• Home
• Overview
• Vision
• Grading
• Communications
• Instructor

Coursework:

• Calendar
• Weekly Schedules:
  1 • 2 • 3 • 4 • 5 • 6 • 7 • 8
  9 • 10 • 11 • Finals
• Readings
• Homework and Labs
• Projects

Miscellaneous:

• Resources
• Computing
• eReserves
• Tech and Library Tips
• Syllabus

Week 9:

Overview

This week we explore XML and databases. Both can store data and have methods for data retrieval. XML can also be used to transfer  data  between databases or over the Web.

top of page

Objectives

The objectives for this week are:

• Use XML to describe the metadata for a table of information, and classify the uses of the tags as identification, affinity, or collection
• Explain the differences between everyday tables and database tables
• Explain how the concepts of entities and attributes are used to design a database table
• Use the six database operations: Select, Project, Union, Difference, Product, and Join
• Describe the differences between physical and logical databases
• Explain the relationship between XML and XSL
• Describe how to express metadata using XML
• Demonstrate the incremental creation of a database
• Show how to use tag attributes to display images
• State how information is hidden in XML databases

top of page

Lectures

Updated! See Calendar for current lectures.

Mon 11/17: Introduction to the Database Age video

Wed 11/19: Database Basics / XML [slides] [pdf] [handouts]

Fri 11/21: Designing a Database [slides] [pdf] [handouts] , Design exercise [athletes database] [design key]
 

top of page

Readings

Updated! See Calendar for current assignments.

Mon 11/17: Intro to Databases, Digital Web

Wed 11/19: Fluency, Ch 16

Fri 11/21: Fluency, Ch 17
 

top of page

Labs

Updated! See Calendar for current assignments.

Mon, Tues: JavaScript Project 2B
[Instructions] [WebQ]

Wed, Thurs: Lab 10
Grades Spreadsheet
[Instructions] [WebQ]

top of page

Assignments

Updated! See Calendar for current due dates.

Assigned:

Project 3A assigned
[Instructions] [WebQ]

Assignments Due:

Project 2B, before 10pm on Tues. 11/18

Lab 10, before 10pm on Fri. 11/21

top of page

<< Previous Week • Next Week >>

---

Home • Overview • Vision • Grading • Communications • Instructor
Calendar • Weekly Schedules • Readings • Homework and Labs • Projects • Resources • Computing • eReserves • Syllabus