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!
We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts.
College database remains track of faculty, Students, Departments and Courses organised by several departments. Following is the explanation of COLLEGE database:
College have several departments like Department of Hindi, Department of English, and Department of Computer Science etc. Every department is assigned a unique id and name. Some faculty members are also appointed to each department and one of them works as head of the department (HOD).
There are several courses conducted by every department. Each course is assigned a unique id, name and duration.
What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n
What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.
Hierarchical
In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.
brief history,definition,current trends and future trends if any of data fragmentation
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
Define check point and its impact on data base recovery. Ans: There could be hundreds of transactions handled per minute, in a large on-line database system.
DISADVANTAGES OF RDBMS
Why older data models are being replaced by new data modelling 100 words accepted#
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