Question $1$

Draw a physical data model for a group of galleries belonging to different owners and display artists$$ paintings to sell. Below the Use case diagram, the attributes to be stored as well as assumptions to be accepted:

$$

Attributes:

Artist name $($consisting of last name and first name$)$

Artist email address

Artist phone number

Owner ID number

Owner name $($consisting of last name and first name$)$

Owner phone number

Gallery name

Gallery owner

Gallery phone number

Gallery percentage profit

Painting title

Painting price

Painting date received

Assume the following:

$$Each artist can paint many paintings but one painting is painted by exactly one Artist.

$$There can be new artists who have not yet painted any paintings.

$$Each painting is displayed in exactly one gallery and every gallery contains at least one painting.

$$Each gallery is owned by exactly one owner and every owner owns at least one gallery.

Question $2$

Use the Use$-$Case diagram of Question $1$ and the physical data model to draw a physical process model for the system to be developed in Visual Studio on Windows $10$ with database in SQL Server to provide the following functionality:

I.A gallery assistant must be able to add a new painting, change the data of existing paintings and also remove paintings $($read from PAINTING, read from PAINTER, read from GALLERY, new and updated records to PAINTING, remove records from PAINTING$).$

II$.$A gallery assistant must be able to sell a painting $($read from PAINTING, read from PAINTER, read from GALLERY, write updated record to PAINTING$).$

Question $3$

Use the Use Case diagram of Question $1$ and the physical data model to draw a physical process model for the system to be developed in Visual Studio on Windows $10$ with database in SQL Server to provide the following functionality:

I.A gallery manager must be able to add a new gallery, change the data of existing galleries and also remove existing galleries $($read from GALLERY, read from OWNER, new and updated records to GALLERY, remove records from GALLERY$).$

II$.$A gallery manager must be able to request reports from all data stores $($read from GALLERY, read from OWNER, read from PAINTING, read from PAINTER$).$

Please draw the DFD