Question

In: Computer Science

What four main types of actions involve databases What are the responsibilities of the DBA and...

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

Solutions

Expert Solution

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.


Related Solutions

. Who is DBA? What are the major responsibilities of DBA.[1+4] 8. Write short notes on...
. Who is DBA? What are the major responsibilities of DBA.[1+4] 8. Write short notes on [2*2.5=5] a) Normalization b) Coaxial cable
what are the four main types of technical descriptions
what are the four main types of technical descriptions
Briefly describe the four stages of the auditor dispute process. For what types of actions are...
Briefly describe the four stages of the auditor dispute process. For what types of actions are auditors liable to a client under common law? Why would the client prefer to sue the auditor for a tort action rather than for a breach of contract?
What are the types of nervous actions
Nervous actions are of three types.    1. Reflex action  2. Involuntary action.  3. Voluntary action.    
Please answer the following: A) what are the four main tissue types and the origin of...
Please answer the following: A) what are the four main tissue types and the origin of epithelium from the germ layers. B) Functions of the epithelium. C) Classification of epithelium, how are they classified? D) What is unique about pseudostratified? Transitional? Where in the body would you find such types of epithelia?
What are the four main types of reports required of a single audit? Explain.
What are the four main types of reports required of a single audit? Explain.
What are the four types of audit opinions and list the two main conditions that would...
What are the four types of audit opinions and list the two main conditions that would require modifications to the auditor’s standard report.
Which of the following is NOT one of the four main types of inventory?
Which of the following is NOT one of the four main types of inventory? A. raw material inventory  B. work-in-process inventory C. maintenance/repair/operating supply inventory (MRO) D. just-in-time inventory  E. finished -goods inventory Reset Selection
What is the main purpose of the Federal Reserve and what are some other actions that...
What is the main purpose of the Federal Reserve and what are some other actions that the Fed may take during recessionary times?
Experiment with SQL queries on 2 tables: Background: Normalized databases will involve data that is organized...
Experiment with SQL queries on 2 tables: Background: Normalized databases will involve data that is organized into 2 or more tables. However, to answer queries, the data from 2 (or more) tables will need to be joined together to get the relevant information. Join operations in SQL are accomplished in the following manner: Indicate the tables involved in the query in the FROM clause Specify relationship/condition between columns in from the tables. Exercise: For this part of the exercise the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT