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:
d. A Campaign should include the campaign id, name, description, related program, created date, who created, modified date and who modified the record of the campaign. e. One Campaign may include many activities, and one activity can only be part of one Campaign. f. The expense of each activity is recorded in invoices, and each activity may receive more than one invoices.
Note: The attributes of the Campaign and Program are listed above. You need to come up with the meaningful attributes for the entities besides those two.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started