Question

Explain the three level DBMS architecture with the help of an example. Also, explain the concept of data independence in the context of database systems with the help of an example. 

13 Sep 2024
Answer :
Word Count : 817

### Three-Level DBMS Architecture

The three-level database architecture is a framework that describes the structure of a Database Management System (DBMS) in terms of three different levels: the internal level, the conceptual level, and the external level. This architecture aims to provide a clear separation between how data is stored and how it is viewed by users. Let’s break down each level and use an example to illustrate the architecture.

#### 1. Internal Level

The internal level, also known as the physical level, is the lowest level of the DBMS architecture. It describes how the data is physically stored in the database. This level involves details like file structures, indexing methods, and the storage allocation. It focuses on the efficiency of data retrieval and storage, which involves the hardware and storage devices.

Example: Consider a university ______ ________ __________ ______ ______ __________ ________.
__________ ____ ___ ___ ___ __________ __________.
__________ __________ _________ ____ ___ ___ _______ _____ _____ _______.
_______ ___ __________ __________ ______ ________ ________ _________.
_________ __________ _________ _______ __________ _______ ____ ____ _______ _____.
____ ___ ________ __________ ______ _________ ________ _____.
__________ _____ __________ ____ ____ ____ _____ _________ __________ _________.
______ ___ ______ __________ _______ _______ __________.
__________ ___ __________ _____ ________ ________ ______ _________ _______.
____ _________ _______ _____ ______ _____.
______ __________ ___ _____ _______ ______ __________ ________ ___ ___.
____ __________ ________ __________ ______ ________ ______ __________ ___ _________ __________ _______.
_____ ______ ____ ___ ___ ______ _________ __________ ____.
______ ___ ___ ______ __________ _______ _________ ____ ________.
____ _____ ____ ________ _____ _______ _______ ___.
_________ ___ ____ ______ ________ __________ _________.
_______ ___ __________ ____ ____ __________ ______ _________ ________ ______ ________.
_____ __________ ______ _____ ____.
___ _________ ______ ___ __________ _______ _________ _______ __________ _____.
_________ ____ __________ ___ ______ ______ ______ __________ _____ __________.
__________ _______ __________ _____ __________ __________ _________ _______ ________ ________ ________ __________.
___ ___ ________ _____ ____ _______.
___ ________ _____ ___ ______ _____ ___ _______ ______.
____ ____ ____ _________ _____ ______ _____ ________.
______ _____ _______ ___ _______ ________ _________ ____.
________ _______ _____ _________ ____ ____ _______ _____ ______ ___ ___.
__________ ____ _______ _________ _________ ______ ___.
_________ ______ ________ ____ ______ _______ _________.
________ ________ _________ _____ _____ ___ _____ _______ _____.
____ _________ _________ ________ ______ _____ _____ __________ __________ _________.
_________ ______ ________ ______ _____ _________ _______ __________ ________ ______.
____ _________ __________ _____ ____ _________ _________ ____ ____.
__________ _____ ________ ______ ______ __________ ________ ____ ________ _________ _________ ______.
__________ _______ _________ ______ _____ _______ _____ __________ _________ _____ ____ _____.
_____ _______ _______ ___ ___ ____.
___ ______ __________ ________ _________ _______ ___ ____ ____ _____ ________ ___.
_______ _______ ____ ________ _____ ___ ___ __________ ____ ____.
_______ _________ _________ _____ __________ ___ ______ __________ ________ ___.
__________ _____ _______ ________ __________ ______ ______ _________ ___ ____.
____ ____ _______ ___ ____ ________ ________ _______.
__________ _______ _______ _____ _________ ____ _______ ___ ______ ___ ______.
_______ ________ ________ _________ _________ _______ _______ __________ ________ _________ ___.
______ _____ __________ _____ ________ _______ ___ _______ ______ _______.
______ _______ ______ _________ _________ ________ ______.
_________ ________ _________ ________ _____ __________ _______ __________ ___ ________.
_____ _______ ________ _______ _______ _____ _______.
_____ _______ ___ ____ __________.
__________ ________ ______ ________ ______ _____ ________ _________ ___ __________ ___ ____.
____ ________ _____ _________ ___ ___ ____.
______ _____ __________ ________ __________.
_________ ______ ____ ________ __________ _______.
__________ __________ ________ ___ ________ _______ ______.
_______ ___ ________ __________ _________ _____ ___ _____ _________ _______ _________.
_______ _________ _________ _____ _______ ____.
_____ ____ ___ _______ ______ ________ ___ _______ __________ ____ ___ __________.
__________ ____ __________ ______ __________ __________ ____ _________ ______ __________.
____ ____ _____ _________ _____ ________ ___.
________ ___ ________ ______ _________.
____ ___ ___ _______ _________ __________ ________ ______.
________ ____ ___ ________ ______ ______ ____.
___ ______ ____ ______ _______ ______ ______ ______ ____ ____.
__________ _________ _________ __________ ____ _____ _____.
_________ __________ ____ ________ ________ ____ ______.
____ ________ ________ _______ _________ ________ ________ ________ __________ _____ _______.
_______ _________ ______ ____ ________ __________ _______ ____ ______ ____ _________ __________.
_____ _________ ______ _______ ____ _________ _________.
________ ________ _____ ___ ___ ________.
________ ________ ___ __________ _______ _______ _________ ______ ___ _________ ____.
______ ___ ______ ______ _____ ________ ___ ________.
________ ______ ____ ______ ______ ___ ________ __________ ______ __________ _________ ________.
__________ ________ ________ ___ _______ _____ ___ _________ __________ ______ ___ __________.
_____ _____ ___ __________ _________.
_________ _________ ______ _____ _____ _________ ______ ________ ________ __________ _____ ___.
________ __________ ___ __________ __________ ___ ____.
___ ____ ______ ________ ____ ___ _________ ________ _____ ____ ________ ___.
_______ ______ ________ ___ ________.
_____ ____ ___ _________ _______ ____ ______.
_______ _____ __________ _________ ___ ___ __________.
Get Full Answer on WhatsApp

Related Questions

) Explain the Log based Recovery with the help of an example. What are Redo and Undo operations. Why do you need checkpoint? Explain the process of recovery with check points with the help of an example Explain with the help of an example, how recovery is performed when Deferred database modification scheme is used.

Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints

Consider the following relational database:

Customer (custId, custName, custAddress, custPhone)
Account (AccountNumber, custId, TypeOfAccount, Balance)
Transaction (DateTimeofTransaction, AccountNumber, DebitORCredit, Amount)

The underlined attribute(s) in the relation forms the primary key. In relation Customer, the custID is
the unique identifier of a customer. The purposes of other attributes in Customer relation are self
explanatory. You may define the domain of different attributes. The TypeOfAccount attribute can
take the value (“Saving”, “Current”, “Salary”, “Other”). Please note that at a specific time of a date
only one transaction can be performed from an account. Please also note that the Account relation
has foreign key custID and Transaction relation has foreign key AccountNumber. Write and run the
following SQL queries on the database:
(i) Create the tables with the primary and foreign key constraints.
(ii) Insert at least 5 records in the first 2 tables and 20 records in the 3rd table.
(iii) List “Saving” Account details showing the AccountNumber, custName, custPhone,
Balance of all the accounts. These records should be shown in the order of custName.
(iv) Find all the transactions made by customer whose custID is “240002”.
(v) Find the list of those customers who have more than one account.
(vi) Find the total of Debit transactions made for Account Number “A0054”
(vii) Find the total of balance of all the accounts of a customer.
(viii) Find the list of customers whose name start with an alphabet “B”
(ix) List the pair of customers who share the same phone number.
(x) Find the list of the customers, who have not made any credit transaction since 1st January,
2023.

What is the cost of selection operation, when the index scan method is used? Explain with the help of an example. Explain the cost of Join operation when Merge-Join method is used.

What are the problems that can be encountered, if the three transactions (given in Figure 1) are run concurrently? Explain with the help of different transaction schedules of these transactions.

 

    Transaction  A

       Transaction  B       Transaction  C
        Read  X        Read  X          Read X
        Read  Y        ADD    500           SUBTRACT 200
        Raed  Z        W r i t    X             WRITE  X
         Read   Y  
       SUBTRACT  500  
        W r i t e Y  

                              Figure 1: Three Concurrent Transactions

 Write short notes on the following database technologies: (i) Distributed databases (ii) Block chain databases

Make the query tree for the following query (assume the database of problem 2(d)).

SELECT c.custName, c. custId, a.AccountNumber, t.DebitORCredit
FROM Customer c, Account a, Transaction t
WHERE c.custId = a.custId AND a.AccountNumber = t.AccountNumber
AND Amount > 10000;

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login Cart
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★
Top
📞
Call Support Instant phone assistance Explain the three level DBMS architecture with the help of an example.
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→