- | P a g e
COMM 2226 Final Exam 2025, Communication Studies Test Bank, COMM 2226 Questions and Answers, College Communication Exam, COMM 2226 Study Guide, Communication Course Final, Verified Exam Answers
What is a database management system (DBMS)? - ANSWER- A DBMS is software that is used to create, process, and manage databases. It provides an interface between the database and end-users or application programs, and helps to store, retrieve, and manipulate data in a controlled manner.
What are the five popular DBMS products? - ANSWER-1. DB2
(IBM): A powerful DBMS for large-scale databases.
2. Access (Microsoft): A personal DBMS for small-scale
applications.
3. SQL Server (Microsoft): A widely used DBMS in enterprise
environments.
4. Oracle Database (Oracle): Known for its robustness and
scalability in enterprise-level applications.
5. MySQL (open-source): A popular, free DBMS for small and
medium-scale applications.
- / 4
- | P a g e
How does a DBMS differ from a database? - ANSWER-A DBMS is the software used to manage a database, which is a collection of data organized in tables, relationships, and metadata. The DBMS handles tasks like creating, processing, and administering the database, while the database itself is the data structure.
Define SQL. - ANSWER-Structured Query Language (SQL) is the standard programming language used to create and manage relational databases. It is used to define the structure of the database, insert, update, and delete data, and retrieve specific information using queries.
What is normalization in database design? - ANSWER- Normalization is the process of organizing a database into tables that reduce redundancy and dependency by ensuring each table has a single, well-defined topic or theme. This helps avoid data anomalies and maintains data integrity.
What is a data integrity problem? - ANSWER-A data integrity problem occurs when there is inconsistent or inaccurate data in a database, which can lead to unreliable information. Such problems can arise from incorrect data entry, poor database design, or synchronization issues across multiple users. 2 / 4
- | P a g e
What is the difference between Enterprise DBMS and Personal
DBMS? - ANSWER-- Enterprise DBMS: Supports large-scale,
complex databases for large organizations with thousands of users. Examples include DB2, SQL Server, and Oracle Database.
- Personal DBMS: Designed for smaller-scale applications with
fewer users (typically fewer than 100). An example is Microsoft Access, which is often used by small businesses or individuals.
What is an E-R model in database design? - ANSWER-The Entity-Relationship (E-R) model is a tool used to visually represent the structure of a database. It describes entities (objects to track) and their relationships, helping developers design the database structure. Entities are often represented by rectangles, while relationships are represented by lines.
What does "crow's-foot notation" represent in database design? - ANSWER-Crow's-foot notation represents the maximum cardinality in a relationship, indicating how many instances of one entity can be related to another. It is commonly used in E-R
diagrams and shows relationships such as 1:N (one-to-many),
N:M (many-to-many), and 1:1 (one-to-one). 3 / 4
- | P a g e
What is the difference between NoSQL and relational DBMS? -
ANSWER-- NoSQL DBMS: Non-relational databases designed
for handling large amounts of unstructured or semi-structured data. They are used for high-performance applications that require scalability, such as social media and big data platforms.
- Relational DBMS: These DBMS manage structured data in
tables and use SQL for querying. They are used in applications that need complex queries and relationships between tables, such as customer databases or inventory systems.
What is the process of database design? - ANSWER-Database design is the process of converting a data model (logical representation) into a database structure (tables, relationships, and constraints) that can be implemented in a DBMS. This involves defining entities, attributes, relationships, and ensuring data integrity.
What are the three components of a database design? -
ANSWER-1. Tables: Where data is stored in rows and columns.
2. Relationships: How tables are connected to each other (using
keys like primary and foreign keys).
- / 4