Homework answers / question archive / Choose one of the above use case scenarios and: 1) Develop an Entity-Relationship model of the information requirements for the select scenario

Choose one of the above use case scenarios and: 1) Develop an Entity-Relationship model of the information requirements for the select scenario

Computer Science

Share With

Choose one of the above use case scenarios and:

1) Develop an Entity-Relationship model of the information requirements for the select scenario.

2. Translate your model into an equivalent relational schema. Specify all relation headings indicating primary and foreign keys.

3. Implement at least three important entities from your relational schema in SQL, MongoDE and Neo4J (could be different three entities for each technology) and generate sample data for all of the implementations. Show samples of generated data.

4. Explain why you chose the particular entities to implement with each technology.

5. Come up with 5 test cases for each database technology and implement those using queries. Show the queries code and the output for each database technology.

Include the answers to each of the five points above in your technical report.