Key Entities, Primary Keys, and Normalization?

Identify the key entities in the table below.?

Apply normalization rules to optimize the database design to 3NF.?

Define primary keys for each table to ensure data integrity and enforce referential integrity between tables.?

Demonstrate how the use of primary keys can improve the performance of queries.

Key Entities, Primary Keys, and Normalization . Identify the key entities in the table below. . Apply normalization rules to optimize the database design to 3NF. . Define primary keys for each table to ensure data integrity and enforce referential integrity between tables. . Demonstrate how the use of primary keys can improve the performance of queries. StudentID StudentName Gender Address Course Department YearLevel 1 John Doe Male 123 Main St., Apt. 4 BS IT IT 2nd Year Jane Smith Female 456 Oak Ave BS CS IT 3rd Year 3 Alex Johnson Male 789 Elm St. BS IT IT 1st Year 4 Sarah Lee Female 321 Maple Ave. BS CE CE 4th Year Michael Brown Male 654 Pine St. BS EE EE 2nd Year 6 Samantha Williams Female 987 Cedar Blvd. BS ME ME 3rd Year