943,667 Members | Top Members by Rank

Ad:
Dec 11th, 2008
0

Db structure needed please

Expand Post »
Hi,

I am a technophobe in his last year of a business/computing degree. If someone gave me the db structure for my final year project interim report to be handed in tomorrow I will be forever grateful................

I am designing a website where people can search for spare car parts. It will basically display a bunch of listboxes until the desired car part is found. My technophobish mind has the project like this....

Search: Car Make -> Car Model -> Reg Year -> Part Group -> Part Type...... Car Part is then displayed if it is available.

If someone could give me a rough db structure for this I would be very happy.

p.s When the car make is selected e.g Ford, then only models that relate to Ford should shown e.g Mustang. Then, only car parts that relate to mustang should be shown etc.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jamescumm is offline Offline
2 posts
since Nov 2008
Dec 15th, 2008
0

Re: Db structure needed please

Hi,

I've actually got an extension on the hand in date so any reply would be very helpful!

Thank You
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jamescumm is offline Offline
2 posts
since Nov 2008
Dec 16th, 2008
0

Re: Db structure needed please

I'm not gone give you solution as that is for you to figure out, so consider following:
  1. There are two attributes by which you can accompany/describe car maker which are....?
  2. The car model can be described in similar way as car maker, plus you have to link it up with car maker
  3. In the same manner, as in the previous point described, rest of the tables should be done
Can you work "the magic" for me now?
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,654 posts
since Dec 2004
Jan 9th, 2009
1

Re: Db structure needed please

Let me get this straight.

You're a TECHNOPHOBE doing a DEGREE course with a large COMPUTING involvement and you want US (who are TECHNOPHILES and [mostly] have finished our degrees) to do this work for you. Is that correct?

If the answer to the above is YES and this is for a COMPUTING module, please post your School / College / Uni name & address and your Tutors name and I'll see if he too thinks that you should fail.

If the answer to the above is YES and this is for a BUSINESS module then you are a back stabbing, plagerising b**tard and will most probably get a 'first'.

If the answer to the above is NO then please rewrite your question a LOT more clearly.
Last edited by pclfw; Jan 9th, 2009 at 9:53 am.
Reputation Points: 33
Solved Threads: 9
Junior Poster
pclfw is offline Offline
132 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Look table design help
Next Thread in Database Design Forum Timeline: Database reverse engineering problems





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC