Case 3 de S At the end of your Annual Conference for the year 2000, when you asked the Area Managers if they have any problems, Mr. Ahmad Nawaz told you that the Senior Finance Executive of his area, Mr. Ali Raza, who had also won the best performance award of the year 1999, was not taking interest in his work. Despite Ahmad Nawaz’s counseling, no change was noticed in the individual, rather his attitude deteriorated. You had also received such information from the National Manager, but considering that Ahmad Nawaz being an experienced hand would solve the problem, you did not interfere intentionally. Now that Ahmad Nawaz himself brought this to your notice, you decided to call the individual and counsel him. During the interview, Mr. Ali Raza initially did not tell you anything but considering his 14 years old association with you, he revealed that he got married five years ago (the marriage was also attended by you) and was still without a child. You were further informed that his parents were forcing him to divorce his wife, whom he loved so much. Moreover, he was also not being understood by the senior managers and was disallowed any kind of leave. Therefore, you concluded that an excellent worker had been disgruntled and had lost interest in his job. 1. As a General Manager, what measures you would take to help / satisfy Mr. Ali Raza and influence change in his behavior?

United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small database to track painters, paintings, and galleries. A painting is painted by only one artist, and that painting is exhibited in only one gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is painted by a single painter, but each painter can paint many paintings.

UBA wants to keep track of each painter’s name, first and last as well as a phone number. Each gallery has a theme as well as a web site for potential buyers to view the paintings it contains. Keeping track of each painting that has a title, created by the painter, requires knowing which gallery it is displayed in and which painter painted the painting. Each table needs a unique identifying attribute.

PAINTER PAINTING GALLERY

An ERD for this problem is below:

Using PAINTER, PAINTING, and GALLERY, as table names, what attributes and keys are needed to create these tables for a relational database?