Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

Databases by Mind Map: Databases
0.0 stars - 0 reviews range from 0 to 5

Databases

Best definition : stores both data + relationships between the data.   Provides a query language : series of non-programming-level commands for non-technical users to generate reports and retrieve information.

Notes

Physical view : how information is physically stored on your hardrive. Logical view : how they access information (english language)

Scalability

Is it modular? Can it be adapted to increasing demands?

Performence

How quickly can you erfom a certain transaction?

Functions

Redundency

Inconsistency

Integrity

Protection

Security

Passwords, Access levels.  Certain ppl can accesscertain things. Access control. Read-only for ex.

New node

Four components

Data Definition

creates, maintains the data dictionary and the structure of the database.

Data dictionary, Variable names, Each field has a name., Business rule, Validation rule, Duplicate, Keys, Foreign key, Primary key

Data manipulation

Allows to create, update, read and delete information in a database.

Query-by-example

Structured query language

Data

Relationships

one-to-many

relationship : 1 customer can have many orders, but one order belongs only to one customer.

many-to-many

students and classes many students can have one class and many classes can have students

one-to-one

mayor-city for ex. married to one -- recursive relationship.