Course Solutions Uncategorized (Solved) : Draw Er Diagram Online Music Shop Following Details 1 Maintain Information Singers Like Si Q30748455 . . . .

(Solved) : Draw Er Diagram Online Music Shop Following Details 1 Maintain Information Singers Like Si Q30748455 . . . .

 

Draw: an ER diagram for a online music shop with following details- (1) It will maintain information about all singers like singer id, name, contact number, address(street, city, pin code.) Note- Singers may have multiple contact numbers. (2) Information about composer like composer-id, name, contact number, address (3) Information about record companies rec-comp id, name, contact number, address (4)Information about customers like customer-id, name, contact number, address (5) It will maintain information about songs like Song-id, Title, movie-name, price, duration, Category, size (6) Customer may place orders for songs online, system must store the order details(Order-id purchase-date, total price) and details of songs in an order. Specify entities, relationship constraints, assumptions clearly.

Draw:

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Solved) : 1 Display Average Maximum Minimum Salary Employees Manager Id 100 1 2count Many Employees Q32006037 . . . .(Solved) : 1 Display Average Maximum Minimum Salary Employees Manager Id 100 1 2count Many Employees Q32006037 . . . .

<br/><img src="https://media.cheggcdn.com/media%2F934%2F9346a305-af81-4129-8e66-1d22181ffbba%2Fimage.png" alt="1. Display the average, maximum and minimum salary of all employees under a manager with ID 100 or 1 2.Count how many employees with null commission 3. Display