Class Notes (835,312)
United States (324,088)
IST 195 (86)
Rubin (22)
Lecture

Databases

1 Page
88 Views
Unlock Document

Department
Information Studies
Course
IST 195
Professor
Rubin
Semester
Fall

Description
-Why use a database? -Only way to manage a LOT of data -Terabytes of data… -Performs quick queries (decisions) -Pretty much all online servers use database -DB terminology -Database schema: how DB is constructed/organized -Database: set of tables (aka relations) -Table: contains attributes; every table serves a purpose -Attribute: ex., first_name, last_name, email -Primary key: unique attribute for each table (usually a #) -Every record needs to be unique -Can’t have 2 identitical records -Foreign key: heart of the “relation” btwn 2 tables -Relational database model -Design l
More Less

Related notes for IST 195

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit