One-to-many relationship

One-to-many relationship is used when you have two models, where one entity can only be related to one record, but the other can be related to more than one. For example, a person can many phone numbers, but phone number can only be associated with one person. Otherwise, it wouldn’t work!

Example

CREATE table person {  
	personId INTEGER PRIMARY KEY,  
	name TEXT,  
	UNIQUE(personId)  
}  
  
CREATE table phoneNumber {  
	phoneId INTEGER PRIMARY KEY,  
	personId INTEGER,  
	phoneNumber TEXT,  
	FOREIGN KEY personId REFERENCES person(personId)  
}