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!
Consider the subsequent relation
Professor (Pfcode, dept, head, time)
It is assumed that
(i) A professor can work in much more than one dept.
(ii) The time he spends in every dept is given.
(iii) Every dept has only one head
Draw the dependency diagram for the above relation by recognizing the dependencies.
Ans:
Dependency Diagram
Which is another name for weak entity? Child is another name of weak entity.
The Maximum no of key fields that can be used in a header is?? 50
10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the
Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u
Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.
State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to
What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed f) Terminated
What is NULL? Simply NULL means not in value.
Nested Queries Let us see some more complex queries in this section. Sub-queries: Some of the basic concerns of sub-queries are: A sub-query is a SELECT statemen
In which format database schema is written ? Data base schema is written in the DDL format.
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