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 ( 20o/o]
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-Airline 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, 1NF, 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 clearly state the reasons for de-normalizing relations in your implemented solution.”
3. Map an ER modeldevised above into a set of logical relations in the relational data
model.
