CS105
LAB 1 - WebSubmit/Database Fundamentals


Objectives
  1. Review Lab 0. Did everyone manage to create a CS account?
  2. Familiarize ourselves with the WebSubmit procedure
  3. Discussion of a real-world database application


WebSubmit

The following link gets you to the homework submit webpage:

http://cs-websubmit.bu.edu/main.py?courseid=cs105

Using WebSubmit is straightforward. To familiarize yourself with the procedure, do the following:

  1. Create a test file with the text: "I rock my world" with the WordPad text editor available in the Accessories folder on Windows.
  2. Name the file lab1.txt.
  3. Login to WebSubmit using your Kerberos password.
  4. Submit your lab1.txt file to the lab01 project in WebSubmit.
  5. View your file in WebSubmit to make sure that you submitted the correct file.
  6. Change the content of the file to "I really do!", resubmit it, and view it again.

Practice Exercise: A Real-World Database Application

Let's consider one example of a real-world database application: an online catalog for a library.

  1. Describe the types of data that could be stored in this type of database.
  2. Give an example of how transactions would be helpful in the context of this application.
  3. What are some other advantages of using a database system in this context? (It may help to recall the four key DBMS functions mentioned in the lecture notes on database fundamentals.)
  4. Let's devise a description of some of the tables that might be used by this application. This type of description is sometimes referred to as a schema for the database. It should include the name of the table, and the names of the fields that would be part of each record in the table.
    When determining the schema, it's helpful to follow this rule of thumb: a given table should describe either a single type of entity (person, place, or thing), or a relationship between two or more entities.
  5. For each table, it's helpful to have one or more fields whose values can serve as unique identifiers for the records in that table. These unique identifiers are referred to as key fields. For example, if we have a table of student information, the student id number can serve as a key. What key fields would make sense in the tables for this application?
  6. Identify and describe the use of primary and foreign keys in our online catalog database application