Question: 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
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 and list the activities of each Campaign, etc. Normalize the database design into 3NF.
Here are the relationships between Activities, Campaigns, Programs, and Invoices:
a. A Program may be related to one or multiple Campaigns. b. A Program should include the program id, name, description, created date, who created, modified date and who modified the record of the program. c. A Campaign may be related to one or more Programs.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
