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, 03.07.2019 15:10, EmilySerna
Heat is added to a piston-cylinder device filled with 2 kg of air to raise its temperature 400 c from an initial temperature of t1 27 cand pressure of pi 1 mpa. the process is isobaric process. find a)-the final pressure p2 b)-the heat transfer to the air.
Answers: 1
image
Engineering, 04.07.2019 18:10, hadellolo8839
Acompressor receives the shaft work to decrease the pressure of the fluid. a)- true b)- false
Answers: 3
image
Engineering, 04.07.2019 18:10, jesuslovesusall3
Courses that are developed by subject matter experts, internal or extemal to the college or university. these programs are marketed by the school (clo2) marks a)-vocational schools b)-vendor training c)-colleges & universities d)-continuing education programs
Answers: 2
image
Engineering, 04.07.2019 19:20, mariahmimibrooks
Liquid flows at steady state at a rate of 2 lb/'s through a pump, which operates to raise the elevation of the liquid 100 ft from control volume inlet to exit. the liquid specific enthalpy at the inlet is 40.09 btu/lb and at the exit is 40.94 btub. the pump requires 3 btu/s of power to operate. if kinetic energy effects are negligible and gravitational acceleration is 32.174 tt/s, the heat transfer rate associated with this steady state process is most closely 1)-2,02 btu/s from the liquid to the surroundings 2)-3.98 btu/s from the surroundings to the liquid. 3)-4.96 btu/s from the surroundings to the liquid. 4)-1.04 btu/s from the liquid to the surroundings.
Answers: 2
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: