Midterms - Data models

Question 1

A collection of concepts for describing the data in a database

Answer 1

Data Model

Question 2

A description of a particular collection of data using a given data model

Answer 2

Schema

Question 3

Data Models

Answer 3

Relational
Key/Value
Graph
Document
Column-family
Array/Matrix
Heirarchial
Network

Question 4

The defintion of relations and their contents

Answer 4

Structure

Question 5

Ensure the database contents satisfy constraint

Answer 5

Integrity

Question 6

How to access and modify the data in the database contents

Answer 6

Manipulation

Question 7

is an unordered set that contain the relationship of attributes that represent entities

Answer 7

Relation

Question 8

is a set of attribute values (also known as domain) in the relation

Answer 8

tuple

tuples = rows, records in a table

Question 9

uniquely identifies a single tuple

Answer 9

Primary Key

Question 10

Specifies that an attribute from one relation has to map a tuple in another relation

Answer 10

Foreign Key

Question 11

DML

The query specifies the (high level) strategy the DBMS should use to find the desired result

Answer 11

Procedural

Question 12

DML

The query Specifies only what data is wanted and not how to find it

Answer 12

Non-procedural