Intro-ish Flashcards

1
Q

What are the levels of Database Architecture?

A
  1. External - what the user sees,
  2. Internal - how the computer physically stores the database,
  3. Conceptual - the logic of the database’s operation.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the importances of data modelling?

A
  1. It helps with efficient computerisation,
  2. It represents the real world.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the ER model?

A

The Entity Relationship model is a blueprint for designing databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the main concepts of an ERM?

A
  1. Entities,
  2. Relationships,
  3. Attributes (characteristics of entities),
  4. Cardinality
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the properties of ERD?

A
  1. Entities are represented with rectangles,
  2. Characteristics are represented by ovals,
  3. Relationships by diamonds,
  4. Cardinalities by their respective numbers.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is an entity in an ERD?

A

It is a noun; it is the basic or conceptual element of an ERD that exists on its own.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a relation?

A

A relation is the association between two or more entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the Enhanced Entity Relationship Model?

A

The EER model is a data model with more extensions to the ER model, including superclasses, subclasses, specialisation and generalisation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are superclasses?

A

Groups of entities which share common attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a superclass (supertype)?

A

A group of entities that share common attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is a subclass (subtype)?

A

Subsets of an entity (superclass) from which it inherits attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is specialisation?

A

The act of breaking down an entity into smaller entities which share common attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is generalisation?

A

Process of pooling different but related entities into a single entity (superclass).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Who is a database administrator?

A

One who designs and manages a database.

They are responsible for administrative parts as well as acquiring hardware and software required to maintain database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Who are application designers and programmers?

A

They create and maintain the program that accesses the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Who are the end users?

A

The people who access the database for the information it holds.

17
Q

In converting from a conceptual (analysis) to a physical (implementation) model, what are the key notes or transformations?

A
  • Entities become tables
  • Attributes become columns
  • Primary unique identifiers become primary keys
  • Secondary unique identifiers become unique keys
  • Instances become rows
18
Q

What are the types of database languages?

A
  1. Data Definition Language (DDL): used to create schema or structure of the database.
  2. Data Manipulation Language (DML): used to manipulate (add, delete, insert) instances (data) in the database.
  3. Data Control Language (DCL): is used to manage who has access to the database.
19
Q

What is schema?

A

Structure or design of the database.

20
Q

What are instances?

A

Data itself stored in the database.