Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Desktop Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each have a sales manager and sales

Desktop Publishing is a textbook publishing company with a headquarters location, a warehouse, and three sales offices that each have a sales manager and sales reps. Desktop sells to schools, colleges, and individual customers. Many authors write more than one book for Desktop, and some books are written by more than one author. Desktop maintains an active list of more than 100 books, each identified by a universal code called an ISBN number. You have been asked to draw an ERD for the Desktop information system, and to include cardinality notation. The diagram is already made, just explain the diagram in 300 words

image text in transcribed

Books Books ISBN Number (Primary) Pub Year Cost Pages ISBN Number (Primary) Pub Year Cost Pages Customers Desktop Text Publications Category Number (Primary) Address Phone Number SalesOffice Headquarters Warehouse Sales Office_Number (Primary) Location Location Location Sales_Manager Sales_Rep SM ID Name Phone Number SR ID Name Phone Number

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

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions