DRAG DROP
You are creating a stored procedure which will insert data into the table shown in the Database schema exhibit.
(Click the exhibit button.)
You need to insert a new customer record into the tables as a single unit of work.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments to the answer area and arrange the, in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders
you select.
Select and Place:
Answer: 
Explanation:
The entities on the many side, of the 1-many relations, must be added before we add the entities on the 1-side.We must insert new rows into BusinessEntityContact and BusinessEntityAddress tables, before we insert the
corresponding rows into the BusinessEntity and AddressType tables.
I think: first we need to populate tables that have PK AddressType.AddressTypeID and BusinessEntity.BusinessEntityID then we will be able to populate BusinessEntityAddress and BusinessEntityContact tables that have FK constraints with AddressType and BusinessEntity tables.
what a bullshit, the provided answer is wrong again! it is against the common sense – first create a contact and then create a person