question archive Open a new Microsoft® Word document and design a survey form of your own

Open a new Microsoft® Word document and design a survey form of your own

Subject:Computer SciencePrice:3.86 Bought8

Open a new Microsoft® Word document and design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books.

 

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Entity information:

 Publisher, Book, Author. Publisher is the name of the company who printed the book for its distribution. Book is the name of the published book and Author is the name of the book's author. A synonym for Publisher could be editor.

Attribute information:

List all the attributes, their description, synonyms and physical characteristics (such as being 20 characters long and alphanumeric or a number with five digits), along with general information concerning its use. In addition, list any restrictions on values and the place from which the values for the item originate. List any security restrictions that apply to the attribute.

Attributes are publisher code (five digits), publisher name, book code (ISBN), title, book cover (paperback, hardcover), quality (new, used), price, author number (5 digits), author name.

Relationships:

How are the entities related? Are there any restrictions in their relationship?

Book is related to Publisher and to Author. Each book has only one publisher, could have more than one author. A publisher publishes many books. An author can write one o more books.

Functional dependencies:

Can you establish other information about the publisher such as City? If so, you can determine that City is functionally dependent on the publisher code?

No, its independent

Can you establish other information about the Book such as edition number? If so, you can determine that edition number is functionally dependent on the book code?

Yes, its dependent. 

Please see the attached file for the complete solution