Revision database management system dbms
Download
1 / 10

Revision Database Management System (DBMS) - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

Revision Database Management System (DBMS). Database. DBMS. Database Management Systems. DBMS is a collection of programs that enables you to store, modify, and extract information from a database. Reports and ad hoc queries. Programs. Sales and transaction data. Programmer. Analyst.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Revision Database Management System (DBMS)' - murphy-stephenson


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
Revision database management system dbms

RevisionDatabase Management System (DBMS)


Database management systems

Database

DBMS

Database Management Systems

DBMS is a collection of programs that enables you to store, modify, and extract

information from a database

Reports and

ad hoc queries

Programs

Sales and transaction data

Prepared by:Natalie Rose


Dbms people

Programmer

Analyst

Programs

& Revisions

Ad Hoc Queries

and Reports

Data Collection

and Transaction

Processing

DBMS & People

Database Administrator

(Standards, Design, and Control)

Data

Database

Management

System

Managers

Program

Program

Business Needs

Business Operations

Prepared by:Natalie Rose


Relational databases
Relational Databases

  • Tables

    • Rows

    • Columns

    • Primary keys

  • Data types

    • Text

    • Dates & times

    • Numbers

    • Objects

Customer Table

CustomerID Name Address City

12345 Jones 123 Elm Chicago

28764 Adamz 938 Main Phoenix

29587 Smitz 523 Oak Seattle

33352 Sanchez 999 Pine Denver

44453 Kolke 909 West Denver

87535 James 374 Main Miami

Orders Table

OrderID CustomerID Date Salesperson Total_sale

117 12345 3/3/06 887 57.92

125 87535 4/4/06 663 123.54

157 12345 4/9/06 554 297.89

169 29587 5/6/6 255 89.93

Prepared by:Natalie Rose


Database advantages

Focus on data

Stable data

Programs change.

Data independence

Change programs without altering data.

Data integrity

Accuracy.

Time.

Concurrency.

Security.

Ad hoc queries

Speed of development

Report writers.

Input forms.

Data manipulation.

Flexibility & Queries

Database Advantages

All Data Files

Database Management

System

Invoice

Program

Billing

Program

Prepared by:Natalie Rose


Linking tables
Linking Tables

The Orders to ItemsSold relationship enforces referential integrity.

One Order can list many ItemsSold.

Prepared by:Natalie Rose


Database administration
Database Administration

  • Database Administrator

    • Testing

    • Backup

    • Recovery

    • Standards

    • Access Controls

Prepared by:Natalie Rose


E business databases
E-Business Databases

  • E-business is transaction-based

  • Databases support multiple users and protect transactions

  • Modern websites are driven by databases

Prepared by:Natalie Rose


E business databases1
E-Business Databases

Order Form

Descriptions

Prices

Web page

Internet

Customer

Page request

Web Server

Web program script

<HTML>

Text

<%

Database connection

%>

Queries

and data

Prepared by:Natalie Rose


Cases pharmaceuticals
Cases: Pharmaceuticals

How do you store and retrieve huge amounts of data?

Prepared by:Natalie Rose