INFS 346 Exam 1 Review – 2025 Q&A | Database Systems, ER Modeling, DBMS Concepts

This document offers a comprehensive review of Exam 1 for INFS 346, focusing on database foundations, system development processes, and modeling techniques. Updated for the 2025/2026 academic year, it contains structured question-and-answer content with all key concepts and examples illustrated clearly, making it ideal for students studying Information Systems, Database Management, or Computer Science at U.S. universities. Major topics include: Data vs. information and real-life examples Functions of a Database Management System (DBMS) Phases of database system development (requirements, modeling, implementation, deployment) Roles of database analysts, designers, developers, and administrators Differences between conceptual, logical, and physical modeling Entity-Relationship (ER) modeling constructs: entities, relationships, attributes, cardinality Advanced modeling concepts: weak entities, associative entities, unary/ternary relationships Transactional vs. analytical information Common RDBMS tools (e.g., Oracle, MySQL, SQL Server) This document is especially useful for: Undergraduate students in Information Systems or Computer Science Students preparing for INFS 346 or related database courses Learners studying for midterm/final exams or practicals involving ER diagrams and DBMS logic Professionals brushing up on core database modeling theory It is formatted for quick review and exam practice, supporting deep understanding of relational data design and effective database planning principles. Keywords: INFS 346, database systems, ER modeling, DBMS, data vs. information, conceptual modeling, logical modeling, database design, SQL Server, Oracle, database development, weak entity, ternary relationship, candidate key, information systems exam, U.S. university