Exam (elaborations)
Dbms-pdf - Bss Copmuter Science Module I:Database Management system
- Course
- Institution
Dbms-pdf - Bss Copmuter Science Module I:Database Management system
[Show more]
Seller
Follow
Content preview
9/18/24, 1:49 Dbms-pdf - Bss Copmuter Science Module I:Database ManagementPM system
INTRODUCTION TO DATABASES
A collected information which is in an organized
form for easier access, management, and various updating
is known as a database. Database Management System or
DBMS must have some means of representing the data in
a way that user can easily understand. A DBMS provides
users with the conceptual representation of data.The
system hides certain details regarding data storage and
maintenance and data is retrieved efficiently.
File System Vs. DBMS
A comparison between a file processing system
and a DBMS is given below:
DBMS File Processing System
It is a shared set ofdata that is
logicallyrelated. It describes the data It is a set of application
designed tomeet the information programs that serves the end –
requirements of an organization users in various ways, such as
by producing reports. Each
program defines and manages
its own data.
about:bl 1/
,9/18/24, 1:49 Dbms-pdf - Bss Copmuter Science Module I:Database Management
PM system
Redundancies and inconsistencies in Redundancies and
data are reduce due to single file inconsistencies in dataexist due to
formats and duplication of data is single file formats and duplication
eliminated
Data is easily accessed due to Data cannot be easily
standard query procedures. accessed due to special
application programsneeded
to access data.
Isolation / retrieval ofthe required
data is possible due to common Data isolation is difficultdue to
file format and there areprovisions different fileformats and also
to retrieve data easily becausenew application
programs have to be written.
It provides programand data
There is a dependency between
independence.
application programs and data.
This is because, definition of
data is embedded in the
application program rather than
stored separately.
Integrity constraints, whether new or Introduction of integrity
old, can be enforced as per need. constraints is tedious and new
Data integrity is determined on the application programs have to be
data itself written in order to determine
data integrity in each
application
Atomicity of updates ispossible.
Atomicity of updatesmay not be
maintained.
Several users can access data at the Concurrent accesses maycause
same time, ie, concurrently without problems, such as
about:bl 2/
, 9/18/24, 1:49 Dbms-pdf - Bss Copmuter Science Module I:Database Management
PM system
about:bl 3/
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EXAMSHAVEN1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now