Revision database management system dbms
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Revision Database Management System (DBMS) PowerPoint PPT Presentation


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

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.

Download Presentation

Revision Database Management System (DBMS)

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

CustomerIDNameAddressCity

12345Jones123 ElmChicago

28764Adamz938 MainPhoenix

29587Smitz523 OakSeattle

33352Sanchez999 PineDenver

44453Kolke909 WestDenver

87535James374 MainMiami

Orders Table

OrderIDCustomerIDDateSalespersonTotal_sale

117123453/3/0688757.92

125875354/4/06663123.54

157123454/9/06554297.89

169295875/6/625589.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


  • Login