Data Modelling and SQL
Should tobacco companies be held responsible for smoking-related illnesses and deaths? 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 1: 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 2: Conceptual 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.
