Assignment title: Management


1.1 There are different types of data model and schema in data analysis and design; identify the data model and schema and critically analysis them? Note: Hierarchical, Network and Relational Model, Schema (Conceptual and Physical Schema). 1.2 Identify the different types of database/database management system technologies and critically discuss them with benefits and limitations. Note: DDL, DBMS, RDBMS, data redundancy, data independence, data integrity, normalization, storage etc.1.3 Various database design approaches are applying in the database design and development process. Investigate the database design approaches, features and describe them appropriately with a suitable example. Note: Top down, bottom up, tools and techniques eg. ERD, DFD, attributes and key identifiers, relationship types, enterprises rules, example new development e.g. data mining, data warehouse, web enabled database etc. 1.4 Extend your answer 1.2, identify the problems of the traditional file based system and illustrate clearly how a relational database system to solve the problem of traditional file based system with valid example and suitable diagram