Question: Hi, i'm trying to create a database system for a Bookstore. I want relationships like, books can have many author and publishers here by enroll

Hi, i'm trying to create a database system for a Bookstore. I want relationships like, books can have many author and publishers here by enroll and i'm confused. Please make a correct eer diagram for these entities.

Book ISBN Book_Ccode Author_ID item_Number Book_Price Publisher Published_Oi Book_CCo Book_Title Author Author_ID A_Name A_Address A_Email Book_Author(for many to many) Author_ID ISBN Book_Categories Book_CCode Book_CDescription Publisher Pub_ID Pub_Name Pub_Address Pub_Phone Pub_Email Book_Publisher(for many to many) Pub_ID ISBN Order_Items item_Number order_ID ISBN item_comment Order Order_ID Customer_ID Order_Date Order_Value Customer Customer_ID C_Code C_Name C_Email C_Address C_Phone Warehouse Warehouse_ID item_Number Address Phone Code

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

20 Proposals Proposals are part of our personal lives: lovers propose marriage, friends propose sharing dinner and a movie, you offer to pay half the cost of a car and insurance if your parents will...

Create a use case diagram for the following case. Provide "Use Case Descriptions" for those use cases that include the Publisher as an actor. Don't worry about descriptions for other use cases...

The Internet has stirred your entrepreneurial spirits. Over numerous cups of Starbucks coffee, you and a couple of friendsJulio and Olafhave concluded that there is a tremendous potential business...

Project Management Casebook David I. Cleland, Karen M. Bursic, Richard Puerzer, and A. Yaroslav Vlasak Library of Congress Cataloging-in-PublicationData Project management casebook /edited by David...

Please answer Discuss the possible challenges Amazon could face in China going forward. What should it do in such a scenario? What are the future challenges? Use the BCG Matrix to evaluate Amazons...

For the exclusive use of F. Ortolano, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

Case Description: FAME (Forondo Artist Management Excellence) Inc. is an artist management company that represents classical music artists (only soloists) both nationally and internationally. FAME...

For the exclusive use of S. Setiawan, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

Communications of the Association for Information Systems Volume 15 Article 5 1-26-2005 Outrigger Hotels and Resorts: A Case Study Gabriele Piccoli Cornell University, gp45@cornell.edu Follow this...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee....

The cost in dollars of making x items is given by the function C(x) = 10x + 500. a. The fixed cost is determined when zero items are produced. Find the fixed cost for this item. b. What is the cost...

McDougal Company uses a predetermined overhead rate to assign overhead to jobs. Because McDougals production is machine intensive, overhead is applied on the basis of machine hours. The expected...

If your bank lets you download your bank statements online, you can import your statement into Sage 5 0 Accounting. True False

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+pandemic (that began in 2020)? What personal, organizational, and country issues would confront the Baileys and Kline & Associates? If you were Fred Bailey,

=+3 What are the root causes of the problems that Fred Bailey experienced?

=+1 Who has responsibility for this situation? What is the nature of various stakeholders responsibilities? Headquarters HR? Japan HR? Fred Bailey? Jennifer Bailey? Dave Steiner, the company managing...