Please use Visible Analyst Software to draw the ERD of the Symphony Orchestra. Print your ERD after drawing it with Visible Analyst Software. Next transform it into TABLES. Print the TABLES. Finally, generate the metadata or SCHEMA using Visible Analyst, clean your schema and print your schema.

After completing a course in database management. you have been asked to develop a preliminary E-R diagram for a symphony orchestra. You discover the following entity types should be included: 8. CONCERT SEASON The season during which a series of concerts will be per- formed. Identifier is Opening_Date, which includes Month, Day, and Year CONCERT A given performance of one or more compositions. Identifier is Concert Number. Another important attribute is Concert Date, which consists of the following: Month, Day. Year, and Time. Each concert typically has more than one concert date. COMPOSITION Compositions to be performed at each concert. Identifier is Composition_ID, which consists of the following: Composer_Name, and Comppsition Name. Another attribute is Movement ID, which consists of two parts: Movement Number, and Movement_Name. Many, but not al, composi tions have multiple movements. CONDUCTOR Person who will conduct the concert. Identifier is Conductor_ID Another attribute is Conductor_Name. SOLOIST Solo artist who performs a given composition on a particular concert. Identifier is Soloist_ID. Another attribute is Soloist Name. P: During further discussions you discover the following A concert season schedules one or more concerts. A particular concert is scheduled for only one concert season. A concert includes the performance of one or mute compositions. A coimposition may be performed at one or more concerts, or may not be performed. For each concert there is one conductor. A conductor may conduct any number of.. concerts, or may not conduct any, concerts. Each composition may require one or more soloists; or may not require a soloist. A soloist may perform one or more compositions at a given concert, or may not perform any composition. The symphony orchestta wishes to record the date when a soloist last performed a given composition (Date_Last Performed) Draw an E-R diagram to represent what you have discovered, as explained above