Classfieds site DB design clarification
I just want to know whether the database design is fine and normalized. Also, I want to know whether I have captured all the data related to the major categories like Car, Property(Land, House), Job details.
    
    Let me explain the DB tables now. 
    
    To store the Ad's, I have created a table called AdClassifieds which holds the Ad details (Title, Description, Type of Ad (offered, wanted), SubCategoryId (like cars, house & etc... the main category will be identified using this id), UserType (Individual, dealer),
    IsFreeAd, AdPrice, AdCurrencyId (like US, UK, India & etc...)..
    
    Also, the photos related to the Ad will be stored in the AdPhotos table.
    
    So, based on the SubCategoryId in the AdClassifieds table the detail table will be accessed. For example, if the ad is related to Car, then Car details will be fetched from AdCarDetails table. Similarly for Jobs, Property categories AdJobDetails, AdProperty tables will be used respectively.
    
    Also, please advise me on how to efficiently search the Ads from the DB.
    
    Please find the attached file.

![Classifieds DB design][1]
    
    
[1]: http://i.stack.imgur.com/cYorn.jpg
    
    Thanks in advance
Classfieds site DB design clarification
===

I just want to know whether the database design is fine and normalized. Also, I want to know whether I have captured all the data related to the major categories like Car, Property(Land, House), Job details.
    
    Let me explain the DB tables now. 
    
    To store the Ad's, I have created a table called AdClassifieds which holds the Ad details (Title, Description, Type of Ad (offered, wanted), SubCategoryId (like cars, house & etc... the main category will be identified using this id), UserType (Individual, dealer),
    IsFreeAd, AdPrice, AdCurrencyId (like US, UK, India & etc...)..
    
    Also, the photos related to the Ad will be stored in the AdPhotos table.
    
    So, based on the SubCategoryId in the AdClassifieds table the detail table will be accessed. For example, if the ad is related to Car, then Car details will be fetched from AdCarDetails table. Similarly for Jobs, Property categories AdJobDetails, AdProperty tables will be used respectively.
    
    Also, please advise me on how to efficiently search the Ads from the DB.
    
    Please find the attached file.

![Classifieds DB design][1]
    
    
[1]: http://i.stack.imgur.com/cYorn.jpg
    
    Thanks in advance