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 do you understand by a view? What does WITH CHECK OPTION clause for a view do?
- A view is a virtual table which comprises fields from one or more real tables.
- It is generally used to join multiple tables and get the data.
- WITH CHECK OPTION for a view prevents any modification to the data that doesn't confirm to WHERE clause of the view definition.
- This allows data belonging to the view to be updated through view.
Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei
What is relationship? Give examples A relationship is an association between several entities. Example: A depositor relationship associates a customer with every account tha
What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage
What are the disadvantages of relational approach? Disadvantages of relational approach: • Substantial hardware and system software overhead • May not fit all business models •
Draw and explain the three level architecture of the database system? A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schem
NEED ER DIAGRAM WITH MINIMUM ENTITY AND RELATIONSHIP of Hospital Management System
how to implement mid square hashing?
Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi
Explain the Cartesian product: The Cartesian product operation does not need relations to union-compatible. The meaning of this is that the involved relations may have dissim
write a database program for concurrency transaction in a bank
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