Question: Problem Description-to-ER Diagrams TO Relational Model Design a database for each of the following problems. Draw a neat Entity-Relationship Diagram for each problem. USE M

Problem Description-to-ER Diagrams TO Relational Model Design a database for each of the following problems. Draw a neat Entity-Relationship Diagram for each problem. USE M N notation. DO NOT Use crows-feet notation. Translate the diagram into a relational model. It is enough to show the table design like this: TABLE NAME(ColumnNamei Underline the Primary Key Specify all the Foreign keys like this: ColName FOREIGN KEY REFERENCES ANOTHER_TABLE (Qtherco1Name) , ColumnName2, ...) An Internet store sends emails to customers and would like to use a database to keep track of which messages are sent to which customers. A message has a message id (mld), a subject, and a body. A customer is identified by the email address (email), and customer's data includes the attributes name, sex, householdSize, and address. When an email is sent, the date (sendDate) is recorded. You can assume any reasonable domains (types) for these attributes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
