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!
What is data model? Explain object based and record based data models?
Ans: A data model is an abstract model in which describes how data is represented and accessed.
(i) Object based data models: Same to a relational database model, but objects, classes and inheritance are directly supported within database schemas and in the query language
(ii) Record based data models: is a database model based on first-order predicate logic. Its core idea is to elaborate a database as a collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values.
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs
Q. State the Technique for converting a state diagram to code. i) Identify the major control path. Starting with first state, find the path from diagram that corresponds
Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.
Ancestry database records information about family trees . Following information is recorded about each person: FIRSTNAME first name SURNAME surname MNAME maiden name (if
employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience
Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan
Adding Redundant Associations for Efficient Access Redundant associations do not add any type of information, therefore during design we should actually examine structure of o
Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.
Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele
What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each. Ans: Completeness Constraints
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd