Based on the given tables, write the business rules that govern the relationship between Director and...

Transcribed Image Text:

Based on the given tables, write the business rules that govern the relationship between Director and Play; create the basic Crow's Foot ERD; draw the equivalent object representation and UML class diagram PLAY CODE 1001 1002 1003 1004 1005 1006 1007 PLAY NAME Cat On a Cold, Bare Roof Hold the Mayo, Pass the Bread I Never Promised You Coffee STUDENT Silly Putty Goes To Washington See No Sound, Hear No Sight Starstruck in Biloxi Stranger In Parrot Ice Table: Play registers ENROLL DIR NUM 102 101 102 100 101 2. Create an ER Diagram to model the following business rules: In a soccer club, a player is assigned to one team. A team has one or more players. A team is leaded by one or more coaches. A coach coaches one or more teams. 3. Given the ERD, describe the relationships, and write the business rules. shows in COURSE 102 101 CLASS DER NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 102 Goofy 1965-01-12 1953-11-18 1962-06-21 Table: Director Again, with consideration of Jackson's equation (5.4), show the steps required to arrive at the integral expression for the magnetic induction generated in unbounded vacuum by a current density, (2). Again, please use full mathematical rigor, whenever possible, Le, for full credit. Based on the given tables, write the business rules that govern the relationship between Director and Play; create the basic Crow's Foot ERD; draw the equivalent object representation and UML class diagram PLAY CODE 1001 1002 1003 1004 1005 1006 1007 PLAY NAME Cat On a Cold, Bare Roof Hold the Mayo, Pass the Bread I Never Promised You Coffee STUDENT Silly Putty Goes To Washington See No Sound, Hear No Sight Starstruck in Biloxi Stranger In Parrot Ice Table: Play registers ENROLL DIR NUM 102 101 102 100 101 2. Create an ER Diagram to model the following business rules: In a soccer club, a player is assigned to one team. A team has one or more players. A team is leaded by one or more coaches. A coach coaches one or more teams. 3. Given the ERD, describe the relationships, and write the business rules. shows in COURSE 102 101 CLASS DER NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 102 Goofy 1965-01-12 1953-11-18 1962-06-21 Table: Director Again, with consideration of Jackson's equation (5.4), show the steps required to arrive at the integral expression for the magnetic induction generated in unbounded vacuum by a current density, (2). Again, please use full mathematical rigor, whenever possible, Le, for full credit.