Bissoy.com
Doctors Medicines MCQs Q&A

A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE (VOLUME, NUMBER) → YEAR (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE The database is redesigned to use the following schemas. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not?  

A database of research articles in a journal uses the following schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE) The primary key is (VOLUME, NUMBER, STARTPAGE, ENDPAGE) and the following functional dependencies exist in the schema. (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE (VOLUME, NUMBER) → YEAR (VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE The database is redesigned to use the following schemas. (VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE) (VOLUME, NUMBER, YEAR) Which is the weakest normal form that the new database satisfies, but the old one does not?   Correct Answer 2NF

First relational schema:

(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, YEAR, PRICE)

Primary key: (VOLUME, NUMBER, STARTPAGE, ENDPAGE)

Functional dependencies are:

(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE   

(This dependency is in BCNF, satisfy form X → A, where X is the candidate key)

(VOLUME, NUMBER) → YEAR

(This dependency is not in 2NF, as there is partial dependency in this)

(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE       (BCNF form).

First relational schema is in 1NF.

Second relational schema:

(VOLUME, NUMBER, STARTPAGE, ENDPAGE, TITLE, PRICE)      - 1st

(VOLUME, NUMBER, YEAR)   - 2nd

1st satisfy

(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → TITLE     //BCNF form

(VOLUME, NUMBER, STARTPAGE, ENDPAGE) → PRICE      // BCNF form

2nd satisfy

(VOLUME, NUMBER) → YEAR               // According to this, satisfy 2 NF form.

Weakest normal form that new database satisfies but old one doesn’t is 2NF.

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?
A, B, C, D, E and F are six girls who use 6 different face wash – Pond’s, Lakme, Lotus, Garnier, Himalaya and Kaya (but not necessarily in the same order). They also like six different colours – Red, Blue, Brown, Peach, Black and White (also not necessarily in the same order. A and C do not like a Red colour. The girl who uses Lakme face wash likes Peach colour. The girl who likes White colour does not use Kaya nor Lotus face wash. B neither likes Peach nor Red colour. D does not like a Blue colour but uses a Lotus face wash. The girl who uses Pond’s face wash likes Red colour. C does not use Lakme face wash nor likes white colour. F neither uses Himalaya nor Kaya face wash but likes Brown colour. Who does use Himalaya’s face wash?
S1:Since the sixties there has been an increasing interest in neurophysiology, which deals with the neural bases of mental activity and behaviour.
P :It has format which is very similar to that of Brain and Language, a sister journal.
Q :Since then, a number of journals devoted entirely to this area of research have appeared.
R :Before the 1960's when this field was the concern of a small number of investigators, research articles were scattered in various neurological journals.
S :Brain and cognition is one such journal.
S6:So far the journal has published the mixture of articles including reports and investigations.

The Proper sequence should be:
Study the following information carefully and answer the questions that follows. 5 persons Anil, Bhagat, Ishan, Deepak and Parmish use 5 different apps namely, WhatsApp, Instagram, Twitter, Facebook and LinkedIn. They all wear different brands of shoes namely, Adidas, Reebok, Nike, Puma and Vans. The person who wears Puma shoes does not uses Facebook. Parmish wear Nike shoes and uses LinkedIn app. Anil who wear Adidas shoes but neither uses Facebook nor Twitter. Ishan neither wear Vans nor Puma shoes but he uses Twitter app. The person who uses WhatsApp doesn’t wear Adidas shoes. Bhagat uses Facebook app. Deepak wear which shoes brand, and also determine who uses Instagram?
The following functional dependencies hold true for the relational schema R{V, W, X, Y, Z}: V → W VW → X Y → VX Y → Z Which of the following is irreducible equivalent for this set of functional dependencies?
Let the set of functional dependencies F = {QR → S, R → P, S → Q} hold on a relation schema X = (PQRS). X is not in BCNF. Suppose X is decomposed into two schemas Y and Z, where Y = (PR) and Z = (QRS). Consider the two statements given below. I. Both Y and Z are in BCNF II. Decomposition of X into Y and Z is dependency preserving and lossless Which of the above statements is/are correct?
A functional dependency f on R is _______ by a set of functional dependencies F on r if every instance of r(R) that satisfies f also satisfies F.
In the following sentence, a part of the sentence is underlined. Below are given alternatives to the underlined part, which may improve the sentence. Choose the correct alternative in case no improvement is needed, choose the alternative that indicates ''No Improvement.'' Here are the journal article for the assignment. A. is the journal article B. is the journal articles C. these are the journal article
Read the passage carefully and choose the best answer to each question out of the four alternatives. It is a labour of love and the result of painstaking research. Chikankari - A Lucknawi Tradition by Paola Manfredi, an Italian, is a book that shows her close and long association with the craft. Lucknows chikankari is known across the world yet very little research or documentation has been done. Articles or features haveappeared off and on but this book is amongst the first of its kind, which aims to document the vast treasure called Chikan. What makes the book extremelyinteresting is that unlike other books that tend to rely on second hand material, with exhaustive references and quotes, Paola Manfredi has filled her tome withpassionate grass-roots level research. The narrative more in the nature of a personal journey, with all the quirks and street-smart practicality, makes the bookrefreshing. As Paola says in the book, it is not a scholarly or academic research but more of a documentation of the world of chikankari. Paola questions the use of chikan as a word for embroidery, highlighting that it has a broader connotation encompassing haute couture, the fine art of making agarment, embroidering it and finishing it with finesse. She is no stranger to chikankari having worked with SEWA and several craftsmen. Her love for white on whiteembroidery also found a calling in chikan. Paola came to India to work in textile exports and as she says, “If you like textiles ... India is a heaven, an inexhaustibletreasure trove.” Name one type of garment design style that Paola loves?
Read the passage carefully and choose the best answer to each question out of the four alternatives. It is a labour of love and the result of painstaking research. Chikankari - A Lucknawi Tradition by Paola Manfredi, an Italian, is a book that shows her close and long association with the craft. Lucknows chikankari is known across the world yet very little research or documentation has been done. Articles or features haveappeared off and on but this book is amongst the first of its kind, which aims to document the vast treasure called Chikan. What makes the book extremelyinteresting is that unlike other books that tend to rely on second hand material, with exhaustive references and quotes, Paola Manfredi has filled her tome withpassionate grass-roots level research. The narrative more in the nature of a personal journey, with all the quirks and street-smart practicality, makes the bookrefreshing. As Paola says in the book, it is not a scholarly or academic research but more of a documentation of the world of chikankari. Paola questions the use of chikan as a word for embroidery, highlighting that it has a broader connotation encompassing haute couture, the fine art of making agarment, embroidering it and finishing it with finesse. She is no stranger to chikankari having worked with SEWA and several craftsmen. Her love for white on whiteembroidery also found a calling in chikan. Paola came to India to work in textile exports and as she says, “If you like textiles ... India is a heaven, an inexhaustibletreasure trove.” Why did Paola come to India?