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!
Explain hash file organization?
Hash functions
a) The distribution is uniform
Hash functions assign each bucket the similar number of search -key values from the set of all possible search-key values
b) The distributed in random
In the average case every bucket will have nearly same no of values assigned to it, regardless of the actual distribution of search-key values
Handling of bucket overflows
o Insufficient buckets
o Skew
Open hashing
Under an alternative approach known as open hashing
Close hashing
The form of hash structure that we have just explained is something referred to as close hashing.
Hash indices
What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a
Which database level is closest to the users? External database level is closest to the users.
Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description
Draw the precedence graph of the following schedule and determine whether the schedule is serializable. (Note that all instructions, except lock and unlock, are omitted. We assume
Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont
Entities Let us first be aware of the question: What are entities? An entity is an object of concern used to show the things in the actual world, e.g., table, car, bo
Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp
Ask questApollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to automate its business functions into an information system. The proposed information syst
what is the need of a log in dbms
wh
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