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!
Consider the subsequent relation
Professor (Pfcode, dept, head, time)
It is assumed that
(i) A professor can work in much more than one dept.
(ii) The time he spends in every dept is given.
(iii) Every dept has only one head
Draw the dependency diagram for the above relation by recognizing the dependencies.
Ans:
Dependency Diagram
What is the max. no. Of structures that can be included in a table or structure. Nine.
Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.
What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.
Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti
Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr
Mention the several levels in security measures. A) Database system B) Operating system C) Network D) Physical Human
Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that
Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):
What is bucket overflow and how bucket overflow is handled through Over Flow Chaining or Closed Hashing? Ans: Bucket: unit of storage holding records. Bucket is a disk block
Briefly describe the different kinds of users of a DBMS. Ans: Different sorts of DBMS users are: (a) Software Engineers: These are the people accountable for developing ap
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