Answer to Question #50987 in Databases | SQL | Oracle | MS Access for piyush

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]