The Medinest pharmaceutical is life saving drugs Distributor Company that have registered district level franchisees in all over Pakistan
On demand the Medinest Company delivers the products to the particular franchisee. All the Franchisees make advance payment to the company account, either through online banking or through demand draft. As the franchisee is assigned the limited area. So no two franchisees are allowed to sale the products in one area. If the Franchisee is not able to meet the company sale target then company has the right to cancel the membership of that franchisee.
You are required to find the total attributes of all the relations used in this scenario, find the Facts for the fact table and also draw the star schema of the given scenario.
NOTE: - These Assignments OR Quiz are just for idea, so kindly don't copy it, after viewing it make your own. Thanks We always try our best to upload 100% correct solution BUT it is requested that you kindly review it before submission, please BEST OF LUCK, Thanks to those students those send me Assignments and quizzes. If you have any Assignment and quiz kindly send at jamilbookcenter@yahoo.com
No comments:
Post a Comment