Chpt_5_outline_-_DBMS

Chpt_5_outline_-_DBMS - CHAPTER 5 DATABASE MANAGEMENT...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
CHAPTER 5 – DATABASE MANAGEMENT SYSTEMS Two approaches to storing business event information Applications approach – o Disadvantages o Advantages Program 1 Program 2 Program 3 A,B,C X,B,Y L,B,M User 2 Transaction User 1 Transaction User 3 Transaction DATA
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database approach – o Advantages: o Disadvantages: Database Management Systems DBMS – Program 1 Program 2 Program 3 User 2 Transaction User 1 Transaction User 3 Transaction DATA BASE A, B, C, X, Y, L, M
Background image of page 2
Advantages: Schemas and subschemas Disadvantages Types of database structures 1. Hierarchical structure – Program 1 Program 2 Program 3 User 2 Transaction User 1 Transaction User 3 Transaction DATA BASE D B M S A, B, C, X, Y, L, M Customer Invoices Receipts Line Items Parent Child/ Parent Child Can only represent One-to-Many or One-to-One Relationships
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2. Network structure – Customer Invoices Receipts Line Items Can represent One-to-One, One-to-Many, Many-to-One, or Many-to-Many Relationships Sales Person
Background image of page 4
3. Relational structure –
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

Chpt_5_outline_-_DBMS - CHAPTER 5 DATABASE MANAGEMENT...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online