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!
State the data flow diagram of functional model
Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. The methods in a data flow diagram comprise of sub-operations that may be operational on original target object or on the other objects. We can determine target object of a sub-operation as below:
i) If process extracts a value from I/P flow=> input, flow is target.
ii) If process has same type of input and output flow and output value is the updated version of I/P => I/O, flow is the target.
iii) If process has an I/P from data source or an O/P to a data source => data, source is a target of process.
iv) If process constructs O/P value from several inputs => operation is class operation on output class.
Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO FROM EMP WHERE SAL IN (SELECT MI
Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known
Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML
Describe the nested-loop join and block-nested loop join. Ans: The block nested- loop join algorithm is as described below: for every block B r of relation R do beg
Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su
Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat
Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions
Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue
What is indexed sequential file organization? What are the applications of this organization? Ans: An index file can be employed to effectively overcome the problem of storing
What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an 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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd