Assignment-2 Marks-20 [This assignment will carry the marks of your Lab Performance.] Consider you are a research enthusiastic student. You have done several research works already and you are intended to do more. Therefore, you have decided to design a system to manage your research works efficiently. The system will store necessary information about you, your team mates and your supervisors. Also, it will store necessary details of the reference research papers you have used in your research works. Apart from the above information, you can include additional information and relations in your design if necessary. Considering the above scenario- 1. Design an Entity Relationship Diagram 2. Design the schema for all required tables 3. Provide all tables with sample data (no need to provide large number of rows, minimal should be enough) 4. Provide necessary Primary Key, Foreign Key and other constraints if required. 5. Mention the weak and strong entities in your design, also explain properly why they are weak/strong. 6. BONUS: Normalize your design up to Second Normal Form. This one is optional) Design the above in your own creative way. As this is a creative task, there is no possibility that more than one student submits exactly same design. Therefore, copied assignment will straightly be graded as ZERO. Assignment-2 Marks-20 [This assignment will carry the marks of your Lab Performance.] Consider you are a research enthusiastic student. You have done several research works already and you are intended to do more. Therefore, you have decided to design a system to manage your research works efficiently. The system will store necessary information about you, your team mates and your supervisors. Also, it will store necessary details of the reference research papers you have used in your research works. Apart from the above information, you can include additional information and relations in your design if necessary. Considering the above scenario- 1. Design an Entity Relationship Diagram 2. Design the schema for all required tables 3. Provide all tables with sample data (no need to provide large number of rows, minimal should be enough) 4. Provide necessary Primary Key, Foreign Key and other constraints if required. 5. Mention the weak and strong entities in your design, also explain properly why they are weak/strong. 6. BONUS: Normalize your design up to Second Normal Form. This one is optional) Design the above in your own creative way. As this is a creative task, there is no possibility that more than one student submits exactly same design. Therefore, copied assignment will straightly be graded as ZERO