SNHU DAD 220 MAIN EXAMINATION 2025/2026
QUESTIONS WITH ANSWERS GRADED A+
✔✔NoSQL - ✔✔Stands for "not only SQL". Newer non-relational systems that are
optimized for big data.
✔✔CRUD - ✔✔Common queries; Create, Read, Update, and Delete data.
✔✔Structured Query Language (SQL) - ✔✔The standard query langauge of relational
database systems. A high-level computer language for storing, manipulating, and
retrieving data.
✔✔SQL Statement - ✔✔A database command, such as a query that inserts, selects,
updates, or deletes data. Composed of one or more clauses. In MySQL they end with a
semicolon.
✔✔CREATE TABLE - ✔✔Creates a new table by specifying the table and column
names.
✔✔Data Type - ✔✔Indicates the format of column values. Data types can be numeric,
textual, or complex.
✔✔Database Design - ✔✔A specification of database objects such as tables, columns,
data types, and indexes. Also refers to the process used to develop the specification.
✔✔Analysis Phase - ✔✔Specifies database requirements without regard to a specific
database system. Requirements are represented as entities, relationships, and
attributes.
✔✔Entity - ✔✔A person, place, activity, or thing.
✔✔Relationship - ✔✔A link between entities
✔✔Attribute - ✔✔A descriptive property of an entity.
✔✔ER Diagrams - ✔✔Diagrams that depict entities, relationships, and attributes.
Rectangles represent entities. Lines between rectangles represent relationships. Text
inside rectangles and below entity names represent attributes.
✔✔Logical Design Phase - ✔✔Implements database requirements in a specific
database system. For relational database systems, it converts entities, relationships,
and attributes into tables, keys, and columns.
✔✔Key - ✔✔A column used to identify rows of a table.
QUESTIONS WITH ANSWERS GRADED A+
✔✔NoSQL - ✔✔Stands for "not only SQL". Newer non-relational systems that are
optimized for big data.
✔✔CRUD - ✔✔Common queries; Create, Read, Update, and Delete data.
✔✔Structured Query Language (SQL) - ✔✔The standard query langauge of relational
database systems. A high-level computer language for storing, manipulating, and
retrieving data.
✔✔SQL Statement - ✔✔A database command, such as a query that inserts, selects,
updates, or deletes data. Composed of one or more clauses. In MySQL they end with a
semicolon.
✔✔CREATE TABLE - ✔✔Creates a new table by specifying the table and column
names.
✔✔Data Type - ✔✔Indicates the format of column values. Data types can be numeric,
textual, or complex.
✔✔Database Design - ✔✔A specification of database objects such as tables, columns,
data types, and indexes. Also refers to the process used to develop the specification.
✔✔Analysis Phase - ✔✔Specifies database requirements without regard to a specific
database system. Requirements are represented as entities, relationships, and
attributes.
✔✔Entity - ✔✔A person, place, activity, or thing.
✔✔Relationship - ✔✔A link between entities
✔✔Attribute - ✔✔A descriptive property of an entity.
✔✔ER Diagrams - ✔✔Diagrams that depict entities, relationships, and attributes.
Rectangles represent entities. Lines between rectangles represent relationships. Text
inside rectangles and below entity names represent attributes.
✔✔Logical Design Phase - ✔✔Implements database requirements in a specific
database system. For relational database systems, it converts entities, relationships,
and attributes into tables, keys, and columns.
✔✔Key - ✔✔A column used to identify rows of a table.
