Home / Expert Answers / Computer Science / solve-the-following-two-2-normalization-problems-following-the-process-detailed-in-class-1-be-s-pa336

(Solved): Solve the following two (2) normalization problems following the process detailed in class. 1. Be s ...




Solve the following two (2) normalization problems following the process detailed in class.
1. Be sure to explain each step a
Problems!
1. Design a database to store the marketing information that allows business users to generate the reports related
Solve the following two (2) normalization problems following the process detailed in class. 1. Be sure to explain each step as applied to the problems. 2. State assumptions. 3. Identify the entities, attributes, primary key, foreign keys, functional dependencies, and relationship between tables. 4. Normalize the database design into 3Nr. Problems: 1. Design a database to store the marketing information that allows business users to generate the reports related to Activities, Campaighs, 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 3 NF. 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. 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. Problems! 1. 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 ??ne 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. 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.


We have an Answer from Expert

View Expert Answer

Expert Answer


The two tables that can be written from the given information are Program(id,name,description,created date,who_created,modified_date,who_modified) Cam
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe