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!
Determine the Three Views of Data
We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed already can have different aspects to reveal if seen from dissimilar levels of abstraction. The term Abstraction is very significant here. Generally it means the amount of detail you want to hide. Any entity can be seen from dissimilar perspectives and levels of complexity to make it a reveal its current amount of abstraction.
In the same manner, the database can also be viewed from dissimilar levels of abstraction to reveal dissimilar levels of details.
Using the concepts defined previous, we have identified that strong entities in COLLEGE database are FACULTY, STUDENT, COURSE and DEPARTMENT. This database also has one weak entity
To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.
Wait-die" scheme : The idea is based on non-preventive method. It is based on a simple rule: If Ti requests a database resource that is held by T
Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr
What are shortcomings in structured approach? Structured methodology treats data and their behaviours separately, and this makes it harder to isolate changes. If changes are re
Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact
what are the reasons having variable length records
1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures
What is Data dictionary? A data dictionary is a reserved space in a database that is employed to store information about the database itself. A data dictionary may consist o
Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes
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