DataBases

更多类似内容

The Pursuit of Happyness

由Shem Kasahwni - Rick Hansen SS (2542)

You dont know me

由maria josé Giraldo

THE FIGHT CLUB - ENGLISH PROYECT DELIEVER NO. 1

由Andrea Morales

Great Gatsby Characters

由Natasha Walker

DataBases

Relationship types

Many to Many

One to Many

One to one

Data Types

Currency

Data is stored in a curtain format so is shown properly

Date/Time

Only Date or time can be entered into this data type

Boolean

The only data that can be stored here is YES or NO

Number

The user can only enter a number (if the number starts with a "0" the Zero is removed, if the number starts with a zero it is best to use Text instead.

Text

Can enter a number, or characters (this includes Special Characters)

Unique Identifier

The unique number given to each Record in the File

DataBase storage types

Relational DataBase

makes use of multipule files, and linked together using relationship Keys

> easy to find Data

> Data is hard to repeat

>

Flat File Database

This DataBase type makes use of a single file to store all data entered.

Disadvantages

> Data will be repeated

> Information can be incorrectly entered

> single use

> Hard to understand

Advantages

> Fast to set up

> all in one place