Computer Science Notes 2

Computer Science Notes 2 - FilesystemonPC,MAC,UNIX...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Computer Science Notes 2 20:58 -Spreadsheets are good at “figuring things out” -Databases are good at “looking stuff up” -Hierarchical Databases File system on PC, MAC, UNIX Related stuff is stored together Gets more and more specific until it comes down to 1 file Network Database Distributed over wide geographic area WWW Flat-File Database All relevant date are in a single table Relational Database Data are stored in multiple tables along with relationships between tables Subsume flat-file databases Ex of a Table…. 2 3 4 5 6 7 8 9 10
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
change) Columns in a table have: Name-mandatory Size-mandatory Data type-mandatory Default Value-optional Validation rule-optional - A  record  is all the information about a single object (a row of the table)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/02/2012 for the course COMPSCI 105 taught by Professor Verts during the Spring '08 term at UMass (Amherst).

Page1 / 5

Computer Science Notes 2 - FilesystemonPC,MAC,UNIX...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online