Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Schema I: Field ‘courses’ is a set-valued attribute containing the set of courses a student has registered for. Non-trivial functional dependency: rollno → courses Schema II: Non-trivial functional dependencies: rollno, courseid → email email → rollno Schema III: Non-trivial functional dependencies: rollno, courseid → marks, grade marks → grade Schema IV: Non-trivial functional dependencies: rollno, courseid → credit courseid → credit Which one of the relational schemas above is in 3NF but not in BCNF?
Facts related to public relations are given below
1. Internal relations
2. Customer relations
3. Concept of public relations
4. Internal coordination
Which of the above given is/are types of public relations?
Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:
Consider the following three relations in a relational database. Employee(eId, Name), Brand(bId, bName), Own(eId, bId) Which of the following relational algebra expressions return the set of eIds who own all the brands? 
A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
Metadata about the relations are stored in ________
_________ can be applied to the metadata or to an active session and the metadata.
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out of the four alternatives.
The nation has been _____as a relatively extensive, territorial relation of nativity. We have further formulated the_____of the nation as a territorially_____, yet bounded, social relation for the generation, transmission, and ____of life. When the nation is a national state, it is also a_____for the protection of life. The nation is often ______by the metaphor of familial relations and, indeed, has sometimes been considered as some kind of_____family. This is understandable because both the nation and the family are relations of_____. Nonetheless, there is an important difference, and to understand this will _____a more detailed examination of the_____ between territory and bonding.
This is understandable because both the nation and the family are social relations of________.
Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId) Note that the deptId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus. (I) { t |∃u ∈ EMP(tEmpName] = u[EmpName] ∧ ∀ v∈ DEPT(t[DeptId] ≠ v[DeptId]))} (II) {t |∃ u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] ≠ v[DeptId]))} (III) {t | ∃ u∈ EMP(t[EmpName] = u[EmpName] ∧ ∃ v ∈ DEPT(t[DeptId] = v[DeptId]))} Which of the above queries are safe?