Database Designing Related

  • Krishh

    Ten Centuries

    Points: 1028

    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.

  • Luis Cazares

    SSC Guru

    Points: 183637

    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: 1028

    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: 183637

    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: 27502

    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.

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

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

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