Related Questions

How many copies of the database schema are typically used in the redesign process?
A news paper publisher printed 4000 copies of "times of india" at a cost of Rs. 3000. He gave 1000 copies free to different technical institutions. He allowed a discount of 20%. on the published price and gave a copy free for every 20 copies bought at a time. He was able to sell all the copies in his manner. If the published price is Rs 4 per copies, then what is his over all profit or loss percentage in the whole transaction? 
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?
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
Statements : Some clips are copies. Some copies are magazines. No magazines is a dictionary

Conclusions :
I. No copies are dictionary.
II. Some copies are dictionary.
III. Some copies are not dictionary.
IV. No clips are magazines.
Under Section 63 of the Indian Evidence Act, secondary evidence includes:
1. Certified copies
2. Copies made from the original by mechanical processes, and copies compared with such copies
3. Copies made from or compared with the original
4. Counterparts of documents, as against the parties who did not execute them
5. Oral accounts of the contents of a document by a person who has seen it
The cost of setting up a magazine is Rs. 2800. The cost of paper and ink etc is Rs. 80 per 100 copies and printing cost is Rs. 160 per 100 copies. In last month 2000 copies were printed but only 1500 copies could be sold at Rs. 5 each. Total 25% profit on the sale price was realized. There is one more resource of income from magazine which is advertising. What sum of money obtained from the advertising in magazine?
One copy machine can make 20 copies a minute, and a second copy machine makes 15 copies a minute. If the two copies work together, how long would it take them to make 2100 copies?
Read the given statements and conclusions carefully. Assuming that the information given in the statements is true, even if it appears to be at variance with commonly known facts, decide which of the given conclusions logically follow(s) from the statements. Statements: Some cards are postcards. Some cards are envelopes. All envelopes are copies. Conclusions: I. Some copies are envelopes. II. Some postcards are copies. III. Some cards are copies.
Three statements are given, followed by three conclusions numbered 1, 2 and 3. Assuming the statements to be true, even if they seem to be at variance with known facts, decide which of the conclusions logically follow(s) from the statements. Statements: All folders are copies. All books are folders. No copies are pen. Conclusions: 1. No book is a pen. 2. All books are copies. 3. Some copies are books.