Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
differentiate between static hashing and dynamic hashing ans static hashing comprises the number of primary pages in the directory fixed so while
how does a query tree represent a relational algebra expression ans this includes transforming an initial expression tree into an
software restructuringsoftware restructuring changes source code and or data an effort to make it amenable to future changes in general
what are the assumptions of the execution-time component modelthe execution-time component is based on the several assumptions1 tests show the
what is indexed sequential file organization what are the applications of this organization ans an index file can be employed to effectively
what are the reasons of bucket overflow explain any two methods for solving this problemans it is general for file structures to be divided into
applicability it is another significant characteristic of a model the model should be judged by its degree of applicability across software products
define the boyce-codd normal form with instance and also compare bcnf and 3nf ans bcnf for each functional dependency x-gty in a set f of
boundary value analysis its widely examined that input values at the extreme ends of input domain cause more errors in system more
explain equivalence class partitioning equivalence class partitioning it is a method in black box testing it is designed to decrease the number of
structure chart a structure chart is a top-down modular design tool constructed of squares representing the dissimilar modules in the system and
what is ddl make a list of commands with short description used in ddlans data definition language that is abbreviated as ddl is a computer language
class diagram a class diagram in the unified modelling language uml is a type of static structure diagram that defines the structure of a system by
communicational cohesion communicational cohesion is when parts of a module are grouped because they operate on the similar data eg a module which
how relational calculus is different from relational algebra what do understand by trc queries and drc queries ans relational calculus contain two
common coupling common coupling is when two modules share the similar global data eg a global variable changing the shared resource implies changing
explain the steps for reduction of e-r model into relational modelansa entity set in e-r model will be considered as table name in relational modelb
explain the shadow paging recovery technique ans shadow paging is a method used to acquire atomic and durable transactions and provides the
productivityproductivity refers to metrics and calculates of output from production processes per unit of input productivity p may be conceived of as
what is a view make a view of emp table named dept 20 to display the employees in department 20 and their annual salary ans view is a
evolutionary prototyping evolutionary prototyping also called as breadboard prototyping is quite dissimilar from throwaway prototyping the main goal
throw-away prototyping also known as close ended prototyping throwaway or rapid prototyping refers to the formation of a model that will eventually
what are the general transformation rules for relational operations ans the transformation rules transform one relational algebra expression to
the big red rocks brr mining company is based and operates in western australia they are primarily an iron ore miner but they also produce
define radix conversion method one clever way to transform binary numbers to bcd notation binary-coded decimal is the double dabble algorithm it