RDBMS is Relational Database Management System.Examples are SQL,Oracle,DB2
We saw that excel sheet can be called as a database as it also stores the data.Morover we can store say Customer Detailsin one sheet, Items in another and say Items purchased by Customers in another sheet so what all adavantage I would get on storing it in DB rather than in excel sheet.These are many points let me list down the key points:
1) Lets suppose I want to ensure details are first entered in Customer Details before entering Items purchased by customer how do do that in excel ?
2) A customer detail should be overwrittern or deleted if he has purchased some items
3) I want to ensure that phone numbers are entered for all customers
4) I want to find all customer phone numbers who purchased say Item named "Item1", is it very simple to acheive the same in excel sheet
So basically we see like it is not possible or rather difficult to maintain a relationship or relative data in text file,excel file,word file.
That is what RDBMS provides or called as RDBMS
No comments:
Post a Comment