Question

database should have at least 3 entities. You should have at least two attributes in each entity. If possible, I would like you to normalize it to be 3NF. But as the textbook says, depending on the database, not always is a higher normalization better. So, with that said, at least normalize your database to be 2NF. In my database, 3NF normalization works best. You are free to select any type of database information system; e.g., CD, DVD or Book collections, recipes, sports teams, small business, community organizations, hobbies, inventory lists, etc.

Answer 1

To make 2NF . we have to remove partial dependency that means assume XY is a candidate key . X and Y are prime attribute . if any dependency prime attribute to ->non prime attribute . than we have to remove it

To make 3NF . assume that functional dependency X->Y . if X is a super key or y is a prime attribute . in other word we have to remove transitive dependency of non prime attribute ->non prime attribute.

un-normalized Pelation Remove multi value Attriberte 1. N.F (atomic values) Remove partial functional dependency. (partial key monkey) 2NF (allows only FFD) Remove transitive dependency . [mon key non key] 3 N.F If make every X B. CONOF function depency [x is supering N Y