Each owner owns one or more cats, and every cat has exactly one owner.
• The name and surname of each owner must be stored in the database.
• The name of each cat must be stored in the database.
• Each cat belongs to one specific breed, and many cats can belong to the same breed.
• The description of each breed must be stored in the database.
• A cat can enter many competitions, and many cats can enter the same competition.
• The description of each competition must be stored in the database
Write the SQL code to populate the table that stores the breeds with data.
Populate the table with the following breed descriptions:
• Sia
• Bur
• Sph
• Per
• Main
INSERT INTO breeds (description) VALUES
('Sia'),
('Bur'),
('Sph'),
('Per'),
('MainCoon');
To populate the table that stores the breeds with the given data, you can use the following SQL code:
```sql
INSERT INTO breeds (description)
VALUES
('Sia'),
('Bur'),
('Sph'),
('Per'),
('Main');
```
Assuming you have a table named "breeds" with a column named "description", this code will insert the provided breed descriptions into the table. Each breed description is enclosed in single quotes and separated by commas within the `VALUES` clause.