ECE356 Study Guide - Final Guide: Relational Model, Database Design, Relational Algebra
10 Apr 2014
School
Department
Course
Professor
Document Summary
Cs 348 introduction to database systems (fall 2012) Instructions: this is a closed book examination. Solution: conceptual modeling: the process of identifying the entities, their proper- ties, and the relationships among these entities that are part of the environ- ment that the information system models. In our case, we used e-r model for conceptual modeling: logical modeling: the process of mapping the conceptual model to the primitives of the data model that is used. Solution: relational calculus is a declarative language that requires the user to specify the predicates that need to be satis ed by all the tuples in the result relation. Solution: referential integrity refers to the relationship between two entities such that if there is a referential integrity from entity e1 to entity e2, an instance of. E2 has to exist for an instance of e1 to exist. Solution: these anomalies exist when relations are not normalized properly.
