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!
The indices are accumulated in the index files. The data is accumulated in the data files. Indices give fast access to data items. For example, a book database may be managed in the order of Accession number, yet may be indexed on Book titles and Author name.
Data Dictionary: A Data Dictionary kept information about the structure of the database. It is used a lot. Therefore a good data dictionary should have a good design and efficient execution. It is seen that when a program becomes somewhat big in size, keeping track of all the available names that are used and the purpose for which they were used becomes more and more hard. After a significant time if the similar or another programmer has to change the program, it becomes extremely hard.
The problem becomes even more complex when the number of data types that an organisation has in its database enhancing. The data of an organisation is a valuable corporate resource and thus some kind of inventory and catalog of it must be maintained so as to assist in both the management of the resource and utilisation.
It is for this purpose that a data dictionary or directory / dictionary are emerging as a main tool. A dictionary gives definitions of things. A directory notifies you where to find them. A data directory / dictionary have information (or data) about the data.
A comprehensive data dictionary would give the definition of data items, how they adjust into the data structure and how they tell to other entities in the database. In DBMS, the data dictionary kept the information concerning the conceptual, external and internal levels of the databases. It would join the source of each data field value, that is from where the authenticate value is obtained. The audit trail regarding the updates and frequency of its use including user identification with the time of each update is also recorded in Data dictionary.
Question 1 What are the advantages of DBMS approach in managing data? Question 2 What are the services provided by a database system Question 3 List and briefly describe
Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve
Explain the Functional Mode with help of an example. Functional Model The functional model shows a computation and functional derivation of data values in it without ind
What is hashing file organization? In the hashing file organization, a hash function is computed on some attribute of every record. The result of the hash function specify in
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz
Process of implementing system design in dynamic models There are three essential approaches to implementing system design in dynamic models. These approaches are as below:
PART MARKING: We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with
What is a hashing function? What are the properties of a good hashing function? Describe the folding technique for hashing functions. Ans: Hashing function is a method
Define According to the levels of abstraction, the schema at the intermediate level is called Ans: As per to the levels of abstraction, the schema at the intermediate level is
Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha
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