Write definitions & attributes for Payment, Customer, Subscription

G915-2-Data-Modeling-381 / Project-1-eStreamingMovies

Collaborate and use the best from each of the group member's individual project and create the modernized YourName-eStreamingMoviesSqlServer2019-yyyymmdd. Highlighting the individual's contributions for the best solution. Read the Project one Specification Read the Project plan

0 stars 0 forks source link

Write definitions & attributes for Payment, Customer, Subscription #26

Closed ambergarcia closed 2 years ago

tom11322 commented 2 years ago

Payment: A method the customer pays to buy a subscription. Customer: A person that buy a subscription. Subscription: A rental of a movie that the company own.

tom11322 commented 2 years ago

Payment: PaymentID (PK) PaymentAmount PaymentDate CustomerID (FK) PaymentType

tom11322 commented 2 years ago

Customer: CustomerID (PK) PersonID (FK) Preference* Tier

tom11322 commented 2 years ago

Subscription: SubscriptionID (PK) CustomerID (FK) PaymentID (FK) TierID (FK)

ambergarcia commented 2 years ago

confirmed