Database Management Systems

Express Learning is a series of books designed as quick reference guides to important undergraduate computer courses. The organized and accessible format of these books allows students to learn important concepts in an easy-to-understand, question-and-answer format. These portable learning tools have been designed as one-stop references for students to understand and master the subjects by themselves.

Cover -- Contents -- Preface -- Chapter 1: Database System -- Multiple-choice Questions -- Answers -- Chapter 2: Conceptual Modeling -- Mapping cardinalities -- Participation constraint -- Entity types versus attributes -- Binary versus ternary relationship -- Structural diagrams -- Behavioural diagrams -- Multiple-choice Questions -- Answers -- Chapter 3: Relational Model -- Domain integrity -- Entity integrity -- Referential integrity -- Semantic integrity -- Insert operation -- Delete operation -- Update operation -- Representation of weak entity types -- Representation of composite and multivalued attributes -- Representation of generalization -- Representation of aggregation -- Multiple-choice Questions -- Answers -- Chapter 4: Relational Algebra and Calculus -- Queries in relational algebra -- Queries in tuple calculus -- Queries in domain relational calculus -- Expression in relational algebra -- Expression in tuple calculus -- Expression in domain calculus -- Queries in relational algebra -- Queries in tuple calculus -- Queries in domain calculus -- Multiple-choice Questions -- Answers -- Chapter 5: Structured Query Language -- Adding an attribute -- Modifying an attribute…