Question
Develop an Access database that can support the following database requirements. Make your own data that demonstrates the model. That is, if there is a
Develop an Access database that can support the following database requirements. Make your own data that demonstrates the model. That is, if there is a one-to-many relationship make certain that the many side actually has many rows that are associated with the one side. If there is a many-to-many relationship make certain that the data demonstrates the many-to-many relationship. If there is a one-to-one relationship make certain that there is only one row for each row.
A company wants to manage its movie collection. A movie has a title, release year, ticket price, and many actors. An actor has a first and last name. An actor can play a role in many movies. A movie can have many actors. A studio can produce multiple movies. A movie is produced by a single studio. A studio has a name and date it was established.
Data does not need to be accurate. You do need data that demonstrates that the problem is solved. There must be at least two rows in each table, and each row must be used.
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