I dont guess anyone could help me out on setting up my products tables could they?

I did search and read through these posts:
http://www.daniweb.com/web-development/databases/threads/123850/e-commerce-data-design-issue
http://www.daniweb.com/web-development/databases/threads/132796/database-schema-for-a-store

But I'm still not sure, Currently my site will only have 3 separate products, each with their own set of attributes.

How should I post my ERD? I have it as public on my picasa album.

Thanks ahead of time for any help/feedback !!!!
Montgomery

Member Avatar for LastMitch

@fouledout443

I dont guess anyone could help me out on setting up my products tables could they?

Since you already set up a e-commerce website and running. The question is you ask doesn't make any sense?

The reason why is it doesn't make sense is that if you already set the website up and running. It tells me that you already created a DB to stored those data.

Another words you should be able create a table to stored it in the Db.

You only need to fetch the id so the prices appears.

whts ur need? what columsn u need?

Member Avatar for LastMitch

@fouledout443

I dont have a site that functions, just a simple front end. As of right now, (how im planning) is for it to only have three types of products.

Are you familiar with PHP & MYSQL/MYSQLI and a little Javascript?

That's all you really need to create the backend.

No, sorry, I have only used MS SQL and ASP.NET

Member Avatar for LastMitch

@fouledout443

No, sorry, I have only used MS SQL and ASP.NET

So your e-commerce website is written MS SQL and ASP.NET? That will work. I don't see any issue with that.

For MS SQL read this (You don't necessary need to used that SMS, you can used any SMS you want. It's just that it has a nice image to let you see how to create a database and tables in MSSQL):

http://www.ozekisms.com/index.php?owpn=264

Read this about displaying products:

http://www.asp.net/web-forms/tutorials/tailspin-spyworks/tailspin-spyworks-part-4

I will be using a lot of the functionality from the tailspin spyworks application, but my class requires me to do atleast a 3 teir architecture between the presentation, business logic and data access layers.

My main concern is that I get the relationships between all of my tables setup properly before I proceed with actually creating the tables, stored procedures and triggers.

Im trying to figure out what all I should have within my shopping cart table, what do you think about it?

Heres an updated link: https://picasaweb.google.com/lh/photo/5odoODyQMMbO5gMRC0mXLdMTjNZETYmyPJy0liipFm0?feat=directlink

Thanks for the help LastMitch!

Member Avatar for LastMitch

@fouledout443

Im trying to figure out what all I should have within my shopping cart table, what do you think about it?

I'll honest I never used MS SQL and ASP.NET as creating a e-commerce website. I'm more PHP & MYSQL/MYSQLI and a little Javascript.

Here's a link regarding about shopping carts:

http://www.asp.net/web-forms/tutorials/aspnet-45/getting-started-with-aspnet-45-web-forms/shopping-cart

As you notice that ASP.net has many tutorial compare to PHP because in order to run ASP.net you need to have their software (Microsoft). PHP have a PHP Frameworks instead.

Its alright! I understand, hopefully this summer I will be able to start looking into using PHP and MYSQL.

Thanks LastMitch!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.