finalreview - MIS331- DATABASE Final Review Topics 1. E-R...

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

View Full Document Right Arrow Icon
MIS331- DATABASE Final Review Topics 1. E-R Diagramming and Normalization Creating Diagrams Translating into tables in BCNF (with referential integrity specifications) You should be able to go backwards and forwards… Identifying whether tables are in 1, 2, 3NF, or BCNF and converting tables into a higher level normal form ASSUMPTIONS!! Sample modeling problem is available on page 2 of this handout 2. Physical Design Denormalization: what is it? why do it? When to do it? Indexes: what are they? Why have them? When to have them? 3. Writing SQL Queries DDL, DML Simple Select Queries Queries that use SUM, COUNT, AVG, MAX, and other aggregates GROUP BY, HAVING (how and when to use) Sub-queries and joins Correlated Sub-queries and outer joins Views, indexes, alter table, alter user, drop table, grant privileges Errors and what they mean !!! Describe (and Select * from cat;)
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.

This note was uploaded on 01/20/2011 for the course MIS 331 taught by Professor Nathantwyman during the Fall '10 term at University of Arizona- Tucson.

Page1 / 3

finalreview - MIS331- DATABASE Final Review Topics 1. E-R...

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