1 Replies - 921 Views - Last Post: 27 November 2012 - 04:24 AM Rate Topic: -----

#1 diorno  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 18-September 12

Database design and creation help...!

Posted 27 November 2012 - 04:10 AM

Hello everyone...!!!

I need some help,
my teacher gave me a project which have to do with web programming.

He told me to make a project for e-commerce, something like buying/selling online, using paypal.
What i think to do is to make a website for car selling and buying.

I am not very good with desinging the project.

Can anybody help me with the design of the database for example (how many tables will be neccessary, how relations do i have to create, do i need to create SP) any thing else is highly apreciated thnak you.

Is This A Good Question/Topic? 0
  • +

Replies To: Database design and creation help...!

#2 rnty  Icon User is offline

  • D.I.C Regular

Reputation: 19
  • View blog
  • Posts: 272
  • Joined: 14-August 12

Re: Database design and creation help...!

Posted 27 November 2012 - 04:24 AM

At first make it as simple as possible.
You could have a single table having item_name,price,no_in_stock,no_sold,price,etc.
Later you can normalize the table and in doing so you would establish relationships between them instead of creating one

Tip:A standout feature would be a good response time with increasing data load.Hint:OLTP

Hope this serves your initial extremely rough draft
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1