Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Build Applications - Database Management Systems - Lecture Slides, Slides of Introduction to Database Management Systems

Some concept of Database Management Systems are Access Methods Layer, Basic Structure, Common Structures, Designing Systems, Join Processing, Modern Computers, Query Evaluation Techniques. Main points of this lecture are: Build Applications, Build Applications, Major Components, Management System, Advantages, Database, Main Database, Management Systems, Database Management Systems, Databases

Typology: Slides

2012/2013

Uploaded on 04/27/2013

prakash
prakash 🇮🇳

4.6

(10)

63 documents

1 / 44

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Database Management Systems
1
Docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c

Partial preview of the text

Download Build Applications - Database Management Systems - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database Management Systems

1

Objectives

• What is a database?

• How are databases used to build applications?

• What are the major components of a database

management system?

• What are the advantages of using a database

management system?

• What are the main database management systems?

• How have database management systems changed

over time?

• What databases are used with this book?

• What are the first steps to start a project?

2

Goal: Build a Business Application

4

Tools:

Database Design

SQL (queries)

Programming

Design SQL Program

Design^ SQL^ Program

Best: Spend your time on design and SQL.

Worst: Compensate for poor design and limited SQL with programming.

DBMS: Database Management System

  • Database
    • A collection of data stored in a standardized

format, designed to be shared by multiple users.

  • Database Management System
    • Software that defines a database, stores the data,

supports a query language, produces reports, and creates data entry screens.

5

DBMS Application Design

7

1. Identify business rules.

2. Define tables and relationships.

3. Create input forms

and reports.

4. Combine as

applications for users.

DBMS Features/Components

  • Database engine
    • Storage
    • Retrieval
    • Update
  • Query Processor
  • Data dictionary
  • Utilities
  • Security
    • Report writer
    • Forms generator (input screens)
    • Application generator
    • Communications
    • 3GL Interface

8

Database Tables (Access)

10

Database Tables (Oracle)

11

DBMS Report Writer

13

All Data

Database Engine Data Dictionary

Query Processor

Report Writer

Report Format

and Query

Report Writer (Oracle)

14

DBMS Components

16

All Data

Database Engine Data Dictionary Security

Query Processor

Form Builder

Report Writer

Communication

Network

3GL Connector

Program

Application Generator

Advantages of Database Approach

• Minimal data redundancy.

• Data consistency.

• Integration of data.

• Sharing of data.

• Enforcement of standards.

• Ease of application development.

• Uniform security, privacy and integrity.

• Data independence.

17

Modifying Data with DBMS

  • Add cell number to

employee table

  • Open table definition
  • Add data element
  • If desired, modify reports
    • Use report writer
    • No programming
  • Existing reports, queries,

code will all run as before with no changes.

19

Field Name Data Type Description

EmployeeID Number Autonumber.. TaxpayerID Text Federal ID LastName Text FirstName Text

... Phone Text ...

CellPhone Text Cellular...

Web Databases

20

Developers

Database

Web Server

Web forms and reports

data

Users

Reports