Introduction to databases
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Introduction to Databases PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

Introduction to Databases. Data vs. Information. Data – a collection of facts made up of text, numbers and dates: Murray 35000 7/18/86 Information - the meaning given to data in the way it is interpreted:

Download Presentation

Introduction to Databases

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Introduction to databases

Introduction to Databases


Data vs information

Data vs. Information

  • Data – a collection of facts made up of text, numbers and dates:Murray 35000 7/18/86

  • Information - the meaning given to data in the way it is interpreted:

    Mr. Murray is a sales person whose annual salary is $35,000 and whose hire date is July 18, 1986.


What is the ultimate purpose of a database management system

What is the ultimate purpose of a database management system?

Is to transform

Data

Information

Knowledge

Action

Data driven decision making


What is a database

What is a Database?

  • A structured collection of related data

  • A filing cabinet, an address book, a telephone directory, a timetable, etc.

  • Google and your email

  • School Student Information System


Basic database concepts

Name: Barry HarrisCollege: MedicineTel: 392-5555

Basic Database Concepts

  • Table

    • A set of related records

  • Record

Name: Barry HarrisCollege: MedicineTel: 392-5555

  • A collection of data about an individual item

  • Field

Name: Barry Harris

  • A single item of data common to all records


An example of a table

An Example of a Table

Fields

Records


Primary keys foreign keys

Primary Keys & Foreign Keys

To ensure that each record is unique in each table, we can set one field to be a Primary Key field.

A Primary Key is a field that that will contain no duplicates and no blank values.


What is a relational database management system rdms

What is a Relational Database Management System (RDMS)?

A relational database is a collection of tables from which data can be accessed in many different ways without having to reorganize the database tables.

DON’T DUPLICATE DATA

  • That is, once relationships are created, tables can “talk” to each other. We can link (relate) the tables to find data from many different tables.


Introduction to databases

Relationships

Foreign Keys are keyslinkto data in other tables


Input data with forms

Input Data with Forms

  • A friendlier view of the database

  • Used for data input, menus, display and printing

  • Can perform calculations and combine fields


Queries

Queries

  • A means of asking questions (querying) of your data

  • Can look across a number of Tables and other Queries

  • Can perform Calculations and Combine fields


Introducing reports

Introducing Reports

  • Output of information in a printed report

  • Allows you to group and summarize data

  • Can perform calculations and combine fields

  • Cannot edit data

  • Can make labels


Database options

Database Options

Enterprise RDMS

  • Oracle

  • IBM/DB2

  • MS SQL-server

  • Sybase

  • Informix

  • Lotus Notes

  • MySQL (Open Source)

  • Postgres (Open Source)

Consumer

  • Microsoft Excel

  • Microsoft Access

  • FileMaker Pro

  • MySQL (Open Source)

  • Postgres (Open Source)


Introduction to databases

SQL

  • Structured Query Language (SQL) is used for relational database “programming.”

  • SQL is the most commonly used programming language in the world


  • Login