Engineering
Engineering, 04.03.2020 04:50, Kzamor

An online music platform, S record, is planning to implement a database to enhance its data management practice and ultimately advance its business operations. The initial planning analysis phases have revealed the following system requirements:

Each album has a unique Album ID as well as the following attributes: Album Title, Album Price, and Release Date. An album contains at least one song or more songs. Songs are identified by Song ID. Each song can be contained in more than one album or not contained in any of them at all and has a Song Title and Play Time. Each song belongs to at least one genre or multiple genres. Songs are written by at least an artist or multiple artists. Each artist has a unique Artist ID, and an artist writes at least one song or multiple songs, to be recorded in the database. Data held by each artist includes Artist Name and Debut Date.

Each customer must sign up as a member to make a purchase on the platform. The customer membership information includes Customer ID, Customer Name, Address (consisting of City, State, Postal Code), Phone Number, Birthday, Registration Date. Customers place orders to purchase at least one album or more albums. They can purchase multiple quantities of the same album, which should be recorded as Quantities Ordered. Each order is identified by an Order IDand has Order Date, Total Price, Payment Method, and Delivery Option.

Q1. Draw an ER diagram for Statement 1 (You can add notes to your diagram to explain additional assumptions, if necessary).

File format: asgmt1_q1_ lastname_firstname. pdf

answer
Answers: 3

Other questions on the subject: Engineering

image
Engineering, 04.07.2019 18:20, esmemaluma00
Find the minimum film thickness for a journal bearing with the data below. shaft diameter, d-50 mm, clearance ratio, cdratio? 0.001, shaft speed, n 2000 rpm; bearing length. i 200 mm; eccentricity ration, ? -0.55. ( note, cdratio-ca/d) the minimum film thickness is um
Answers: 2
image
Engineering, 04.07.2019 19:10, Destinationz
Asteam is contained in a rigid tank with a volume of 1 m3. initially, the pressure and temperature are 7 bar and 500 oc, respectively. the temperature drops due to cooling process. determine: (1) the temperature at which condensation begins in °c, (2) the fraction of the total mass that has condensed when the pressure decreased to 0.5 bar. (3) the volume in m3 occupied by saturated liquid at the final state?
Answers: 3
image
Engineering, 04.07.2019 19:20, ijohnh14
Apure substance is a)-mixture of various chemical elements or compounds b)-substance that has a fixed chemical composition throughout c)-mixture that is homogeneous (such as air) d)-all the answers
Answers: 3
image
Engineering, 04.07.2019 19:20, praveen35301
Amass-spring-viscous damper system of mass 3 kg has a frequency of 100 rad/s and is critically damped. its initial conditions are x(0)-3 mm and (0)-2.3 m/s. does the system overshoot its equilibrium position? prove your answer
Answers: 1
Do you know the correct answer?
An online music platform, S record, is planning to implement a database to enhance its data manageme...

Questions in other subjects:

Konu
Mathematics, 12.02.2021 01:00