Data Dictionary Documentation for a database to manage Advertisement Campaign data:

Notes:

AdCampaignRange: $L$ indicates Local; $N$ indicates National

AdMedia: $T$ indicates TV; $R$ indicates Radio; $O$ indicates Online; $P$ indicates Print

Client is a company$/$organization

Write SQL script for SQL Server to perform the following tasks:

Create the CampaignManager, AdCampaignRange, AdMedia, AdMode, AdCampaign, and AdCampaignMix tables.

Create table structures with appropriate data types, column attributes and constraints in the given data dictionary

documentation and establish relationships between tables. As discussed in class, include in your script appropriate

conditional drop table statements at the beginning of the script.

In the AdCampaignRange table, check to ensure RangeID $\text{'}L\text{'}$ has RangeType 'Local' and RangeID $\text{'}N\text{'}$ has

RangeType 'National'. Similarly, in the AdMedia table, check to ensure MediaID $\text{'}$T$\text{'}$ has Media $\text{'}$TV$\text{'},$ MedialD

$\text{'}R\text{'}$ has Media 'Radio', MediaID $\text{'}O\text{'}$ has Media 'Online' and MediaID $\text{'}P\text{'}$ has Media 'Print'.

Load one row of data in each of the tables created. You make up values for the data rows added to tables.

Create nonclustered index for each of the foreign key columns in the AdMode table.