In: Computer Science
What four main types of actions involve databases
What are the responsibilities of the DBA and the database designers?
What is the difference between controlled and uncontrolled redundancy? Illustrate with examples
Define(Which determines the structure and the kind of data in order to preserve as a catalog) ,construct (method of preserving the data on particular storage form which is handled with the Data Base Management Systems) ,share(permits to share several users for accessing a database at a time) and manipulate database(Involves task like update,delete and insert the data).
Database Administrator is liable to handle overall tasks regarding database.He supervises the objects such as handling the data integrity ,backups of overall database in a uniform duration , offering assistance for user and sustaining the database
Database designers is liable in selecting a right software, collecting details and elucidating the kind of database, collects details and splitted as tables,implements the normalization laws for assuring the tables are arranged rightly.
Preserving the similar data on the several times is called a redundancy which tends to many troubles.controlled redundancy is a required mechanism for employing the redundant feilds in order to increases the speed and peformance of database
Generally the data base management systems confirms the data to allocate.It must contain the power for stopping the conflicts.
Example : Suppose a company with employees give the number for employees having their respective ID's and wages having maximum of 10. Maintain a rule that just simply 23 employees are allowed.