Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help me with this 1. The ERD below is a conceptual model of a bookstore. Most attributes should be clear to understand and

image text in transcribed

can someone help me with this

1. The ERD below is a conceptual model of a bookstore. Most attributes should be clear to understand and may not require additional explanation. The attribute sup category represents preference of the company for a particular supplier. The values for this attribute 5 could be "highly preferred" or "not at all preferred" or some other labels. The attribute sup type represents what kind of content a supplier can provide. The company retails different content types, such as books, magazines, games, multimedia, and so on. 2. Map the given E-R diagram to a Relational model. Use all standard conventions. Establish associations between the tables by inserting "Foreign Keys." Now assign domains to all attributes. This involves choosing appropriate data types and a range of acceptable values tor each attributes SUPPLIER sup Name sup Address sup City sup_Phone sup-Email sup_Type sup Category STORE SHELF st Name st-Address st Phone st Zip st_Region Located-in- shf Num shf_Location BOOK SBN Title Genre Carry -_--Edition Fulfills Year Cost PORDER PO Number Date Delivery_Date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students also viewed these Databases questions