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