reddychaitanyakrishna (7/22/2014)
Hi Friends,Please Help me......
I Have the below requirement........
1. Design the DB for ‘Retail Stores Business’ where various products are on sale in both physical and online stores across the globe.
2. Design the DB for ‘Car parking allotment’ in commercial business complex.
3. Write multiple stored procs to retrieve sales info. based on each store, product, country.
I think your class should have given you some idea of where to begin to build a database and how extensive they want it. Start to think about all the entities (products, cars, ..) involved, draw out the relationships between them (one to many, ... ) and the transactions that occur involving these. This is not a quick to do and you need to participate in your class through office hours or study groups to get better help.
----------------------------------------------------