Please Anser using Microsft SQL server Implement the following design in your database under the schema LabAssignment2. Create the tables by identifying the appropriate data types and column constraints. Establish the relationship between the two tables by including the foreign key constraint. Include the foreign key and primary key constraint at the column level.

Date Price ID ISBN Book has Publisher Title Name Your table must be able to enter the following data values 1 2 PublisherID Name P1 Murach P2 Prospect Press 1 2 3 ISBN 978-1-890774-96-7 978-1-943153-18-3 978-1-943872-38-1 Price Date Title 57.50 2016-06-01 00:00:00.000 Murach's SQL Server 2016 for Developers 51.50 2015-11-30 00:00:00.000 Database Systems: Introduction to Databases and Data Warehouses 55.75 2014-08-20 00:00:00.000 Murach's PHP and MySQL PublisherID P1 P2 P1 Part a) provide the SQL for creating the tables Part b) Provide SQL for inserting the above data into each table