Following the preceding suggestions, after reviewing the customer requirements and interviewing stakeholders, you might discover that each of the groups defined previously needs the following information about products:
Group | Information Needed |
Casual Website Visitors | Product photo, category, title, price, and description |
Members | Same as website visitors + unit of measurement and units on hand |
Administrative Assistants | Same as members + cost per unit |
Management | Same as administrative assistants |
It is the job of your application to determine the website visitor's role. Your application must also determine, based on the role, what level of access to the database should be granted and what information this user can view.
A decision that you need to make for this example is how to store information about the photo. One obvious approach is to simply store a URL that points to the photo. Another possibility is to store the photo...