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!
An ideal data dictionary should have everything a DBA wants to know about the database.
1 Conceptual, External, and internal database descriptions.
2. Descriptions of attributes (fields), entities (record types) as well as origin, cross- references and meaning of data elements.
3. Authorisation ,Synonyms and security codes.
4. Which external schemas are used by which programs, what their authorisations are, and who the users are.
5. Statistics about database and its usage containing number of records, etc.
A data dictionary is executed as a database so that users can query its contents. The cost efficiency of a data dictionary increases as the difficulty of an information system increases. A data dictionary can be an enormous asset not only to the DBA for database design, execution and maintenance, but also to managers or end users in their project planning.
Smart Alex Catering Sevice (SACS) is a company offering top class catering staff for prestigious events. The company employs approximately 200 hourly paid contact staff - chefs,
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;
Views in relational algebra: 1. Basic expression contains either a) A relation in the database. b) A constant relation. 2. General expressions are madde out of sma
Give a sample of the Dynamic Model. The sample of dynamic model is given below: Dynamic model for the car: Brake and Accelerator Brake or Applies Accelerator
An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2. Descriptions of attr
Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost. Ans: There are two types of log based recovery techniques: deferred update
These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in
WOUND-WAIT
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd