database

Create a conceptual schema for your mini-world using the concepts of the Entity-Relationship model. To simplify the diagram, only show entities, relationships and the primary key attributes. Specify the cardinality ratio and participation constraint of each relationship type. State any assumptions you make when creating the ER model (if necessary). Implement the mini-world schema in Oracle. Implement, where possible, the primary, alternate and foreign keys, and appropriate relational integrity constraints. Populate the tables created with appropriate data (insert data). Create a conceptual schema for your mini-world using the concepts of the Entity-Relationship model. To simplify the diagram, only show entities, relationships and the primary key attributes. Specify the cardinality ratio and participation constraint of each relationship type. State any assumptions you make when creating the ER model (if necessary). Implement the mini-world schema in Oracle. Implement, where possible, the primary, alternate and foreign keys, and appropriate relational integrity constraints. Populate the tables created with appropriate data (insert data)