Now we will try creating some ER diagrams of our own. Create an entity-relationship diagram to depict the database required for each application scenario. There are three separate applications to practice creating ER diagrams and answering questions about database design concepts. An ER diagram is used to create a database for an application, so each entity on the ER diagram would be translated into one table in Microsoft Access. One of the main goals of database design is to reduce data redundancy. Application 1 This database will be used by a college. A student can take many courses and a course may have many students enrolled. We want to store the date (semester and year) that a student takes a course as well as the grade earned by the student. A sample list of the data we want to store for this application is provided below to help you understand the application. Now we will try creating some ER diagrams of our own. Create an entity-relationship diagram to depict the database required for each application scenario. There are three separate applications to practice creating ER diagrams and answering questions about database design concepts. An ER diagram is used to create a database for an application, so each entity on the ER diagram would be translated into one table in Microsoft Access. One of the main goals of database design is to reduce data redundancy. Application 1 This database will be used by a college. A student can take many courses and a course may have many students enrolled. We want to store the date (semester and year) that a student takes a course as well as the grade earned by the student. A sample list of the data we want to store for this application is provided below to help you understand the application