Hello
I would like to work with you on your project. I assume that this is for a data warehouse course. I can build start schema with all the desired requirements. The logical ER will be for an OLTP application and the Physical will be a star schema ER design.
Your requiremetns document state that the system must be approved by instructor. So, what is the system do you have in mind? Sales Mart? Inventory Mart? CRM Mart?
I am not sure what your teach expects, so maybe you can tell me more.
If you have any questions, please contact me on Freelancer.
Regards,
EK
B.Sc.,MCP, MCAD, MCT