Q4 – How do database applications make databases more useful?

Download Report

Transcript Q4 – How do database applications make databases more useful?

Using MIS 2e
Chapter 5
Database Processing
MARIA DEL MORAL
GROUP F
Q4 – How do database applications make
databases more useful?

A database application includes forms, reports, queries, and
applications programs available to one or more users.

A database application includes forms, reports, queries, and
applications programs available to one or more users.
Fig 5-10 Use of Multiple Database
Applications
Q4 – How do database applications make
databases more useful?
 Data entry forms are
used to read, insert,
modify, & delete data.
 Reports are used to
show data in a
structured context as
the example to the right
shows.
Fig 5-11 Example of a Student Report
Q4 – How do database applications make
databases more useful?
 A query form helps the
user quickly find
answers to questions. In
this case, the words
“barriers to entry” were
found in Baker’s record.
Q4 – How do database applications make
databases more useful?
 Database application programs process logic specific to a given business
need. For example, a program could track backordered items and hold a
customer order until the items are ready to ship.
 Application programs enable database processing over the Internet as the
figure below shows. Users access the applications programs on a Web
server, which in turn accesses a single DBMS and database.
Fig 5-13 Four Application Programs on a Web Server Computer
Q4 – How do database applications make
databases more useful?
 This figure depicts multi-user database processing. The system
must be managed properly to avoid the following problems:
 Potential update loss because two users update same data at the same
time
 Potential locking problems
 Possible data conflicts
Q4 – How do database applications make
databases more useful?
Here’s a comparison of an Enterprise DBMS versus a Personal
DBMS.
 Enterprise DBMS
 Personal DBMS
 Large organizational and workgroup
databases

Thousands of users
 Many different database applications
 24/7 operations
 DB2, SQL Server, Oracle




Smaller, simpler applications
Personal or small workgroup applications
Fewer than 100 users
Microsoft Access is both a DBMS and
application development product as this
figure depicts.
Fig 5-14 Personal Database System