Different Data Models And Schemas

907 WordsDec 18, 20144 Pages
n of different data models and schemas a) Critically compare the following database types (schemas) Hierarchical Database Kind of database model which is designed in a hierarchy completely access to data beginning at the highest of hierarchical then changes to down such as customer to order. Also this system relation records together same a family tree that each record has just one owner. The hierarchical typical structure has levels which shows one –to – many also relationship between a parent and children divisions. The main key this models which following by each parent can have many children as well each child has simply one parent. This models most common if you compared with network and relational database because can be manage by huge amounts of data for difficult projects. Advantages • Speed very efficiency • Data independence • Database integrity which link between child and parent • Data is simplicity • Very easy to add and delete record • Database pretend a different form environment • Easy to create a large installed Disadvantages • Implement very complex • Implementation limitations • Lack of standards • Program design complexity • Difficult to manage insert, delete and update • Practical access language • Create record must user start at the root • Data redundancy • Create database before the programs must be define Network Database A kind of database organisation system that every record style can have many owner .As well as this model
Open Document