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!
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 free. This flexibility permits an organisation to expand gradually. Adding storage power and processing to the network can generally result in better handling of ever enhancing database size. A more powerful system in compare, a centralised DBMS, would need changes in both the software and hardware with increasing size and more powerful DBMS to be procured.
Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.
What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.
Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes that have more than single values
Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info
System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha
Meaningful use refers to the use of certified EHR technology to "enhance quality, efficiency, and reduce health disparities
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.
Determine the rule that a value of a foreign key should appear as a value of some particular table is called a Ans: Referential constraint. The rule that a value of a fo
What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have
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