CS105
LAB 1 - WebSubmit/Database Fundamentals
|
Objectives
- Review Lab 0. Did everyone manage to
create a CS account?
- Familiarize ourselves with the WebSubmit procedure
- 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:
- Create a test file with the text: "I rock my world"
with the WordPad text editor available in the Accessories
folder on Windows.
- Name the file
lab1.txt.
- Login to WebSubmit using your Kerberos password.
- Submit your
lab1.txt file to the
lab01 project in WebSubmit.
- View your file in WebSubmit to make sure that you
submitted the correct file.
- 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.
- Describe the types of data that could be stored
in this type of database.
- Give an example of how transactions would be helpful in the context
of this application.
- 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.)
- 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.
- 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?
- Identify and describe the use of primary and foreign keys in our online catalog database application
|