Programming & Computer Science Answers

Q3.A. Consider the relation schema R = (E,F,G,H,I,J,K,L,M,N) And the set of functional dependencies {{E,F} -> {G}, {F} -> {I,J},{E,H} ->{K,L}->{M},{K}->{M},{L}->{N}} on R. Find the key for R?

Q3. B. Consider the schema R(ABCDEFGHIJ) and functional dependencies {FDs=(AB->C,A->D,B->F,F->GH,D->IJ)} and decompositions

a) {D=(ABCDE,BFGH,DIJ)}

b) {D=(ABCD,DE,BF,FGH,DIJ)} Check whether the decomposition is lossless or not? 

Q2. Check whethe.r the given schedule S is conflict serializable or not? If yes, then Draw a precedence graph for it and give valid serial schedules possible using topological sort. S : R1(A) , R2(A) , R1(B) , R2(B) , R3(B) , W1(A) , W2(B)

Q1. B. Consider the Following Table Employee(emp_id, name,dept_id, email, mobile_number, join_date,salary, mgr_id) 1) Query to display the name and salary for all the employees whose salary is not in the range of Rs. 10,000 and 50,000. 2) Make sure that the EmailId of each employee is common and unique to that employee only. 3) Query to display the name and Department number of all the Employees in department number 8 and 12 in an alphabetical order by name. 4) Write a query to display the name of employees who have an ‘a’ and ‘e’ in their name. 5) Write a query to display the name, job, salary of all the employees whose job is clerk or teacher and whose salary is not equal to 15,000.

Parents

John is going through his family photo album. There is a total of people in the family labeled from 0 to N-1.

Find out the number of members of his family who have more than equal to X children.

Input Specification:

input1: N. denoting the total number of family members.

input2: X denoting the minimum number of children a family member should have in order to be included in John's final set.

input3: An array of N elements where the ith element denotes the parent of the ith index. If the value of the element is -1, then that family member has no parent.

Output Specification:

Your function should return the number of John's family members that have more than or equal to X childrens.

Example 1:

Input1: 1

input2:0

input3:{-1}

output:1

Explanation :Family member 0 has 0 children. As we have to return the family membersthat have more than or equal to 0 children.hence the answer is 1.

please give logic function in java for this question

Write a program to handle an exception using try, catch and throw.

algorithm to wite a programme to determine if the student is pass or fail

Write a program to read and write data to a file.

Create an interface and design a class to implement an interface.

) Put a button titled Open Answers File. When this button is clicked; open Answer.txt, and read and store the answers in an array of Strings. Close this file. 

What will the value of the answer variable be after the code segment below has been run.

int answer; 

int number3 = 32, number7 = 66; 

answer = number3 / number7;