OMIS 452 – 70+ Exam Questions on Data Modeling, Entities, SQL & Metadata

This document includes over 70 well-structured and fully answered questions from the OMIS 452 course, covering foundational topics in database management and relational modeling. Key areas addressed include the definition and hierarchy of data, structured vs. unstructured data types, metadata, entity-relationship (E-R) modeling, normalization (1NF through 3NF), and functional dependencies. It also explores relational concepts such as strong and weak entities, degrees of relationships (unary, binary, ternary), identifying and derived attributes, and cardinality constraints. Students will also find practical definitions of key SQL concepts and DBMS functionalities, including MS Access and SQL data types, constraints, XML formatting, and the structure of enterprise database systems (three-schema architecture, repositories, and application layers). This resource is ideal for OMIS, MIS, Business Analytics, Information Systems, and Computer Science students who need a conceptual and technical understanding of relational databases, making it suitable for exam preparation and coursework support. Keywords: OMIS 452, data modeling, metadata, DBMS, normalization, 1NF, 2NF, 3NF, functional dependency, entity-relationship model, strong entity, weak entity, primary key, foreign key, composite key, cardinality, SQL data types, MS Access, XML, repository, three-schema architecture, database constraints, relational model