Write a case study or scenario description for a Photo Studio Management System project

with complete ER diagram.

Sample: $-$ In a small Jewellery Shop Management System, the customer with their properties customer's

id$,$ name, phone, address, and mail can check the jewellery items available in the shop and select the

product of their choice. A customer is permitted to check more than one jewellery item at a time, and

an available item also can be checked by more than one customer. The jewellery items have some

characteristics, such as item id$,$ name, price, and category. Customers may keep adding one or more

jewellery items to the cart until the end of the product selection cycle. An item may not be added to a

particular customer's cart more than once, but a particular cart could have more items. The cart can have

properties like cart id$,$ item quantity, and total cost depending on items, and their quantity. After adding

all the desired products to the cart, it is up to the customer to confirm the order or not. If the customers

would like to buy the jewellery items added to the cart, the items on the cart go once to order details

with their confirmation. A customer has the right to confirm multiple orders at the same time, but a

specific order in the order details by its properties order id$,$ customized colour, customized shape,

subtotal cost depending on the cart, shipping cost, total payable amount, and order date can be confirmed

by only one customer. The jewellery items available in the shop are divided into different categories. A

category can contain one or more items, but a given item can never be in more than one category.