Q. 1. One of the drawbacks of using file systems to store data is “data redundan
ID: 3600845 • Letter: Q
Question
Q. 1. One of the drawbacks of using file systems to store data is “data redundancy” which leads to the “inconsistency” problem.
Explain in your own words, why this issue was considered as a drawback? Support your answer with an example and how they solved this problem later.
Q. 2. What are the principles of relational database model? What is the difference between RDBMS and DBMS? Which one is more suitable in modern database applications? Justify with your answer.
Q. 3. Discuss the differences between plsql and mysql?
Explain in your own words, please provide some examples.
Explanation / Answer
1.
Since File system data management rely on files only that contain
records as textual without any structural data.
they cannot relate data from one file to another.
For example, if one file contains an address record of Mr venkanna koothada,
another file that uses address information on Mr. Prudhvi has to
recreate that data.
The second file must duplicate the data. It means that the address
data on Mr. Prudhvi exists in two files at once.
On large scales, this leads to data redundancy that can quickly take
up space in the database and prove cost-inefficient.
2.Principles of Database Management System:
1.Representation data must be in Table Format.
2.Data must be Accessed by primary keys.
3.Null values can not be treated like Empty Values or blanks. will
follow some protocols.
4.Must be Follow Metadata Format.
5.Must able to perform all the Operations.inserting,updating,manipulating etc.
6.A single operation must be able to retrieve, insert, update, or delete data.
7.Integrity constraints must be available and stored in the
Relational Database metadata, not in an application program.
8.Any row processing done in the system must obey the same integrity
rules and constraints that set-processing operations.
Differences between DBMS and RDBMS:
-----------------------------------
DBMS:
------
The Full Form of DBMS is Database Management System.Which Stores the
Data in a File Format.i.e in hierarchical form.
because which uses the file system to store the Data.there is
relation between one file to another file.
It supports Single User only.Normalization is Not supported
DBMS has to provide some uniform methods independent of a specific application
for accessing the information that is stored.
Which does not support any constraints to manipulating the Data.
RDBMS:
--------
The Fullform of RDBMS is Relational Database Management System.in the
name itself tells that represent the data in a Relational
means stores the Data in a Table Format.that shows the relationship
between one table to another.
Which overcomes the Drawbacks of DBMS.
Here the tables have an identifier called primary key and the data
values are stored in the form of tables.
And Supports Normalization to compress the data.
Manipulating the data in a secured manner by supporting
ACID(Atomicity,correctness,Isolation,Durabilty) properties of the
table.
3. Difference Between pl/sql and Mysql
PL_SQL:
-------
PL-SQL is Oracle's "Procedural Language" SQL.It is Oracle's Flavour
of the Language.
i.e PLSQL is specific to Oracle.where Oracle is a is a Database
Management system software developed by Oracle.
Pl-SQL is a very powerful tool to store, manage and retrieve data.
It allows programmatic manipulation of SQL and result sets.
Note:It is very expensive to download and use.because it is not a free of cost.
PL/SQL is a combination of SQL along with the procedural features of
programming languages.
It supports object-oriented programming and structured programming
through functions and procedures.
It offers extensive error checking and Numeric DataTypes.
Important point:
-----------------
A PL/SQL language code can be stored in the client system
(client-side) or in the database (server-side).
MY-SQL:
-------
MySql: MySQL is developed, marketed and supported by MySQL AB.
It is also a software like Oracle and SQL Server. It is a Open Source Software
where SQL Server is also like Oracle but developed by Microsoft and
a powerful tool.
Even it is supported by Oracle Corporation.
Note:MySQL is open source Software that is we can download easily and use it.
Important point:
-----------------
MySQL is a database system that runs on a server
Mainly MQ-SQL is used on web applications.
even for large Applications.because of easy to use,veryfast and reliable.
Mainly compiles on any different platforms.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.