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!
Explain Derived and Non-Derived Attribute?
In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person entity, the value of Age can be determined from the current date and the value of that person's BirthDate. Therefore, the attribute Age is known as derived attribute and the attribute BirthDate is known as non-derived or stored attribute.
how many types of data model in DBMS? explain data abstraction with its different level
how to operate database in access ?
Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
database help
Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and
Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent
When are two schedules said to be view equivalent? Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met
Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP
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
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