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 a disjoint less constraint?
Ans: It needs that an entity belongs to no much more than one level entity set.
Disjoint less constraint needs that an entity belongs to no more than one level entity set. (the meaning of Disjoint less constraint is that an entity can be a member of at most one of the subclasses of the specialization.)
Describe integrity and security? a) Domain constraint b) Referential integrity A value that appears in one relation for a given set of attributes also appear fo
Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving. Because Lossless join and dependen
List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot
System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys
Why is database redesign necessary? Database redesign is essential for two reasons. First, redesign is essential both to fix mistakes made during the initial database design. S
What is a data dictionary? A data dictionary is a data structure which keeps Meta data about the structure of the database i.e. the schema of the database.
The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by
State the functional approach of object oriented methods Moving from a functional approach to an object oriented one needs a translation of functional model elements into objec
Company Database: a-)Here is the ER Model b-)Here is the Relational Model: IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE
CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);
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