February 28/Class Notes- Database

R.D.M.S

structured query and language SQL

RDMS speaks SQL – its another language

each database contains a table

Column = Field
Row = Record

Field names cannot have spaces.

Most common DATA TYPES:

PRIMARY KEY: generates unique # for records.

Primary Key type is almost always INT

Varchar : Most is 30 characters, if want more use TEXT

Class Notes/ February 14

leafs are one side

pages are double sided ( thesis were all leafs…)

subdivisions( pg 19)

subject headings (pg 13)

topical subdivisions : subfield x

geographic subdivision : subfield z

chronological subdivision: subfield y

form subdivision : subfield v

authorities (some subdivisions)

photographer ontario toronto

$aPhotographers$zOntario$zToronto

lc classification – google

http://www.loc.gov/catdir/cpso/lcco/

photography is TR. ( in the document as well..)

CF : means “confer” in latin – compare or contrast

TR 6

TR 21

Classification

subfield a

150 field

TR 147

arranged by main entry

$aTR147$b.H33 2008 andrea hackman

if its a consonant ( h )

expansion

MARC con’t./Class Notes February 07/08

publication

260 ## $a New York:

$b Chelsea House,

$c 1986.

300 Physical description

300 ## $a 139 p. ;

$b ill. ;

$c 24 cm.

300 $avi, 200p. :$b

300 $a150p.

300 $a200, [5] p.

600 Subjects

what is this work about? 100 by author

600 subject

it is about photographic process, what not.

650 authority file

Authority

1XX – 100 – 50 valid forms of the heading

Bibliographic

100 – author

4XX

photographers (may subd geog) subdivision

hd labor

tr techonology ( ours)

bt : broader term

nt: narrower term

photographic dosimetry ( bold – valid)

uf- used form

use – use