The Database and Database Management System - PowerPoint PPT Presentation

1 / 20
About This Presentation
Title:

The Database and Database Management System

Description:

Spreadsheet as a Simple Database ... 5. Sybase. 9-6. The Database Concept. Database concept. Data redundancy. Data inconsistency ... – PowerPoint PPT presentation

Number of Views:257
Avg rating:3.0/5.0
Slides: 21
Provided by: georgesche
Category:

less

Transcript and Presenter's Notes

Title: The Database and Database Management System


1
  • The Database and Database Management System

9-1
2
Data Organization
  • Data Field
  • Record
  • File

9-2
3
Fundamental Building Blocks for Database
Structures
1. Data Value - SS 2. Data Field - Column 3.
Data Record -Group 4. Data File Whole Table
9-3
4
Spreadsheet as a Simple Database
  • Rows and columns of a spreadsheet can be regarded
    as a simple database
  • Flat files

9-4
5
Database Structures
  • Database
  • Database Management System (DBMS)
  • Hierarchical structure
  • Network structure
  • Relational structure

9-5
6
Relational Database Vendors
1. IBM 2. Informix Software, Inc. 3. Microsoft 4.
Oracle 5. Sybase
9-6
7
The Database Concept
  • Database concept
  • Data redundancy
  • Data inconsistency
  • Data independence

9-7
8
Evolution of Database Software
  • SEQEL from IBM
  • Continuation of IMS
  • Renamed SQL
  • Structured Query language
  • Embedded within traditional language
  • Standalone

9-8
9
Knowledge Discovery in Databases (KDD)
  • Data warehousing
  • Data mart
  • Data mining

9-9
10
The Database Administrator (DBA)
  • D B A Duties
  • Database planning work with users and others,
    define schema, etc.
  • Database implementation creating the database
    and enforcing policies and procedures
  • Database operations
  • Database security

9-10
11
DBMS Advantages DBMS Disadvantages
9-11
12
Creating a Database
  • 1) Describe the data
  • 2) Enter the data
  • 3) Use the database
  • Query language DBMS provides data access via
    SQL
  • Query-by-example DBMS query language contains 2
    components.
  • -DDL
  • -DML
  • Data manipulation language (DML) Defines the
    structure in which data are housed.
  • DML allows users to Extract the Data from Database

9-12
13
Tables
Book Name
Author
Required Banking Principles
Knox
25 Management Information Systems 8E
McLeod and Schell 75 Personal Sales
Techniques Wei
70 Quality Service, Quality
Customer Brutus
54
9-13
14
Description of Book Table
9-14
15
Description of Student Table
9-15
16
Table Relationships
9-16
17
Rule for Required Field
9-17
18
Enforcing Value of BookName
9-18
19
Query-by-Example
9-19
20
Ready for Wednesday
  • Cook Library 404 600PM
  • FORMS and ACCESS
Write a Comment
User Comments (0)
About PowerShow.com