OSE- Chapter 1- SQL and Data

OSE- Chapter 1- SQL and Data - 1/29/12 7:15 PM OSE: Chapter...

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

View Full Document Right Arrow Icon
1/29/12 7:15 PM Page 1 of 2 http://www.cs.utexas.edu/~mitra/csSpring2012/cs327/notes/OSE.1.txt OSE: Chapter 1: SQL and Data * Relational Database offers: - data independence - user does not need to know where the data is stored and in what format - data consistency - same data for different users - data integrity - abides by constraints * A database has a set of related tables * A table has rows and columns. The column names in a given table must be unique. The rows in a table must be unique. * Primary Key is the value in a column or columns that uniquely identifies a row. * Foreign Key is the value in a column that is the Primary Key in another table. * These are the functionalities that SQL offers: - Data Manipulation: SELECT, INSERT, UPDATE, DELETE, MERGE - Data Definition: CREATE, ALTER, DROP, TRUNCATE, RENAME - Data Control: GRANT, REVOKE - Transaction Control: COMMIT, ROLLBACK, SAVEPOINT * Data Normalization is the process of eliminating redundancy in tables. There are 5 normal forms and the Boyce-Codd normal form (BCNF).
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

OSE- Chapter 1- SQL and Data - 1/29/12 7:15 PM OSE: Chapter...

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

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