{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CSC 4402 20091202

# CSC 4402 20091202 - CSC 4402 Page 1 of 5 Final review Dec...

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

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.

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

View Full Document
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 Final stage o Logical design o
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern