diff b/w DBMS & RDBMS?

Answer Posted / siju george

huh:
Lots of differences ! nah.simple logics thats it... let get
going.May be someone correct me if going wrong ... :)

theres some rules and regulations for how to store and
maintain data(using algebric algorithm) and they are
written in a genuine way and became famous and are called
Codd Rules(12 or may be more.....).So if we know these
rules then its very easy to differentiate between DBMS and
RDBMS

1. Any database which adheres to minimum of 5-6 codd rules
are automatically called as RDBMS. for e.g oracle,SQL,etc

2. Both help to store persistent data however DBMS stores
them in a denormalized way in rows and columns where as in
RDBMS stores them in tabular cells and there is chance to
split data(normalise) and store them in separate tables.
3. Most important is the 'R' letter which separates them in
terms of relationship management.RDBMS enforces
referrential Integrity and thus maintain the relationship
and in a way gives security of data(no accidental
loss/addition of data).
4. Security in RDBMS is provided in terms of
constraints/rules/sp/triggers/locks etc which ensures
i.Domain Intigrity(Primary Key,Unique key,Identity column)
ii. Entity Intigrity(Default,Foriegn Key,Not null,Check)
iii.Referential Intigrity(Foriegn key,Check) and
iv. User Defined Integrity(SP/Triggers/Rules)
5. RDBMS follows ACID(Automicity,Consistency,Isolation and
Durability) rule where as DBMS doesnt follows them.

Is This Answer Correct ?    41 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you prefer manual testing over automation testing?

556


Tell me what is automation testing?

540


How the object properties will be recognised by the tool If the functions/ statements are written manually?

1739


5. What are the tests you are conducting through winrunner?

1980


What is the different between GUI map and GUI map files?

1602






Do you know what is robot api?

542


in keyword driven frame work..where Driver Script is locate? is there any inbuilt script for driver script?who writes the driver script?how to call it any body can tell me with an example...like(yahoo login,inbox, logout).

1663


Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932

1530


notice the distinction between data driven testing and retesting?

481


Do you know how to check if a button is enabled on the page?

526


What are the phases in automation testing life cycle?

546


Why automation testing?

587


I need some help with my interview answers for TeleTech. Here are the questions I have to answer and the answers I plan to give to the company. Please could you help I want to make sure I do the best possible. Thank you in advance, Jose 1.New processes and procedures can be disruptive. What actions have you taken when you’ve been asked to significantly change a work process or procedure? What were the results? The only thing I can think of is when the company changed the software they were using to interact with their customers the CRM. It was a little bit challenging. What I did was study the new software in detail to be ready to interact with customer quickly and efficiently using the company's new CRM software. 2.Tell me about a time when you have had to deal with a difficult customer. How did you handle the situation? One time a customer called in to the company and was upset because a technician did not arrive at their house to resolve the problem they were having with their internet not working. So after listening to the customer problem and making sure I understood the problem I showed empathy to the customer and assured the customer I understood the problem and took ownership of the problem making it my own. I reassured the customer I would find a solution to their problem and later found out that the customer was misinformed about the time the technician was suppose to arrive at the customers house, informed the customer of the correct time the technician was scheduled to arrive at her home and apologized for any inconvience that they may have experienced. 3.Sometimes if we’re lucky, we can identify a small error or problem and correct it before it becomes a headache. Has this ever happened to you? Yes, it has one time while I was talking with a customer about a problem they were having logging into the company website. I asked the customer to verify the email address they wanted to use on the company website. After verifying with the customer noticed the customer had the wrong email address on file and immediately changed the customer email address to the email address of the customer. 4. What general questions would you ask a customer prior to starting to troubleshoot their issue? I would first ask the customer what issue they are having? I would then let the customer explain in their own words what they have experienced and not interrupt the customer. After I begin understanding the customer issue I would start using closed ended questions that require more specific answers to narrow down the problem and possible resolution. Next I will verify my understanding of what the customer has told me and get the customer to agree that I understand the issue.(Eg. Okay so your having trouble try to logging into our website it tells you invalid password is that correct?) If the customer agrees then I will proceed to resolve the issue by asking more questions and proceed to the solution. I will not continue until the customer agrees that I understand the issue. 5. What steps should be taken to install software via a CD? First make sure there is no CD in the CD drive if there remove the CD from the computer and put in the CD of the software you are trying to install. Next Open My Computer Within the My Computer window, open the drive that contains the installation files. For example. If they're on a CD or DVD open the D: drive or the letter of the disc drive. Next Within the drive that contains your files, locate either a setup or install file. Double-clicking on this file should start the installation for the program. If you see multiple setup or install files, try to locate the Application file or double-click each of setup or install files until you find the file that starts the installation. Many times the icons associated with the installation files have the same name.

3969


all clients are using at once if any problem raise?

1868


Is automation testing a black box testing or white-box testing?

508