COSC3337 Final Review

COSC3337 Final Review - create and use trigger security...

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

View Full Document Right Arrow Icon
General Review COSC 3337 Components of a DBMS Vocabulary Data Dictionary Design - major factors for RDBMS Developers Design 1 st Normal Form 2 nd NF 3 rd NF Candidate key, primary key, index, foreign key, options Datatypes SQL create tables write queries create and use views
Background image of page 1

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

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

Unformatted text preview: create and use trigger security mysqldump what it does how it can be used Transaction Processing Transaction log recover from a database crash Operational database Analytic database Distributed databases Data Warehouse concepts uses...
View Full Document

This note was uploaded on 04/29/2008 for the course COSC 3337 taught by Professor Camden during the Spring '08 term at St. Edwards.

Page1 / 2

COSC3337 Final Review - create and use trigger security...

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