Bissoy.com
Doctors Medicines MCQs Q&A

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in Correct Answer BCNF

BCNF has only one normal form.

Related Questions

Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective departments in the location ID 1700. You issue the following query: SQL>SELECT last-name, hire-date FROM employees WHERE (dept-id, hire-date) IN (SELECT dept-id, MAX(hire-date) FROM employees JOIN departments USING(dept-id) WHERE location-id = 1700 GROUP BY dept-id); What is the outcome?
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?
From the following, find out the amount of subscriptions to be included in the Income & Expenditure Account for the year ended 31st March 2009.  Subscriptions were received during the year 2008 - 2009 as follows:  For the year 2008 - 2009 is 30,000 For the year 2009 - 2010 is 3,000 Subscription outstanding as of 31st March 2008 was Rs. 3,500 out of which Rs.500 were considered to be irrecoverable. On the same date, the Subscription received in advance for 2008-2009 was Rs. 2,000.
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
The given bar graph represents the sales of automobiles (in Rs. crores) by five companies A. B, C, D and E in the years 2007-2008 and 2008-2009. Study the bar graph and answer the question that follows. (Note: The data shown below is only for mathematical exercise. It does not represent the actual figures of the companies) What should have been the sales (in Rs. crores) of company E in 2008-2009 so that it would have shown the same increase over 2007-2008 as shown by the sales of automobiles of company C during these years?
The given bar graph represents data of the production of paper (in ten lakh tonnes) by three different companies X, Y and Z during the years 2008 to 2012. The x-axis shows the 'years' and the y-axis represents the 'production of paper (ten lakh tonnes)'. (Note: The data shown is only for mathematical exercise. They do not represent actual figures.)  The total production of Company Y during 2008 and 2009 and Company X for 2011 and 2012 taken together is p% (p is correct to the nearest integer) more than the total production of Company Z during 2010, 2011 and 2012. The total production of Company Z during 2008 and 2009 taken together is q% (q is correct to the nearest integer) less than the total production of Company X during 2008, 2009 and 2012 and Company Y during 2010 and 2011 all together.  What is the positive difference between p and q ? 
Consider the relation Emp-Dept with SSn as key Ename SSn EAddr Dept. No Dept. Name Dept. Manager SSn   Which of the following is (are) invalid operation(s)? a) Inserting an employee without name and address b) Inserting an employee with only SSn c) Inserting a department with no employee d) Inserting an employee without SSn
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?
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
In a book store, the sales of a book decreased by 80% from 2007 to 2008. If the sales in 2009 were the same as in 2007, would be the percentage increase in sales from 2008 to 2009?