sql1 homework

1. Anser the questions:
   1. What is Generalization, Specialization and Aggregation?
   2. What is a many-to-many relationship? Give an example?
2. A physician office wants to send reminders (using emails) to their patients. To do this they would like to use a database to keep track of which reminders are sent to which patients. A reminder has a reminder ID (RID), a subject (Subject), and a body (Body). A patient is identified by email address (Email) and patients data includes name and address. When a reminder is sent, the date (SendDate) is recorded.
   1. Give an ER diagram that completely describes the entities and relationships.
   2. Does this problem contain examples of One to One, One to Many, or Many to Many relationships?
   3. Show an example of each type that youve found.
3. Consider the table below and answer the question.

   Lacode	PatientID	LabResult_1	LabResult_2
   123	1	200	210
   123	2	193	65
   203	3	20.5	21
   411	4	1500	1505

This is violation of normal form.

Write the solution for the violation.