Answer to Question #52516 in Databases | SQL | Oracle | MS Access for pankaj debnath

Question

After identifying the entities, attributes, and relationships among the entities of the application, you need to start with the design of the database. For this, you need to perform the following tasks:
1. Draw an E/R diagram to demonstrate the relationships between the various entities of the application. [8 Marks] 2. Map the E/R diagram to tables that you need create in order to accomplish the requirements of the application. [3 Marks] 3. Identify the attributes that can be used as primary keys for the corresponding tables in the relational database design. [2 Marks] 4. Identify the various schemas that need to be created while designing the database. [2 Marks]