[Solved] SOLVED: Database Design Discusion Post and Assignment

Discusion Post: Data as a Corporate Resource and Foreign KeysPlease respond to BOTH of the following questions:

Question ADiscuss how data can be a corporate resource and describe how it differs from other corporate resources.

Question BForeign keys make the elimination of redundant data possible. But aren’t foreign keys themselves duplicate data? Discuss the natural duplication of values presented by using foreign keys and if you believe this is a form of data redundancy.

Simple Databases AssignmentPart 1Come up with an original example of a one to many unary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

Part 2Come up with an original example of a ternary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

Part 3Using MySQL Workbench – create a data model for on Adult Baseball league which supports all of the following data requirements:

Teams

A team has a unique number associated with itTeam NameTeam CityEach team has more than one player associated with itPlayers

Each Player has a unique numberA player may play or have played for more than one teamThe number of years and batting average is tracked for each team the player played for.Coaches

In this league, all coaches are also players.A Team can have more than one coach.Bats

A team can have multiple batsEach bat is identified by a unique serial number.

For each of the three models above, you should export your model as a single page PDF and submit the resulting files.