Unformatted text preview: s software at the “back end.” BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 11 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 12 Why DBMS are Needed
Why DBMS are Needed Database Management Concepts
Management Concepts DBMS integrate, standardize, and provide
security for various applications.
X In the absence of integration, each type of
the absence of
each type of
accounting application such as sales, payroll,
and receivables will maintain separate,
receivables will maintain separate
independent data files and computer programs.
BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Y A B Application Two
X 13 BUSI 335 Y C D Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 14 Elements of the Database Approach Database Management
System Development Process X Y A B C D Applications
system Logical file 1
Application one XYAD
Logical file 3
Securit screened inquiry file
fil BUSI 335 XYAB XYCD U
S Transactions Transactions Logical file 2
Application two Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 15 User
Database User Queries
BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 16 Database Management Languages
Management Languages DBMS Features
• User Programs - makes the presence of the DBMS
transparent to the user.
th • Direct Query - allows authorized users to access data
without programming. • Application Development - user created applications.
• Backup and Recovery - copies database.
• Database Usage Reporting - captures statistics on
database usage (who, when, etc.)
database usage (who, when...
View Full Document
- Spring '12
- Relational model, William Tan, Carson Woo