In this assignment you will acquaint yourself with Microsoft Access and
get a start on filling the database we will be using for the final
project. It is very important that you follow the directions precisely:
improperly turned-in assignments will be sent back to you for resubmission.
(May 22) It seems that the CD registration tool is not working. The department
moved the servers that are running it and something was not restarted properly.
We're working on fixing that and I am optimistic we'll have it fixed by 3:30pm.
I'll place a message here when it's fixed. Thanks for your patience and sorry for
(May 14th) The assignment was handed out.
Part 1: Building tables
Look at the relational schema above. These are intended to represent
CDs, the bands that record them, and the artists that perform on them.
Notice that we are separating Bands from Artists (in the case of a solo
artist, they will appear as a band and as an artist). Notice also that,
since band is an attribute of CD, we won't allow compilation CDs (e.g.
Best of the 80's).
Your task in this first part is to create a database and add tables for
these four relations.
Create a new database: Select "File" --> "New...". Select "Database".
Enter a file name for your database and select "Create".
Add a table for CDs: Under "Objects" in the Database window, select
"Tables" from the "Objects" pane and then select "Create table using
Design view". For each attribute in CDs add a row in the "Table"
window: "Field Name" should hold the attribute name and "Data Type"
should hold (yep!) the attribute's type.
Add tables for the other three relations. For birthdate (in Artists),
choose "Short Date" as its "Format" in the "Field Properties" pane.
Part 2: Fill them with data
For this part of the assignment you will be filling your tables with
the information from 15 albums that you like (and, preferably, that you
also own). To ensure that all the CDs are unique, you need to
register the CDs you are entering (before entering them). When
you register a CD, you will be given a unique ID for the CD that will
serve as that CD's key.
Enter your CD information in the
CD Registration Page
and click "Register" to get an ID for it. If someone has already registered
that CD, you'll have to choose another.
Fill in the CD information in your Access table for that CD. Use the
registration ID for the ID field in CDs.
Add an entry to the Band table for the CD (unless you already have an
entry for the band).
Add one or more entries to the Artist table for the CD for key members
of the CD's band and add corresponding entries to PerformsOn.
Repeat steps 1 to 4 fourteen more times (for a total of 15 CDs). You
will need to have at least 6 entries in Band and Artist, and however
many entries are needed in PerformsOn.
Part 3: Turn in your results
The results from all 50+ students in the class are going to be added
together to make one database (with 4 big tables), so it is very important
that you play close attention to how to turn your results in. In short,
you will save each of the four tables as text files and then save them as
attachments in an e-mail to firstname.lastname@example.org. Here are the
particulars. For each table:
Select the table that you want to export (e.g. CD, Band, Artist, or PerformsOn)
and then select "File" --> "Export...".
Set "Save as type" to be "Text Files (*.txt; *.csv; *.tab; *.asc)" and then
click "Save All".
In the Export Text Wizard, select "Delimited" and then click "Next".
Select "Comma" as the delimiter, make sure "Include Field Names on First Row" is
not checked, set the "Text Qualifier" to be double-quote (i.e. ") and then
In the "Export to File" box, make sure that the file name is one of the following:
"CD.txt", "Band.txt", "Artist.txt" or "PerformsOn.txt". Make sure that the
capitalization matches exactly and then click "Finish".
Now you have four text files. Send an e-mail to email@example.com with
the four files as attachments. The subject line of your e-mail needs to be the
following (substituting your own name, of course):
CS317-A5: Your Full Name