The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 305 Weeks Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
So here is the problem statement : Bracken Gallery is a broker for not-so-famous painters. Bracken maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting may be (and may be not) exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is painted by a single painter, but each painter can paint many paintings. There are several art exhibition events throughout this year. Each gallery can participate in many events, and may be not. However, each exhibition event must be participated by at least one gallery. Artists may or may not join any event, and each event may not have artists participate in. Using ARTIST, PAINTING, EVENT and GALLERY, in terms of a relational database. Question 1 is asking me to summarize the business rules that coven the relationship between the four entities. (from my view point there really isn't a clear business rule here) Question 2 is Describe the types of relationships (1:M, M:N, or 1:1) that the relationships between the entities are. Please help with this, I can't seem to figure it out.
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly