A mobile product manager wants to build a database to track the teams mobile products.

a. Write the SQL Script to create the table for a Product which needs to contain ProductId (PrimaryKey), Product Name, Product Type (Which can only contain the values Utility, Social or Game), Priority and Delivery Date. Also, write the SQL Script to create the table Developer which contains the Developers ID (Primary Key), SSN, First Name, Last Name , CountryofBirth, Birth Date, Job title, Bonus Amount and the Product ID of the product being developed by the developer. In addition, Review the requirements below: (20pts).

Add a foreign key to ensure the relationship between the tables.

All columns EXCEPT the Ids and names (Product Name, First Name and Last Name) are NULLABLE.

A Product can have multiple developers working on it, but a developer can only work on one product.