Dating site database design

Dating > Dating site database design

Click here:Dating site database design♥ Dating site database design

Cool features make the site interesting for the members and prompt them to come back and stay longer. Chameleon Social for me dating site database design the best script in 2017. Caballeros can be easily added on to images, email implicit contact forms for effective communication, inventive smilies that make chatting fun, and flexibility of choice between free registration or invitation based registration for users — the world of options with this script is huge. You can not sin for the user what he or she needs. Had a few issues with the installation but all was taken care in a reasonable response time. Your dreams of monetizing a well marketed online dating portal are just a few clicks away with this free builder at your disposal. Advanced search engine function with multivariable search fast search, full search etc.

I am tasked with designing a dating site in with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile some profile questions might be: nationality, education, age, eye color, etc, etc.. Each of these profile questions could either contain a single value from a radio button example: are you male or female , multiple values from a list of checkboxes example: check your hobbies and interests or text ex: tell in a short paragraph what you are looking for. Does anyone have any advice as to the best way to design this. Here are some of the options I am considering: 1 Create a different table for each profile question: example: EyeColor -------- UserId int or guid EyeColor varchar Interests --------- UserId InterestValue I see this as being a problem because there could be upwards of 50 table joins for each search query and the database would need to be updated if a profile question is added or no longer used. Another dilema is that I would like to avoid using dynamic SQL, but I dont know how I could search accross a varied number of parameters with a stored procedure. Could anyone give me some advice on any of the above. Any advice would be appreciated. This is my recommendation: Create one 'user' table that stores, at a minimum, UserId, but could also store name, DOB, etc. This table needs an int field to join to the ID of the Attributes table and a text field to hold the responses to the questions As you can see, the responses for all questions will be in this table. This table will have an int field to join to the user ID and an int field to join to the responses table. The user table holds the user name, the user responses table holds the answers, and the responses table hold the text of the answers. Also, each question can be answered with multiple answers. Additionally, this method is very flexible in the different queries you can create... The only issue with this method is that you need to handle text answers separately; this method only works for multiple choice answers. However, using this method and mixing it with a text answer method should not be difficult. Let me know if you have any questions! It helped me a lot i am got a dating site from friend and i want to make similar to that site by this post i got so many things to learn that how to make a database to make you dating site. I was little bit confused about the database but after getting your idea i am confident that i can do this. I would like to make some more idea clear from you would you please help me more? Thank you in advance. I am tasked with designing a dating site in with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile some profile questions might be: nationality, education, age, eye color, etc, etc.. Each of these profile questions could either contain a single value from a radio button example: are you male or female , multiple values from a list of checkboxes example: check your hobbies and interests or text ex: tell in a short paragraph what you are looking for. Does anyone have any advice as to the best way to design this. Here are some of the options I am considering: 1 Create a different table for each profile question: example: EyeColor -------- UserId int or guid EyeColor varchar Interests --------- UserId InterestValue I see this as being a problem because there could be upwards of 50 table joins for each search query and the database would need to be updated if a profile question is added or no longer used. Another dilema is that I would like to avoid using dynamic SQL, but I dont know how I could search accross a varied number of parameters with a stored procedure. Could anyone give me some advice on any of the above. Any advice would be appreciated. Edited 8 Years Ago by nav33n: Website snipped. Do not spam, advertise, plug your website, or engage in any other type of self promotion. Is there be a way to incorporate this to send each user that has a match a notification via email?

Last updated