Scenario:

Pinki is fond of pets specifically dogs. She always wants to promote love with pets specifically the rare breeds. In order to meet her desire she often invites her friends and acquaintances to visit her home. They can get from her spare dogs and their puppies free of cost. Pinki wants to systematically handle this process of keeping and giving of the puppies that she has. She wants to keep track of the current stock position and giving of pets breed along with information about their family hierarchy. In this way she wants to send her message of love with pets to the maximum number of people she comes across. In order to help Pinki to achieve her goal you are require to develop a database system for her. For this database you have to accommodate record of at least 4 breeds of dogs.

Question: By using SQL Script (NOT through wizard) on your installed version of SQL Server Create tables, with necessary keys and constraints; Develop relationship diagram, and Insert data into tables through SQL script at least 10 records in each table (among the 10 records in the Friend table, one should be with each of yours own name).