Exam 2 review - CGS 2545: Database Concepts Spring 2010...

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

View Full Document Right Arrow Icon
CGS 2545: Database Concepts ( EXAM #2 Review) Page 1 Mark Llewellyn CGS 2545: Database Concepts Spring 2010 EXAM #2 Review School of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn markl@cs.ucf.edu HEC 236, 407-823-2790 http://www.cs.ucf.edu/courses/cgs2545/spr2010
Background image of page 1

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts ( EXAM #2 Review) Page 2 Mark Llewellyn The material covered on the exam is taken only from the on-line lecture notes. There will be no questions on the exam which are Access specific. Much of this material also appears in the textbook, however, material that appears only in the textbook will not appear on the exam. The exam covers the material in Chapters 5 (two sections of notes), 7, and 8. Format of the exam will consist of mostly multiple choice and true/false questions with a few work type problems. The work problems will consist of writing SQL queries. Material Covered On Exam
Background image of page 2
CGS 2545: Database Concepts ( EXAM #2 Review) Page 3 Mark Llewellyn Chapter 5 Details Logical Database Design And The Relational Data Model Relation, attribute, domain, tuple, degree, cardinality, and related terminology. You can ignore the more mathematical definition of a relation. Be familiar with the definition of a relation as shown on page 11. Know the difference between a schema and an instance. Be able to convert basic ER diagrams into a set of relational tables. Strong entities with simple, composite, and multi-valued dependencies. Weak entities. Binary 1:M and M:M relationships. Binary 1:1 relationships. Associative entities both with and without defined identifiers. Unary relationships. Supertype/subtype hierarchies.
Background image of page 3

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

View Full DocumentRight Arrow Icon
( EXAM #2 Review) Page 4 Mark Llewellyn Chapter 5 – Part 2 Details Normalization Know what normalization is and how it is achieved. Concept of a functional dependency. Normal forms based upon functional dependencies: (1NF), 2NF, 3NF, and BCNF. Insertion, deletion, and update anomalies.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 18

Exam 2 review - CGS 2545: Database Concepts Spring 2010...

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

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