table with multiple activity

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts