Database Designing Related

Question

Database Designing Related

Krishh

Ten Centuries

Points: 1088
More actions
July 22, 2014 at 11:00 am

#288053

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

This sounds like homework. Designing a DB is a lot of work and you should go step by step with the design.

You have a good example with the AdventureWorks databases, but you shouldn't copy it as it is (anyone with SQL Server experience would notice).

Try to keep it simple, identify entities and their attributes and relationships. Everything comes from there.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Krishh Ten Centuries Points: 1088 More actions · Answer 2

Hi Luis,

Can you just give me an idea of how can we create.... as iam newbie into this.... and i got this to do as an assignment .... please help me out....

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

You could read the Stairway to Database Design[/url] on this site.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

MMartin1 One Orange Chip Points: 27795 More actions · Answer 4

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.

----------------------------------------------------