Read
Me Now

March 16, 2006

Here
is a link
to the promised clarification of deliverables due on Tuesday the 21st

March 15, 2006

Exam
tomorrow: regular classroom,
regular time.  Below is
some information relating to discussions in yesterday’s class that
you may find useful.

A
link
to the Music Semantic Object Model developped in the 5pm class.  It shows:

the
semantic object model

the
SQL Server tables created automatically from the semantic object model

the
relationship diagram created in SQL Server from the tables in SQL Server
(Brandon,
this may be the answer to what you asked in class).

A
link
to a set of directions showing how to change the primary key from inside
Table Designer (the semantic object modeler we are using).

March 14, 2006

Here’s
a link
to Professor Harris’ presentation from March 2nd  on Data Conversion

Reminders:

Exam
on March 16th – don’t miss it! – No makeups
will be given

Your
group work on the database projects is due in class today.

February
28, 2006

Exam
postponed until after Spring break – March 16th

See
Blackboard for key to HW 11

See
Blackboard for discussion of Lab 3

See
Useful URLs for link
to Semantic Object Model Software – Appendix E in text

Link
to Screen captures for ODBC here

February
22, 2006

Please
read the rest of chapter 5 about patterns (and see Part II and Part III
chapter slides)

Please
make sure that you have stapled your entity/attribute/cardinalities
to  whichever of the four (4)
database project descriptions you got on the 16th of February
and passed it on to another member of your group for him/her to comment on
it, enhance it, create forms for some of the entities.  That should be done by this
Thursday (the 23rd) so you can pass it on again for the third
member of your group to work on over the weekend.

I have
posted the group contact information I have on Blackboard under Course
Documents.

NOTE:  I have computed homework, lab and
quiz grades using the 5th highest grade in the class as the maximum and
determining each student’s
% in each category based on that maximum.   Students whose %s were low in
two or more categories or whose % in one category was particularly low
have received e-mails with the %s.

Homework
due tomorrow, February 23rd.

link
to photo of white board MHA project from 3:30 class  alternate
view  another
view

February
16, 2006

Lab
Assignment due Tuesday, February 21st

ERwin Installation screen captures here

Using Erwin screen captures here

Please
remember that you are to carefully read the Project handout you
received  and to make notes
about the entities and the attributes, to make rough sketches the forms
that will be needed, and the assumptions.  Staple your notes to the
handout.  Bring it to class on
Tuesday.  Remember that this is
a first pass at the design.
It is not supposed to be a finished product.  If you missed class today, someone
in your group should have your handout.  If not e-mail me and I’ll
arrange to get it to you.

I have
left a copy of the author’s screens and form information for the Art Gallery database outside my
office.  Please do not remove
it.  It is there for you and
your class mates to look at.

February
15, 2006

Homework
for tomorrow:  February 16th

Install Erwin -
see link on February 14th for slides showing steps and Useful
URLS for link to site

February
14, 2006

3:30
class will start at 3:30
in ISAT/CS 236... Please be there as close to 3:30 as possible...

Here are the slides
from the ERWin site

February
9, 2006

If you were absent today, be sure to read the e-mail I sent
you and pick up the handout.

The Lab
Assignment started in class is due on Tuesday the 14th  and is to be a group effort
– groups formed in class

Read through Chapter 5 up through page 135 & look at the
slides for Pt 1 & Pt 4 before answering the questions in Assignment

Remember to update your terminology list.

Look in Useful
URLs for the link to the free trial version of Erwin.

February
7, 2006

Reminder:  Part
II of the Lab
Assignment is due on Thursday.

Here’s the link to the exercise on Multivalued
dependencies we went over in class.

Homework
for Thursday February 9th -

Look at Useful
URLs for some information about differences between ACCESS and SQL SERVER
and about

data
migration from ACCESS to SQL SERVER provided by Andrew Richter.

Follow this link to a summary
of SQL syntax provided by John Magnotti

February
3, 2006

Homework
for Tuesday, February 7th includes a LAB
assignment.  The lab assignment
is in two (2) parts.

Part I is due on Tuesday, February 7th.

Part II is due on Thursday, February 9th .

I encourage you to work in teams on the Labs and for each
team member to create and save the database on their machine.

January
31, 2006

Read Chapter 3
again

Homework
for Thursday, February 2nd – please type in your answers
before printing the page

Some new terms
have been added to the Summary of Relational Terminology.  Make sure yours is up-to-date.

There may be a
quiz

January
28, 2006

Homework
for Tuesday, January 31st – Please read the directions
VERY carefully.

January
26, 2006

Screen
captures from SQL Server – review of class    one,  two,
three

Homework
for Tuesday January 31st will be posted tomorrow

Read
Chapter 3

Install
SQL Server 2000 – Developer

January
24, 2006

My
slides on chapter
2

Homework
for Thursday, January 26th – may be done individually or
in teams.

January
20, 2006

Homework
for Tuesday, January 24th – use the same teams as for the
last assignment.

Re-read chapter
2 and review slides from book

There may be a
quiz on the homework or on the material in the chapter...

January 19,

Chapter 2 slides from book – part 1 and part 2

January
17, 2006

Here’s a summary
of relational terminology

Relational
Algebra slides

Homework
for the 19th – teams have been assigned (don’t
change)

Read chapter 2.

Final exam
re-scheduled (tentatively) to May 2nd
at 7pm …

January
15, 2006

See the
following comments
on Lab 1 in order to improve your submission for Tuesday

January
12, 2006

Note
1:  a copy of the text is on 2 hour
reserve at the CISAT library

Notes:
Here is the partial discussion
of Lab 1 homework with key definitions.

Please do the following things before next class

1.  read chapter 1

2.  determine the answers to these questions
in preparation for a quiz

3.  go through one of the SAP
demos – URLs are available on Useful URLs page – and write a few
sentences on what is going on

in the demo

4.     make
sure that you have been able to download and install SQL Server …

5.     IF
your printout was not “perfect” bring in a perfect copy on Tuesday.

January
10, 2006

Please do the following three
four things before the next class

buy
the book if you haven’t already done so

download
SQL Server

do Lab
1 and turn it in on Thursday

Check  your quiz answers against the
Pren-Hall website.