Relational Database Management System or RDMS (Intro)


RDMS or Relational Database Management System is most and important topic for both developer and Administrator. This is the foundation for all newbie’s. Let's look out one by one...

1# what is RDBMS?
RDMS is a Database Management System (DBMS) that is based on relation model. RDMS concept invented by E.F.Codd of IBM. And much popular database management software like SQL, Oracle and DB2 are running under this concept.

2# what is Database?
Already I mentioned that RDMS is managing the database. Database is the organized collection of data. And it also collection of schema, tables, Query and Views.

3# what is table?
Table is set of data using row and column. A table contains minimum one row and column. In RDMS table is used for linking the one table to another table.

4# what is primary key?

Primary key is unique indentify field in a Database table. A table contains only one primary key. The main propose of primary key is to avoid duplicate records in a database table and avoid the NULL Values.

Comments

Post a Comment

Popular posts from this blog

Best Laptop under 30000 in India

Image
Best Laptops under 30000: Laptop has become the most important electronic device these days. Laptops come in various design, Configuration and price. Choosing the right laptop is more important depending upon what kind of user you are. Not able to find the best laptop under 30000? don't worry, we list out some of the best laptops under 30000 that you can consider before buying.  Here we've listed some of the top laptops under 25000-30000 price range. In this price range, You can own a laptop with i3 Processor, 4GB RAM and 1TB HardDrive loaded with latest windows OS.  Also Read:  Best Laptop Under 20000 in India Lenovo IdeaPad 320 Laptop Lenovo is one of the best manufacturers in laptop and PC  industries. Lenovo IdeaPad 320 is listed as one of the best laptop under Rs. 30000. Lenovo Ideapad is 6th gen laptop with 14 Inch, 1TB Harddrive, 4GB RAM and Intel i3 6th gen processor. Laptop comes with Windows 10 OS with one-year manufacturer warrant...
..[Continue Reading]

What is Database Management System

Image
         In a small , Medium or large industries, Maintaining data and retrieving the data is more important for improving their business it’s a normal one. We can’t maintain our data’s in paperwork especially in medium and large scale industries. So, we have to update and retrieve our data easy and quick way. Database is playing a major role in business Industries in getting the data . Database        A database is a program used to store data. A database is a contain at least one table to work with the data. And the table is a data structure used to store the information. The table will have at least  a row and a column to store the information. Database System      The database system is an overall collection of database and software component. With the help of third party tools user can create , update or delete and retrieve their data’s. Each client communicates with database indirec...
..[Continue Reading]

Today Deals: 40% Off on Fab phones fest and get more offer on Fashion, Laptop and much more product [06-Feb]

Amazon officially announced up to 40% offer on Mobile, Headphone and power banks and also get 5% discount on HDFC Credit and Debit Card. The offer is valid for 3 days from 5-7 of this February 2019. also, check out the best deals and offer available online. Today's deals online Amazon India Offer : Get upto 40% off on Fab Phone Fest Valid till : 7th March 2019  Offer :  Buy Women's Cloths under Rs. 599 only Flipkart  Offer : Get upto 80% off on Smart Devices Offer : Get upto 70% off on Sandwich Makers PayTM Mall Offer :  Get upto 65% off on Electric Water Purifiers Offer : Get upto 28% off on Laptops Snapdeal Offer :  Get upto 70% off on Women's Fashion Offer : Buy Makeup Under Rs. 699 only Tatacliq Offer :  Get upto 75% off on Kurtis & kurtas Offer :  Get upto 61% off on Earphones Jabong Offer :  Get upto 65% off on Fashion Myntra Offer :  Get upto 40% off on United Colors Of Benetton The Body Shop Offer :  Get upto 25% off on purchase above Rs. 2500 & Above Valid...
..[Continue Reading]