2 Simple SQL based tasks - NEED in 48 HRS

Need an Entity Relationship diagram & a Relational Schema for a scenario (will share the full details of the scenario).

For context - The main aim of this project is to develop a broad knowledge of storing and managing data to satisfy the organizational requirements. These will be reinforced by developing the practical skills required for using the structures and features of a query language in order to maintain and interrogate a relational database management system using Oracle SQL.

Task 1 - Entity Relationship Diagram

Create a conceptual data model to represent the data requirements of the BIC scenario (will be sharing full details). Your model should include an E-R diagram and entity headings (listing the attributes associated with entity types). List any assumptions you have made.

Task 2 – Relational Schema

Using your conceptual data model, develop a relational schema consisting of the definitions of the domains and relations that represent the entity and relationship types, including primary keys, foreign keys and any constraints.