Bissoy.com
Doctors Medicines MCQs Q&A

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:

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: Correct Answer Normalization

Normalization helps in improving the quality of the data.

Related Questions

The following are the criteria set by a Retail outlet for the selection of candidates for the post of Store In charge in a reputed mall. 1. The candidate must be a graduate in any stream with minimum of 50% marks. 2. The candidate must have Minimum of 5 years of Sales experience in Retail. 3. The age of the candidate should not be less than 25 years and more than 34 years as on 1st October, 2019. (a) If a candidate satisfies all the criteria except 2 as given above but has an MBA degree and has minimum of 2 years of work experience in sales, she/he must be sent to the General Manager, Recruitment for further interview. (b) If a candidate satisfies all the criteria except 3, but has more than 5 years experience as a Group Manager and above in Sales managing a team of sales executives, then she/he must be sent to the Regional Manager, Sales & Marketing, for further interview Based on the above criteria and conditions, analyze and decide which of the following course of action should be taken for the candidate whose description is provided below. Please note that you are not to assume anything other than the given information. Sujoy is a graduate with 55% marks and MBA through Correspondence. He was born on Sept 20, 1990. He has 1 year of work experience as a sales executive and 2 years of experience as a Group Manager, Sales. On the basis of the information as given above, which of the following decisions would be appropriate
In an election for the Legislative Assembly constituency of Nagpur, three candidates are contesting – candidate A, candidate B and candidate C. The total number of registered voters in the constituency is 10000. Out of the total registered voters, 20% did not cast their vote, and a total of 10% of the total votes casted were declared as invalid. If the candidate A got 60% of the total valid votes polled and candidate B got 20% of the total valid votes polled, find out the percentage of the total number of registered voters who voted for the candidate C.
The question below consists of a set of labelled sentences in which first and the last sentence is given. Out of the four options given, select the most logical order of the sentences to form a coherent paragraph. S1- Non-Formal Adult Education is an education provided at the workplace or at some community centre but not in a classroom. P- Non-formal education doesn’t have a set curriculum, but it is conducted under the supervision of trained professionals. Q- Though it doesn’t allow a formal degree or diploma, it is very useful in developing specific skills and increasing the productivity of a person. R- A desire to learn is the driving force behind non-formal adult education. S- Some of the examples of non-formal Adult Education are- voluntarily teaching the women of a community to stitch, producing bags, making pickles, producing honey, farming or any such sustainable activity. S6- They main focus of a non-formal education is the development of skills and capabilities.
The following qualifications are required for appointment to a certain post in a reputed multinational company: A. Candidate must be MBA with 65% marks. B. Candidate must have passed the selection test with the minimum of 50% marks. C. The candidate must have secured a minimum of 65% marks in the interview. D. Candidate age should not be less than 23 years and more than 30 years as of 1 September 2018. In the case of the candidate, who fulfills all other criteria except: I. In case of (A) above, but he is an engineer with 50% marks, then the matter may be referred to Director for Recruitment. II. In the case of (B) above, but he has a minimum of 2 years experience of working as an executive officer, the matter may be referred to the Chairman, Recruitment Committee. Below is the information regarding a candidate. Analyze it in the context of the above criteria and conditions and then decide the appropriate action. Do not assume anything other than the information given to you. Shweta Sharma did her MBA through Open School after completing Mechanical Engineering. She secured 55% marks in MBA and 75% marks in the Engineering course. She scored 65% in the selection test and 70% in the interview. Her date of birth is 25 December 1992.
The following qualifications are required for appointment to a certain post in a reputed multi-national company: A. Candidate must be MBA with 65% marks. B. Candidate must have passed the selection test with minimum 50% marks. C. The candidate must have secured a minimum of 65% marks in the interview. D. Candidate age should not be less than 23 years and more than 30 years as on 1 September 2018. In the case of the candidate, who fulfills all other criteria except: I. In case of (A) above, but he is an engineer with 50% marks, then the matter may be referred to Director for Recruitment. II. In case of (B) above, but he has a minimum of 2 years experience of working as an executive officer, the matter may be referred to the Chairman, Recruitment Committee. Below is the information regarding a candidate. Analyze it in the context of the above criteria and conditions and then decide the appropriate action. Do not assume anything other than the information given to you. Sohail Singh is an MBA with 76% marks. He has been working as an executive officer at his uncle's firm since December 2016. He has secured 72% marks in the selection test and 70% marks in the interview. His date of birth is 14 August 1993.
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?
Given below are quantities named A,B and C. Based on the given information, you have to determine the relation between the quantities. You should use the given data and your knowledge of mathematics to choose among the possible answer. Akash’s present age is six years less than Badshah’s age after nine years. The ratio of present age of Badshahand RAFTAAR is 5:9. Raftaar is 21 years younger than Denny and Denny is three years older than Honey. Square of the Honey’s present age is 1350 more than 15 times of Honey’s present age? Quantity A: What is the difference between AKASH’s present age and HONEY’s age after 16 years? Quantity B: After 6 years Mankirat’s age is twice that of Akash’s present age. Diljeet’s present age is 3.5 times of 25% of sum of present age of Mankirat and A. What is the present age of Diljeet? Quantity C: Twice of A’s present age is eight years more than that of Babbu’spresent age, then find the Babbu’s present age?
Four political parties W, X, Y and Z decided to set up a joint candidate for the coming parliamentary elections. The formula agreed by them was the acceptance of a candidate by most-of the parties. Four aspiring candidates, A, B, C and D approached the parties for their tickets. A was acceptable to W but not to Z. B was acceptable to Y but not to X. C was acceptable to W and Y. D was acceptable to W and X. When candidate B was preferred by W and Z, candidate C was preferred by X and Z, and candidate A was acceptable to X but not to Y, who got the ticket ?
Four political W, X, Y, and Z decided to set up a joint candidate for the coming parliamentary elections. The formula agreed by them was the acceptance of a candidate of the most of the parties. For aspiring candidates A, B, C and D approached the parties for their ticket. 1) A was acceptable to W but not Z 2) B was acceptable to Y but not X 3) C was acceptable to W and Y 4) D was acceptable to W and X When candidate B was preferred by W and Z, candidate C was preferred by X and Z and candidate A was acceptable to X but not Y, who got the ticket
Using the mesh current method, find the branch current, IR1, in the above figure.
Branch, Loop and Node Analyses mcq question image