Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Database Administrator
One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having like control over the system is called as the database administrator (DBA). The DBA administers the 3 stages of the database and tells the global view or conceptual level of the database. The DBA also displays the external view of the applications and several users and is responsible for the definition and execution of the internal level, as well as the storage structure and access techniques to be used for the optimum performance of the DBMS. A modification to any of the 3 levels due to varies in the organisation and/or emerging technology is under the control of the DBA.
Mappings among the internal and the conceptual levels, as well as between the conceptual and external levels, are also describe through the DBA. The DBA is responsible for granting permission to the users of the database and remainsthe profile of each user in the database. This profile defines the permissible activities of a user on that portion of the database accessible to the user through one or more user views. The user profile could be used by the database system to confirm in which a particular user can present a given operation on the database.
The DBA is also responsible for describing procedures to recover the database from natural, failures due to human, or hardware causes along with minimal loss of data. This recovery procedure should permit the organisation to continue to function and the intact portion of the database has to continue to be available.
Therefore, the functions of DBA are:
Saving Derived Attributes to Avoid Re-computation As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,
It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia
What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters
File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is
Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,
What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.
What is DAG? The class-subclass relationship is shown by a directed acyclic graph.eg: employees can be temporary or permanent. We might be create subclasses temporary \and perm
Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s
Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';
Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd