Each owner owns one or more cats, and every cat has exactly one owner.

Question

• 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

Answer 1

INSERT INTO breeds (description) VALUES
('Sia'),
('Bur'),
('Sph'),
('Per'),
('MainCoon');