Question

Draw an EER diagram for the following problem and map it into tables: the sponsors of a certain TV programs are business men whose attributes are (SSN, name, birth date), companies whose attributes are (company name, year of construction) and clubs whose attributes are (the club name, location). The TV programs are introduced by professional announcer whose attributes are (SSN, name, position). Each announcer may introduce many programs and a program can be introduced by many announcers in a certain day of the week and at a certain time.

Answer 1

Let us solve the above problem in a step-by-step method:

1- First we have certain TV- Programs sponsored by the Businessmen and their formed table as shown below, where TV Programs are mentioned as P1, P2, P3 and so on:

2- Second we have companies, named C1, C2, C3 and so on, having their name and year of construction as shown, followed by the table:

3- Third we have Clubs, named C1, C2, C3 and so on, having their name and location as shown, followed by the table:

4- Lastly we have Announcers, introducing Programs held at certain day's of the week and at a particular time. The table formed is as follows:

All possible Symbols used in the EER diagram are also mentioned. Hope this helps and don't forget to give a positive response to the work.