Database Designing Related

  • 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.

  • 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
  • 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....

  • 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
  • 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.

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

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

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