Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 1 : Launch MySQL Workbench and review the Sakila schema. Review the EER for the Sakila schema again. Review these possible business rules. An
Part :
Launch MySQL Workbench and review the Sakila schema.
Review the EER for the Sakila schema again. Review these possible business rules.
An actor can star in many films, and a film can involve many actors.
A film can be categorized by one to many categories, and a category can
categorize many films.
A language is used in one to many films.
A country contains one to many cities.
A city has one to many addresses, but an address belongs to one and only one city.
One address can have many stores.
A rental can have many payments.
One film is stored in one to many places in inventory store
A staff member can issue one to many rentals.
A staff member is associated with one to many payments.
Add at least five other new business rules here.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started