Title: The Database and Database Management System
1- The Database and Database Management System
9-1
2Data Organization
9-2
3Fundamental Building Blocks for Database
Structures
1. Data Value - SS 2. Data Field - Column 3.
Data Record -Group 4. Data File Whole Table
9-3
4Spreadsheet as a Simple Database
- Rows and columns of a spreadsheet can be regarded
as a simple database - Flat files
9-4
5Database Structures
- Database
- Database Management System (DBMS)
- Hierarchical structure
- Network structure
- Relational structure
9-5
6Relational Database Vendors
1. IBM 2. Informix Software, Inc. 3. Microsoft 4.
Oracle 5. Sybase
9-6
7The Database Concept
- Database concept
- Data redundancy
- Data inconsistency
- Data independence
9-7
8Evolution of Database Software
- SEQEL from IBM
- Continuation of IMS
- Renamed SQL
- Structured Query language
- Embedded within traditional language
- Standalone
9-8
9Knowledge Discovery in Databases (KDD)
- Data warehousing
- Data mart
- Data mining
9-9
10The 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
11DBMS Advantages DBMS Disadvantages
9-11
12Creating 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
13Tables
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
14Description of Book Table
9-14
15Description of Student Table
9-15
16Table Relationships
9-16
17Rule for Required Field
9-17
18Enforcing Value of BookName
9-18
19Query-by-Example
9-19
20Ready for Wednesday
- Cook Library 404 600PM
- FORMS and ACCESS