1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Kamila [148]
3 years ago
14

Consider a relation BOOKS that holds information about the inventory of books (used or new) in a bookstore with attributes (titl

e, isbn, authorName, publisherName, publisherAddress, copyNumber, total- CopiesOrdered, copiesInStock, publicationDate, category, selling Price, cost, condition), as described below.
• All attributes listed above are atomic.
• The ISBN uniquely identifies a book. (However, it does not identify each copy of the book. If the bookstore has many copies of the same book, each copy is given a different copyNumber as described next)
• copyNumber corresponds to a particular copy of a book with a particular ISBN. For example, there may be copyNumber 34 of the book with ISBN = 123478, and copyNumber 34 of the book with ISBN = 987654. • Each book has one publication date. A revision of a book, for example a new edition, is given a new ISBN.
• A book may have more than one author. 3 of 5
• An author may have more than one book. • Each book has one publisher.
• Each publisher name is unique. Each publisher has one address—the address of the firm's national head- quarters.
• Titles are not unique. • totalCopiesOrdered is the number of copies of a particular book that the bookstore has ever ordered, while copiesInStock is the number still unsold in the bookstore.
• condition describes the condition of a particular copy of a book and is one of "excellent", "very good", "good", "fair"
• Each book has one category. The category may be biography, science fiction, poetry, and so on.
• The selling Price, which is the amount the bookstore charges for a book, is always 20 percent above the cost, which is the amount the bookstore paid to acquire the book.

Required:
What is the highest normal form that the BOOKS relation is in? (justify your answer using functional dependencies)

Computers and Technology
1 answer:
Yuri [45]3 years ago
5 0

Answer:

See explaination

Explanation:

Somehing is considered functional dependent (FD) if a relationship between two attributes, typically between the PK and other non-key attributes within a table. For any relation R, attribute Y is functionally dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.

Please kindly check attachment for the other details.

You might be interested in
_______ is a form of crime that targets a computer system to acquire information stored on that computer system, to control the
postnew [5]

Answer: Computers as target

Explanation:

Whenever an authorized  access is made into a system it is a form of crime and it is called computers as target whereby one is able to access the system and get hands on unauthorized data and can also manipulate various activities which will have many dangerous effects.

8 0
3 years ago
8.3 code practice edhesive PLEASE HELP AND HURRY
NemiM [27]

Answer:

numbers = '14 36 31 -2 11 -6'

nums = numbers.split(' ')

for i in range(0, len(nums)):

  nums[i] = int(nums[i])

print(nums)

8 0
3 years ago
Do the pros of interpersonal communication via social media outweigh the cons? Explain.
JulijaS [17]
Well in my opinion is that yes they do. The ability to be able to communicate with others so far way really helps society advance towards the future. And i cant stress of how the benefits of being able to share ideas with well anyone is so wonderful.

I hope this helps.
6 0
3 years ago
Read 2 more answers
What does brainliest do?
balandron [24]

Answer it gives u points I think

Explanation:

6 0
2 years ago
Read 2 more answers
Which type of network cover a large geographical area and usually consists of several smaller networks, which might use differen
nlexa [21]

Answer: WIDE AREA NETWORK (WAN)

Explanation: hopes this helps

7 0
3 years ago
Other questions:
  • Which character must decide whether to support the assassins or avenge his friend's death?
    14·2 answers
  • Heatsinks used to protect cpus in computers from overheating, are shaped so that their surface area is very large. why is that?
    5·1 answer
  • A way to minimize technical problems with your computer
    14·1 answer
  • Using information from the lesson, explain how new technologies change your experience as a consumer.
    5·2 answers
  • Frank lives in an area that experiences frequent thunderstorms. What precautionary measure should he adopt?
    5·1 answer
  • Which questions should you ask yourself when performing research online?
    9·1 answer
  • The exploitation of a buffer-overrun vulnerability in an application will MOST likely lead to:_________
    15·1 answer
  • The cost to ship a package is a flat fee of 75 cents plus 25 cents per pound. 1. Declare a const named CENTS_PER_POUND and initi
    12·1 answer
  • Which compound is obtained by the oxidation of primary alcohol with nascent oxygen​
    11·1 answer
  • Budgeting for a Computer
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!