Db structure needed please

Reply

Join Date: Nov 2008
Posts: 2
Reputation: jamescumm is an unknown quantity at this point 
Solved Threads: 0
jamescumm jamescumm is offline Offline
Newbie Poster

Db structure needed please

 
0
  #1
Dec 11th, 2008
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.
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 2
Reputation: jamescumm is an unknown quantity at this point 
Solved Threads: 0
jamescumm jamescumm is offline Offline
Newbie Poster

Re: Db structure needed please

 
0
  #2
Dec 15th, 2008
Hi,

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

Thank You
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,122
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 472
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Db structure needed please

 
0
  #3
Dec 16th, 2008
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?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 60
Reputation: pclfw is an unknown quantity at this point 
Solved Threads: 5
pclfw pclfw is offline Offline
Junior Poster in Training

Re: Db structure needed please

 
1
  #4
Jan 9th, 2009
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC