Tag: SQL

What Concepts and Algorithms does it use? Give an introduction into Cypher and explain the most important cypher commands with examples. Compare qeury times against sql.

Neo4j

The paper needs to give an general introduction into neo4j https://neo4j.com/. When should someone consider using it. What Concepts and Algorithms does it use? Give an introduction into Cypher and explain the most important cypher commands with examples. Compare qeury times against sql.

Ideas for Outline;
1. Neo4j use cases (who uses neo4j, when should someone consider neo4j)
1.1. Neo4j concepts and algorithms (what algorithms does neo4j use,explain each shortly and give examples for their usage)
https://neo4j.com/docs/graph-data-science/current/algorithms/
1.2 Cypher explain neo4js query language in comparison to SQL around
1.3 Compare Neo4j query times vs SQL

Discuss the characteristics of Hierarchical, network and relational database models and present practical applications where each one might be more appropriate to use.

Data Modelling and SQL

Masks / Deliverables of the Assignment 1: Marks are awarded for producing a properly documented system that meets the requirements as specified below:

Task 1: Understanding of database
By relating your discussion to the above scenario where applicable.

1. Discuss the characteristics of Hierarchical, network and relational database models and present practical applications where each one might be more appropriate to use.

2. Compare the SQL databases and NoSQL databases. Your discussion should include the advantages, disadvantages, and limitations of each.
Task 2: Conceptual Modelling [20%]

1. Identity all the possible entities you can find in the problem scenario and list them in alphabetical order.

2. Using Crow’s foot notation, design a conceptual data model for the Jet-Arline database in a modelling tool of your choice. All entity types and the relationships between them must be clearly shown.

Your design should show all cardinality and participation constraints accurately.

Any enhanced features used (e.g. generalization/specialization) must be indicated.

Task 3: Logical Modelling [25%]

1. Discuss the principles of normalization and demonstrate using examples the steps you followed to achieve normal forms in relation to the given scenario.

Your demonstration must show the full process with explanations, starting from UNF, 2NF to 3NF (Note:

There is no requirement here to go through the full list of attributes in the data model for the Jet-Airline).

2 Produce an ERD with all the normalized entities containing the relevant attributes.

State any de-normalization, if any, in all your relations and dearly state the reasons for de-normalizing relations in your implemented solution.

3 Map an ER model devised above into a set of logical relations in the relational data model.