Database Application Overview The development of databases opened a new world fo

Question

Database Application
Overview
The development of databases opened a new world for the transition of data into usable information able to be manipulated for many different purposes through attributes and characteristics assigned by the user. The size can vary from small to massive and relationships between the traits broken down to very specific criteria. Assignment Instructions
Using research from the textbook, your readings, or the Internet, write a 1–2 page paper on the relational database management systems (RDMS): Describe the characteristics of a RDBMS. List and describe the major RDBMS vendors, including their RDBMS products and cost comparisons. Answer the question, "What makes a RDBMS 'relational'?" Database Application
Overview
The development of databases opened a new world for the transition of data into usable information able to be manipulated for many different purposes through attributes and characteristics assigned by the user. The size can vary from small to massive and relationships between the traits broken down to very specific criteria. Assignment Instructions
Using research from the textbook, your readings, or the Internet, write a 1–2 page paper on the relational database management systems (RDMS): Describe the characteristics of a RDBMS. List and describe the major RDBMS vendors, including their RDBMS products and cost comparisons. Answer the question, "What makes a RDBMS 'relational'?" Database Application
Overview
The development of databases opened a new world for the transition of data into usable information able to be manipulated for many different purposes through attributes and characteristics assigned by the user. The size can vary from small to massive and relationships between the traits broken down to very specific criteria. Assignment Instructions
Using research from the textbook, your readings, or the Internet, write a 1–2 page paper on the relational database management systems (RDMS): Describe the characteristics of a RDBMS. List and describe the major RDBMS vendors, including their RDBMS products and cost comparisons. Answer the question, "What makes a RDBMS 'relational'?"

Explanation / Answer

RDBMS

RDBMS stands for Relational Data Base Model

before going to rdbms.let us know what is dbms

=data base management system is a software lets us to store retrive and modify data

=these are things we done in dbms

RDBMS is one of the dbms model

before RDBMS we have models like

Hirerachal Model
Network Model

both the models are not so effecetive.hirearchal model models trees structure ,and network follows nodes ..both of them causes disadvantage in some factores called

insertion and updating etc

in order to over come these disadvantage,

cord a scientist comes up with new model called Realtional Data base Model

it have some 12 set of rules.if any data base satisfies these 12 set of rules it is relational database model

= In Relational Data base model everything is in form tables.

we establish a relation between these tables
we have rows and columns

=relational database is used for very efficient and fast storage of data.and it stores only structural data.cannot be used
for unstructural data.we use no sql databases called mongodb to store semi-structural datas

charecterstics of RDBS:

--->usage of keys
in RDBS we stated that everything is table.
so every row in table is uniquely identified by a key.(primary key)

--->in relational database for fields we can apply some constraints called what type of field etc

---->we can also provide privilages to each and every user

-->granting privilages is under data base administrator control

---->privalages are

to create
to delete
to update
etc

different vendorers

different vendors:

IBM provides DB2
Microsoft provdes Ms ACCESS and SQL server

Oracle provides Oracle

Informax provides informax

sybase provides sybase

Oracle:

Oracle is widely used for many organization

oracle comes up with 12c

cloud computing and extremen performace
most of organization goes for oracle

microsoft:

Ms Access is just for small type of data.not same performance like oracle

but SQL server comes up with good performance in concurrancy processing
and redundance

IBM
DB2 is works good in concurrancy control it gives best performance compare to oracle

IBM is the one who introducted SQL(STRUTURALAL QUERY LANGUAGE)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.