Database Principles Question.. ... Answers to those question..Answer in required formet

Answer this following:

1) Draw the ERDs(Entity Relationship Diagram) needed to describe this database showing all attributes, relations, cardinality, and modality

Example Of ERD:

2) In your own words, explain which normal form that each table is in and justify your conclusion

3) Using the MySQL command line, create a database named in SBL and build the normalized ERDs that resulted from steps 1 and 2

Super Baseball League. The Super Baseball League wants to keep track of information about its players, its teams, and the minor league teams (which we will call minor league "clubs" to avoid using the word "team" twice). Minor league clubs are not part of the Super Baseball League but players train in them with the hope of eventually advancing to a team in the Super Baseball League. The intent in this problem is to keep track only of the current team on which a player plays in the Super Baseball League. However, the minor league club data must be historic and include all of the minor league clubs for whic names, minor league club names, manager names, and stadium names are assumed to be unique, as, of course 1s player number. h a player has played. Team Design a well structured relational database for this Super Baseball League environment using the data normalization technique. Progress from first to second normal form and then from second to third normal form iustifying your design decisions at each step based on the rules of data normalization. The attributes and func- tional dependencies in this environment are as follows: Attributes Plaver Number