Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . For the following situation, create an enhanced ER diagram: An on - line music company would like to develop a database of all

1. For the following situation, create an enhanced ER diagram:
An on-line music company would like to develop a database of all individuals
who use its website. Each PERSON can be either a MEMBER or a VISITOR,
but not both at the same time. Also, there are other individuals who may visit
the website. The company would like to track the following for each person:
Location
IP address
The following information needs to be stored for visitors:
Name
Music interests
The following information needs to be stored for members:
Name
Address
City
State
Zipcode
Userid
Music interests
In addition, members have an ACCOUNT and members place ORDERS for
music.
Please state any assumptions that you make.. i want an ERD diagram correctly. just dont give whatever asnwerr you know please

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

The Structure Of The Relational Database Model

Authors: Jan Paredaens ,Paul De Bra ,Marc Gyssens ,Dirk Van Gucht

1st Edition

3642699588, 978-3642699580

More Books

Students also viewed these Databases questions

Question

What is Centrifugation?

Answered: 1 week ago

Question

To find integral of ?a 2 - x 2

Answered: 1 week ago

Question

To find integral of e 3x sin4x

Answered: 1 week ago

Question

To find the integral of 3x/(x - 1)(x - 2)(x - 3)

Answered: 1 week ago

Question

What are Fatty acids?

Answered: 1 week ago