What This Document Is
This document contains answers to the third exam for Database Management (CIT 3403) at Arkansas State University. It focuses on relational database concepts, specifically entity and referential integrity, relationship types, and Entity-Relationship Diagram (ERD) creation. The document uses example databases – StoreCo and a Student/Professor database – to illustrate these concepts.
Why This Document Matters
This study guide is intended for students enrolled in CIT 3403 who are preparing for their third exam. It serves as a check for understanding of key database principles covered in the course. It’s most useful *after* attempting the exam questions independently, to verify solutions and identify areas needing further review.
Common Limitations or Challenges
This document provides *answers* to specific exercises, but it does not offer detailed explanations of the underlying database concepts. It assumes prior learning of database terminology and principles. It will not teach you how to design a database from scratch or how to write SQL queries.
What This Document Provides
The full document includes:
* Answers to questions identifying primary and foreign keys in database tables.
* Assessments of entity and referential integrity for given database schemas.
* Descriptions of relationship types (1:M, 1:1) between tables.
* Completed ERDs illustrating relationships between entities.
* Solutions for performing outer joins on database tables.
* Example database schemas (StoreCo, Student/Professor) for context.
This preview *does not* include the full ERD diagrams or the detailed steps taken to arrive at the answers. It also does not include all questions from the exam.
