RDMS QUESTIONS

a)

b)

c)

d)

monday  28/2/2011

Question 1
a)define what DBMS?
 -is a software system that enables users to define,create and maintain the database and provides control access to this database.
b)give two advantages of using a DBMS?
 -control of data redundancy
 -data consistency
c)explain what are the 3 main database characteristic?
    -persistent
data that repetitively used for example data about customers,employees and inventory are usually stored on stable storage such as magnetic disk.
    -shared
database can have multiple uses and shared by multiple users. Many users can access a database simultaneously.
    -interrelated
data stored as separate units can be connected to provide a whole picture. Databases contain both entities and relationship among entities.