Difference Between DBMS and File Processing System

       Difference Between DBMS and File Processing System:

            DBMS

      1. Redundancy is controlled

.     2.Unauthorised access is restricted.
      3. Providing multiple user interfaces.

4    4. Enforcing integrity constraints.

5    5. Providing backup and recovery.

              File Processing System

        1. Data redundancy & inconsistency.

       2. Difficult in accessing data

      .3. Data isolation.

       4. Data integrity.

       5. Concurrent access is not possible.

      6. Security Problems. Hope you got it

Data base

Datebase Mampulation language

terdiri dari :

- procedural

- Non procedural

 

We define an SQL relation by using the create table command:
create table r(A1D1,A2D2, . . . , AnDn,
integrity-constraint1
,
. . . ,
integrity-constraintk
)

The enterprise that we use in the examples in this chapter, and later chapters, is a
banking enterprise with the following relation schemas:
Branch-schema = (branch-name, branch-city, assets)
Customer-schema = (customer-name, customer-street, customer-city)
Loan-schema = (loan-number, branch-name, amount)
Borrower-schema = (customer-name, loan-number)
Account-schema = (account-number, branch-name, balance)
Depositor-schema = (customer-name, account-number)