Database - PowerPoint PPT Presentation

1 / 9
About This Presentation
Title:

Database

Description:

primary key - a field whose values uniquely identifies each record in a table ... writer's phone number. per article payment. writer's id (social security number) ... – PowerPoint PPT presentation

Number of Views:45
Avg rating:3.0/5.0
Slides: 10
Provided by: gatew242
Learn more at: http://www.cs.uwyo.edu
Category:
Tags: database | is | number | phone | this | whose

less

Transcript and Presenter's Notes

Title: Database


1
Database
  • A collection of related information stored on a
    computer and organized in a manner that allows
    access, retrieval, and use of that data.

2
Data Hierarchy
  • field - a single fact or data item
  • record - a collection of fields that hold related
    information
  • table - a collection of related records
  • database - a collection of related tables, forms,
    reports, and queries

3
Example
Customer Table
Order Table
4
Relational Database
  • allows you to connect records from different
    tables
  • records are connected through a common field that
    appears in both tables
  • primary key - a field whose values uniquely
    identifies each record in a table

5
Table Creation Process
  • identify the individual fields
  • group the fields for each table
  • common field
  • primary key
  • set up the record structure in the table design
    view
  • field names
  • field (data) types
  • field length
  • other field properties
  • enter the data

6
Set up a database to store information about
freelance writers and articles sent to the
magazine you work for.
  • writers name (first and last)
  • title of the article, subject
  • issue, page number, length
  • writers address
  • writers phone number
  • per article payment
  • writers id (social security number)
  • writers email address

7
Group fields
  • Writers Table
  • last name
  • first name
  • address
  • email address
  • phone number
  • per article payment
  • writers social security number
  • Article Table
  • title
  • subject
  • issue
  • page numbers
  • length
  • writers social security number

8
Setting up the Record Structure
  • Naming fields - be descriptive
  • Choose field types text, memo, number,
    currency, date/time, autonumber, Yes/No, OLE
    object, hyperlink
  • Set other field properties such as
  • field size
  • format
  • data validation

9
Other Database Terminology
  • design view
  • datasheet view
  • forms
  • reports
  • queries
  • macros
  • modules
Write a Comment
User Comments (0)
About PowerShow.com