Hello,i am an expert in database design and UML design.I will design you excellent ERD diagram,concept based on use cases, business rule.I'm a Bsc degree holder in computer science.I have read and understood your requirement and I know you will never regret, thank you.