MIS $309$ System Analysis and Design $-$ Midterm $2-26\mathrm{.}12\mathrm{.}2023-$ Open Books & Notes of Your Own $-90$ Minutes

CASE : Salespeople Performance System

Chief Sales Officer $($CSO$)$ follows the sales performances of the salespeople working in different regions of the country. The CSO wants the following two reports to be taken from the information system that will be developed;

List of the products that have been sold by a specific salesperson to a specific customer within a specific date.

List of the names of the salespeople who made sales in a specific year in a specific region,

QUESTIONS

Design the codes for regions, salespeople, customers & products $(28$ points$)[$for each of them give the code type and also give an example$]$

Design the database for the above case $(50$ points$)[$for each file; give the name of the file, its type, its organization, its attributes, primary$/$foreign key$($s$)$ if exist$($s$)][$show the relationships between the files, indicate optional$/$mandatory issue$]$

Design the two reports mentioned in the above case $($each report $11$ points$)$