A streaming platform database stores USERS, SHOWS, and REVIE…

A streaming platform database stores USERS, SHOWS, and REVIEWS. Business rules are: a user can review many shows; a show can be reviewed by many users; each review belongs to exactly one user and one show; a user can only submit one review per show; and a show must have at least one review to appear in the ‘reviewed’ catalog. What is the correct minimum and maximum cardinality on each side of the USER-REVIEWS-SHOW relationship?

MedClinic is evaluating whether to build a custom patient sc…

MedClinic is evaluating whether to build a custom patient scheduling system or purchase an existing package. Their scheduling process involves unique multi-specialist appointment cascades not found in any commercial product. The CFO favors buying to save cost. The IT director favors building custom. Applying the build-vs-buy decision framework, which factor most strongly tips the decision toward building custom?

A corporate directory system stores employee records. Each e…

A corporate directory system stores employee records. Each employee may mentor other employees within the same organization. The business rule states: an employee can mentor many employees, but each employee is mentored by at most one mentor. Which ERD construct best models the mentoring relationship, and what is its correct cardinality notation?