You are a teacher who needs to keep track of about $150$ students for their attendance and grades. Each time you give a test, you record every student's grade. You find that using the scores later for the assessment purpose is a tedious task and takes a lot of time.

Propose a database solution for maintaining each student's attendance and grades. Discuss all of the pertinent factors to be considered while deciding the primary key from the database design. Provide as many database design examples as possible and justification for each example to support your response. Include the ramifications of replication in your discussion