Tasks
Understanding of database “Have you compared the SQL databases and NoSQL databases, advantages, disadvantages, and limitations of each?
Have you discussed characteristics of Hierarchical, network and relational database models and present practical applications where each one might be more appropriate to use” 20
Conceptual Modelling “Have you identified all the possible entities you can 1nd in the problem scenario and list them in alphabetical order?
Have you used Crow’s foot notation for conceptual data model for the Jet-Airline database in a modelling ool of your choice?
Have you showed cardinality and participation constraints accurately?” 20
Logical Modelling “Have you discussed the principles of normalization and demonstrate by examples the steps you followed?
Have you produced an ERD with allthe normalized entities containing the relevant attributes?
Have you stated any de-normalization?
Have you mapped an ER model devised above into a set of logical relations in the relational data model?” 25
Physical Modelling “Have you produced a script using appropriate SQL command (DDL) and all constraints to create a set of database table using MySQL relational database?
Have you used appropriate SQL statements to populate all th• ables in the database you created with some data?” 30
Referencing and Bibliography Have you correctly cited your work using the Harvard references style? 5
Total 100
6
