Thursday, March 29, 2012


design a table to store course information,
make up information to fill that table
course number, number of credits, faculty, faculty rating

design a table to store faculty information,\
msaccess


Access is different from other office applications
does not automatically start with a blank database
you need to create a blank database on the disk

Many changes to the database automatically save
(editing a table)
also, cannot undo

which is why we often save backup copies of a database

create /; table design
there is data and there is meta-data

in access, must explicitly save meta-data
changes to data automatically save
Link of the CS dept at Queens College
http://www.cs.qc.cuny.edu/

http://www.cs.qc.cuny.edu/schedule/fa12/fa12.htm

non-relational
will have duplicated values
inconsistent data

Guidelines:
in general, fields should be as atomic as possible
keep fields as unchanging as much as possible
calculate changing values based on that

No comments:

Post a Comment