UT Dallas CS 6360 - CS-6360 FINAL EXAM REVIEW (Fall 2014)(2) (24 pages)

Previewing pages 1, 2, 23, 24 of 24 page document View the full content.
View Full Document

CS-6360 FINAL EXAM REVIEW (Fall 2014)(2)



Previewing pages 1, 2, 23, 24 of actual document.

View the full content.
View Full Document
View Full Document

CS-6360 FINAL EXAM REVIEW (Fall 2014)(2)

195 views


Pages:
24
School:
University of Texas at Dallas
Course:
Cs 6360 - Database Design
Database Design Documents

Unformatted text preview:

Final Exam Review Fall 2014 CS 6360 Database Design Chris Irwin Davis Ph D Email chrisirwindavis utdallas edu Phone 972 883 3574 O ce ECSS 4 705 Chapter 1 Nothing 2 Chapter 2 Nada 3 Chapter 3 Nichts 4 Ch 4 5 SQL Type Short answer Multiple Choice True False Required Syntax SELECT FROM Optional Syntax WHERE GROUP BY after WHERE HAVING after GROUP BY Aggregate Functions COUNT SUM MIN MAX AVG Aggregate functions never appear in WHERE clause JOIN Natural Join Inner Join Outer Join 5 Ch 4 5 SQL NOT COVERED UPDATE DELETE VIEW Admin functions DESCRIBE MODIFY ALTER DROP 6 Ch 6 Relational Algebra Type Multiple Choice Multiple Answer Matching T F Relational Algebra Set functions NOT Covered Relational Calculus Boolean ops and Quantifiers Tuple Relational Calculus Domain Relational Calculus 7 Ch 7 8 ER EER Models Type Multiple Choice Multiple Answer Matching T F Answer questions about ER EER diagram Participation and Cardinality min max Participation and Cardinality property of an entity min max range of an entity s interaction with a relationship A min max pair is required for each side of a relationship 8 Cardinality Participation and min max Cardinality Participation notation is mutually exclusive with min max notation Cardinality max and Participation min If there is one number on each side then it is Cardinality i e max Participation has only two options single line min 0 double line min 1 PARENT E1 E1 CHILD 2 N R 0 n 1 2 R 11 E2 E2 Chapter 9 ER EER Mapping to Relational Model Map ER EER diagram onto relation schema using 7 step algorithm NOTE These two steps are commonly missed ER Step 7 Mapping of N ary Relationship Types p 292 EER Step 8 Four different options Superclass and subclasses Subclass relations only Single relation superclass with one type attribute Single relation superclass with multiple type attributes 12 Ch 15 Functional Dependencies and Normalization 1NF The only attribute values permitted by 1NF are single atomic or indivisible values That is no



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view CS-6360 FINAL EXAM REVIEW (Fall 2014)(2) and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view CS-6360 FINAL EXAM REVIEW (Fall 2014)(2) and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?