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 are views? Explain how views are different from tables?
A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base tables or previously described views. A view does not necessarily exist in physical form; it is considered a virtual table, in contrast to base tables, whose tuples are infact stored in the database. This limits the possible update operations in which can be applied to views, but it does not provide any limitations on querying a view. A view represents a variant perspective of a base relation(s). The definition of a view in a form view statement is stored in the system catalog. Any attribute in the view could be updated as long as the attribute is simple and not derived from a computation including two or more base relation attribute. View that includes a join may or may not be updatable. Such views are not updatable if they do not include the primary keys of the base relations.
Hello.I have database access assignment which consist of creation Form, Subform, Calculation, Macros
Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.
How the time stamps are implemented Use the value of the system clock as the time stamp. That is a transaction's time stamp is equivalent to the value of the clock when the tra
A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a q
I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim
If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,
Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and
What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.
Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t
object oriented database
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