Design a database to store the marketing information that allows business users to generate the reports related to Activities, Campaigns, Programs and Cost for marketing purpose. For example, this database should provide the proper data if the business wants to find out the cost of each activity, list the activities for each campaign and Programs, etc.
Design a
Here are the relationships between Activities, Campaigns, Programs, and Invoices:
a.A Program may be related to one or multiple Campaigns.
b. A Campaign may be related to one or more Programs.
c.An Activity only belongs to one Campaign.
d. One campaign can include many activities.
e. An Invoice includes the cost for one activity. Each activity has its own invoice.
Step by step
Solved in 2 steps with 1 images
