Individual Project comments

Features to Incorporate:

Retaining the old attributes that exist for payment methods should be prioritized, you did that well!

Constructive Feedback (+/-)

(+) I really liked the structure for the existing Payment types that you created.
(+) Retaining simplicity by sticking to the original model, was a nice touch.
(-) Not many new tables or features were added to make your eStreamingMovies distinct from the original eMovies
(-) Data is technically 'normalized' (no dupe primary keys), but you could go further to further ensure the uniqueness of tuples for your PDM

Adrian Noa

Features to Incorporate:
Definitely need to take charge of the licensing and website idea, very well thought out and the execution was great.

Constructive Feedback (+/-)

(+) The idea for the license and website you created was very well thought out and intriguing
(+) Having your physical merchandise co-exist with your digital is a great improvement to the model.
(-) Sales.Order and Sales.OrderDetail are nice, but I don't think they're necessary for the model's payment system.
(-) Web.WebsiteCustomer is a nice bridge, but if they're only connecting one item that isn't a primary key we can just directly link the Web.CustomerDetail and Web.Website through a foreign key instead via customer id.

Jasminder Garcha

Features to Incorporate:
The subscription service model was great, and we should definitely incorporate the Person-Address entities into our eStreamingMovies.

Constructive Feedback (+/-)

(+) The Person table being used for Employee, Customer, and Stars was a very organizational detail.
(+) The StreamingServiceSubscription of attributes with the tiers, resolution, and device limit was a nice touch. PaymentStatus as a bit value was a great idea.
(+) Your model had a uniqueness value to it overall, it felt like you had made the whole thing from scratch.
(-) The Subscription area should use some fine-tuning, to organize the idea a bit better. I think it's definitely a start to creating a unique model in our team.
(-) Electronic entities are great, but you should also retain physical types of payment. Your model removes the physical aspect (which makes sense, since this medium is currently dying), but maybe for organizations paying for large subscriptions checks could still be a viable type of payment.

Features to Incorporate:

The descriptions you wrote for your models were excellent, I think we should use your techniques in our future model.

Constructive Feedback (+/-)

(+) The streaming tables added provided value to the rest of your model, which retained a similar design to eMovies if not incorporating most of the old elements.
(+) The descriptions and relationships you wrote for your models were great and detailed, regardless of the time spent. Give yourself some credit!
(-) The attributes of your model weren't improved on that much, and your PDM could be normalized a bit more efficiently in the future.

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