Task 1.1 

 Critically compare different data models and schemas

You are required to identify various types of database models such as hierarchical network relational and object-oriented. Use appropriate diagrams to compare and contrast the key features, advantages and disadvantages of each database model.

You are required to use the appropriate diagram to explain the database schema which consists of three layers such as external, conceptual and internal. You are required to explain the functionality of each schema of each level (with the help of examples).

Task 1.2 

Critically discuss the benefit and limitations of the different database

You are required to identify various types of database technologies such as file-based, relational database, multimedia database, object-oriented database, distributed database, data warehousing (data mars and data mining), web-based technology (cloud computing). Discuss benefits and limitations of each technology.

Task 1.3

You are required to identify two approaches such as top-down and bottom-up about designing databases. Under the top-down approach, you are required to discuss ERD modelling process. This should include the notation which you use for ERD modelling, the entities, the relationships, the type of relationships, the attribute of entities need to be illustrated with appropriate images. You are required to explain the role of the top-down approach regarding designing database systems. About bottom-up approach, you are required to illustrate how normalisation process would help to identify normalise tables for the database solution. You are required to use examples when illustrating un-normalised form, first normal form(1NF), second normal-form(2NF) and third normal form(3NF).

Normalisation process (has to be explained)

-Un-normalised form

Under this process, you are required to gather all the data and create one table having all the entities and the attributes and define a primary key for that large table.

-Under this process, you are required to identify all the repeating groups and remove all those repeating groups and create a separate table and rest need to be kept in another table. Make sure you define the primary key and composite key for those tables

 Second normal form(2NF)

Under this form, you are required to remove all the partial dependencies; this means you are required to identify non-key attributes depending on one of the keys of the composite key. When you identify them, separate them in another relational table, and the rest should have remained in another table.

-Third normal form(3NF)

Task 2.3

You are required to use any development platform, to develop user interface design, for the given case study and connect the front end with the back end, with the help of any approach. You are required to provide evidence for your user interface development process.