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 Document Right 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

{[ snackBarMessage ]}

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