educational course/tutorialoutlet.com educational course/tutorialoutlet.com | Page 72

industry . Each product will be sold under a license contract . Presently , a license contract will be issued for exactly one product , but it is possible that a license agreement will be written in the future that will cover multiple products as new products are developed . Part B : Deliverable : Using ER Assistant , modify your original ERD to accommodate the requirement to allow more than one instance of a given contact type per contract . Also , include new entities and relationships to support benefit tracking in all countries . Depending on your initial design , you may or may not have to modify your ERD to accommodate the new contract types ( License and Maintenance ). You will also have to account for the introduction of products in the business model . In a separate Word document , take a screenshot of your revised ERD and paste it in . Include accompanying notes . After completing your new ER Diagram , convert the diagram into tables with primary keys and foreign keys as appropriate . Use SQL Server to create your tables . Be sure to enforce referential integrity in your CREATE TABLE statements using ― on delete ,‖ ― on update ,‖ etc ., where appropriate . As in Part A , your ERD screenshot must be able to legibly fit on a single sheet in the Word document . To receive credit for your table conversions , include the SQL queries used to generate the tables and paste them into your Word document . Also execute the following command for each table and include results in your document : exec sp _ help [ table name ] Name this document ― CMS Project Part B – your last name followed by your first initial .‖ Screenshots are required each SQL , DML , DDL , and DCL statement for a grade to be given . Note : 1 screenshot is not the idea ; however , multiple screenshots along the way is the goal . Using the link provided in Blackboard , upload your 2 documents for