CSC 4402 20091202

CSC 4402 20091202 - CSC 4402 12/2/2009 Page 1 of 5 Final...

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

View Full Document Right Arrow Icon
CSC 4402 12/2/2009 Page 1 of 5 Final review Dec. 12 3 – 5 PM in the classroom Don’t forget logical & physical data independence. Review the big concepts from the midterm. There will be SQL queries on the final. We will have to draw an E-R diagram on the final. This will probably be done by being given the relation tables and constructing the E-R diagram from the relational tables. Review previous homework and answer keys. Be able to tell if a set of transactions with locking statements fulfills the two-phase locking protocol. Part 4 – Database design Database design o Chapter 6 o Lecture notes on F.D., etc. o Beginning of Chapter 7 Design process User requirement specification Conceptual design o E-R Modeling Main constructs Entities o Instance – an object o Set – set of objects sharing common characteristics (attributes) o Regular/strong vs. weak entities Weak don’t have a primary key and rely on other relations to exist Relationships o Instance o Set Attributes o Description/characterization of entity/relationship Subtype/supertype o Generalization hierarchies Mapping cardinality constraints For binary relationships we have 1-1, 1-m, m-m. o E-R diagram Entities are rectangles.
Background image of page 1

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

View Full DocumentRight Arrow Icon
CSC 4402 12/2/2009 Page 2 of 5 Relationships are diamonds. Attributes are ellipses. Should show cardinalities on the diagram Should you use attribute set or entity set, etc. Given an E-R diagram how do you do a reduction from E-R model to the relational model. Entities are mapped to tables Foreign keys on many side, referring to one side Review the other rules o Conceptual schema Functional requirement specification o What the system should be able to support
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/25/2010 for the course CSC 4402 taught by Professor Staff during the Fall '08 term at LSU.

Page1 / 5

CSC 4402 20091202 - CSC 4402 12/2/2009 Page 1 of 5 Final...

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

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