Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Database Management Systems

To view before taking Database Quiz
by

Maria Craig

on 21 June 2016

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Database Management Systems

Databases
Do you agree with this statement?
"Data is power."
Why or why not?

People
need
data.
A
database

is a collection of related data or facts.
So, does a database have to be digital?
What type of database do you have at home that is not digital? You probably have three or four and never look at them.
A
database management system

(DBMS) is a software tool that allows people to store, access, and process data or facts into useful information.
A database is made up of fields, records and tables.
A
field
is a single unit of data. Fields make up records.
A
record
is a complete set of fields. Records make up tables.
Tables
store information in a database.

It is a group of records.
A
flat-file database
has only one table. A phone book would be a good example.
A
relational database
is a database made up of a set of tables. A common field in any two tables creates a
relationship
between the tables.
Here's a real-life example:
Database
- NGA (all information for the entire campus)
Tables
- Profile, Gradebook, Class Schedule, Course History, Health, Discipline
Records
- each student is a record
Fields
- last name, first name, ID#, date of birth, social security number, address, city, state, zip code, mother's name, father's name, home phone number, cell phone number, email address, etc.
Imagine this:
Database
- Food for Pot-Luck Social
Tables
- Meal, Drinks, Dessert
Records
- each dish or drink
Fields
- name of dish, who made it, ingredients, keep it warm or cold?, return the dish?, etc.
Data management falls into one of three general categories:
Entering data into the database
Sorting the data - arranging or reordering the database's records
Obtaining subsets of the data
One way
to get a subset of records from a table is by using a
filter
.
A
filter
works just like a coffee filter. It keeps out what you don't want (the grounds) and gives you what you do want (coffee).
An Access database has 4 main
objects
:
Form
Table
Query
Report
A
form
is used to enter records into a table. It is a custom view of the table and usually shows only one record on the screen at a time.
A
table
is a group of records. It stores information in the database.
A
query
asks a question. It is used to locate records, perform calculations, delete obsolete records and other database management tasks.
There are several types of fields:
Text fields - alphanumberic characters
Numeric fields - only numbers
Date or Time fields
Logical fields - yes or no
Binary fields - for graphics
Counter fields - autonumber or unique ID
Memo Fields - description
When data is entered into a field a
mask
can be used to control the entry's display format. You could have a
mask
for a telephone number. Type in 9729374780 and it would apear as (972) 937-4780 in your table.
There are three
query language
s:
SQL

- an English-like query language
Xbase
- generic query language derived from DBase
QBE
- Query By Example - graphic interface, used in Access - specify the search criteria by typing values or expressions into the fields of QBE form or grid.
We'll be using Microsoft Access but there are other database programs available such as:
Dbase
Filemaker
My SQL
Quickbase
Soho
So what careers are database-related?
Administrative assistant
Clerk
Data-entry specialist
Telemarketer
Help desk personnel
Product support specialists
Software engineers
Database programmers
Database developer
Database administrator
System Analyst
A
report
is printed information
created from a query.
Full transcript