Create a relational (logical) schema using the following information. For each a

Question

Create a relational (logical) schema using the following information.

For each ad campaign: a unique AdCampaignID, AdCampaignName, a start date, and a duration of the campaign

For each ad campaign manager: a unique CampaignMgrID and CampaignMgrName

For each ad campaign mode: a unique ModeID, Media, and Range

Each ad campaign is managed by exactly one campaign manager.

Each campaign manager manages at least one ad campaign, but can manage more than one.

Each ad campaign uses at least one campaign mode, but can use more than one.

An ad campaign mode can be used by multiple campaigns, but it does not have to be used by any.

Explanation / Answer

Ad_campaign Camp_id Camp_name start_date Duration 1 soap 1 Jan 12 45 months 2 tissue 4 march 17 34 months Ad_campaign_mode Model_id media range M1 tv 300km M2 radio 200m Ad_campaign_manager Manager_id camp_manager_name Man1 John Man2 Mary Ad_campaign_manager_handle Camp_id (foreign key reference ad_campaign) manager_id(foreign key reference ad_campaign_manager) 1 man1 2 man2 Ad_model_used Camp_id model_id 1 m1 2 m2

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.