table with multiple activity

Posted by Klbaiju under Sql Server on 11/3/2011 | Points: 10 | Views : 979 | Status : [Member] | Replies : 2
Hi,

in my application there is a kids table .i want to create tables for kids and activities.
suppose a kid have more than one activity. how it is possible. how many tables needed.give an example

Regards

Baiju




Responses

Posted by: Jpchoudhari on: 11/3/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

You can create tables to stored kid's information (personal data like name,address) and Activity table to store different activities.
you now can create a table to map kid-activity

Kind Regards,
Jay

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
CREATE TABLE KIDS(KIDSID INT,KIDSNAME VARCHAR(90))


CREATE TABLE KIDSACTIVITY(ACTIVITYID INT,KIDSID INT,HOBBIES VARCHAR(90),ADDRESS VARCHAR(90),AGE INT)



HOPE THIS WILL HELP
REGARDS


sriram

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response