Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a question for database for business subject For each of the descriptions below, perform the following tasks: a Business rules for each description

This is a question for "database for business" subject

image text in transcribed
For each of the descriptions below, perform the following tasks: a Business rules for each description (2 points each) 0 Identify the relationship (2 points each) 0 Express the relationships in each description graphically with an E-R diagram {ERD} (2 points each) 1. A book is identied by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. 2. A book (see previous question) is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books; in addition, occasionally data are needed regarding prospective authors who have not yet published any books. 3. A vendor builds multiple types of tablet computers. Each has a type identication number and a name. The key specifications for each type include amount of storage space and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet computer type; obviously, the same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identies it

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

Quantitative Methods For Business

Authors: Donald Waters

5th Edition

273739476, 978-0273739470

More Books

Students also viewed these General Management questions

Question

a. Does your organization have a compliance and ethics office?

Answered: 1 week ago

Question

LO12.3 Explain how demand is seen by a pure monopoly.

Answered: 1 week ago