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 the term- Periodic recomputation
Periodic recomputation: Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes periodically without recomputing derived attributes after each base value is altered. Recomputation of all the derived attributes can be more proficient than incremental update since some derived attributes may depend on many base attributes and might be updated more than one time by an incremental approach.
Also, periodic recomputation is easier than explicit updates and less prone to bugs. While, if data set changes incrementally, some objects at a time, periodic recomputation is not practical since too many derived attributes may be recomputed when only a little are affected.
what is the importance of back up files
Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr
#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by
Draw an ER diagram for company''s database schema
crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;
Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost. Ans: There are two types of log based recovery techniques: deferred update
Using Column aliases Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;
Explain Foreign Key? Foreign Key - Let there are two relations (tables) R and S. Any candidate key of the relation R that is referred within the relation S is known as the fo
Some disadvantages of File Oriented System ?
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
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