ipl-logo

Advantages And Disadvantages Of Database Model

1387 Words6 Pages

Chapter 3 Database Model
3.1 LEARNING OBJECTIVE AND OUTCOMES

How to organize database model which is required in an application as relations
The need of database model is to normalizing relations.
The various normal forms are use in the database model.
How to normalize the different relations model to next higher normal forms to provide a relational database.

3.2 INTRODUCTION
A database model is a type of data model that describes the structure of a database and can be described as a collection of various means by which data can be stored, organized, and manipulated. here are some data models described
1. Hierarchical Model
2. Network data model
3. Relationship data model
4. Entity relationship model
5. Object based data model
3.3 COMPARISON …show more content…

Disadvantages
This data base lacks flexibility, the changes in the new relation or segments often yield very complex system management tasks.
Many of the common relationships do not conform to the one to many relationship forma t required by this model

2) Network model
Advantages- the data access and flexibility is superior to that found in hierarchical model
It provides sufficient data independence by atleast partially isolating the programs from complex physical storage details
Disadvantages- this model is not user friendly and is a highly skill oriented system
3) Relationship model
Advantages- a relationship model is even simpler than hierarchical and network model
This model does not depend on the navigational data access system so changes in the database structure do not affect the data access
Disadvantages
This model needs more powerful computing hardware and data storage devices to perform tasks.

HIERARCHICAL , NETWORK AND RELATIONAL MODELS

Hierarchical model

This model provides two main data concepts.
• Records: It is a collection of field values that provide information on an …show more content…

Codd in 1970, to make database management systems more independent in a particular application. It is mathematical models that are defined in terms of predicate logic and set theory .
The three key are used extensively in relational database models:1) relations 2) attributes, 3) domains. A relation is a table with columns and rows. The named columns values of the relation are called attributes, and the domain is the set of values the attributes are allowed to take.
The basic data structure of the relational model is the table, where information about a particular entity (say, an employee) is represented in rows (also called tuples) and columns. Thus, the "relation" in "relational database" refers to the various tables in the database; a relation is a set of tuples. The columns enumerate the various attributes of the entity (the employee 's name, address or phone number, for example), and a row is an actual instance of the entity (a specific employee) that is represented by the relation. As a result, each tuple of the employee table represents various attributes of a single

Show More
Related

  • Nt1330 Unit 9 Final Paper

    865 Words  | 4 Pages

    In this phase it will articulate what the system is supposed to do, it will carefully . In other words, analysis will articulate what the system is supposed to do. For the central ordering system, the analysis would carefully examine existing ordering systems and how to utilize the best aspects of those systems, while taking advantage of the potential benefits of more centralized

    Read More

  • Nt1310 Unit 3 Assignment 1

    922 Words  | 4 Pages

    4.4.2. Attack group knowledge A biggest thing is that to provide attackers to information about system. Which means to gain information about system?

    Read More

  • Nt1310 Unit 3 Sharing Internet

    105 Words  | 1 Pages

    Sharing Internet Access: within a computer network learners are able to access the internet at once. Speed: Using a network is a faster way for sharing and transferring files. Without a network, files are shared by replicating them to a floppy disk. Cost: Networkable versions of many popular software programmes are available at significant savings compared to buying individual licensed copies. It also allows easier upgrading of the program.

    Read More

  • Pros And Cons Dbq

    506 Words  | 3 Pages

    The ERA failed from a number of different reasons. Those fighting for the ERA partially took the wrong approach. Many tactics hurt the campaign rather than helping it. The ERA did not get many of the supporters needed to pass the Amendment. A vast majority of women enjoyed their roles as housewife and mother.

    Read More

  • Nt1330 Unit 7

    664 Words  | 3 Pages

    1. Viruses Can destroy all of the data and erase all of the file or misused by the attacker. Have the anti-virus downloaded in your computer and make sure your computer is completely updated. 2. Phishing Attacker will be able to get the private information of the person and will gain access on computer Be able to recognize the fake emails from the attacker and avoid opening them up.

    Read More

  • Pt1420 Unit 2 Assignment 2

    102 Words  | 1 Pages

    ASSIGNMENT 02 Key: A key is an attribute or set of attribute in a relation that identifies a tuple in a relation. Followings are the keys used in Data Base Management System. 1) Super Key: A set of attributes of relations for which it holds in all relation there are no two rows that have same values for attributes.

    Read More

  • Nt1330 Unit 2.7 Observation Paper

    500 Words  | 2 Pages

    Therefore, the database can be any type such as SQL, Not Only SQL (NOSQL), or other. Observation_4: The CSP needs to apply a virtualization technology on storage resources to serve CSUs’ demands efficiently. Therefore, a

    Read More

  • Advantages And Disadvantages Of Rnr Model

    731 Words  | 3 Pages

    A therapist ONLY addressing an offender 's mental illness may be problematic because offenders have criminogenic needs that need to be treated in order to reduce criminal behavior. The Risk-Needs-Responsivity (RNR) model of corrections and rehabilitation was designed by Andrews, Honta, and Hoge in 1990. This model has demonstrated the strongest research-support on its ability to explain and treat criminal behavior. Andrews and Bonta have shown that in order to produce a successful rehabilitation program, the program must "respect the individual, have a psychological theory basis, and should work in junction with the enhancement of preventative services". This model reveals the importance of going beyond ONLY addressing an offender 's mental illness and providing treatment relevant to

    Read More

  • Google Organizational Structure Analysis

    1852 Words  | 8 Pages

    1. Introduction to Organisational Structures The Organizational Structure within a company determines the way in which an organization’s operational activities are performed. Some of the main operations defined within an organizational structure include the allocation, supervision, and coordination of how a project is to be completed. The organizational structure will determine how tasks are performed during a project and who the tasks are to be performed by. The organizational structure also states who will manage or oversee the project and the processes or protocols that will be implemented during the time frame of that particular project.

    Read More

  • Lululemon: Management Information System

    764 Words  | 4 Pages

    ADMS 2511. Management Information System Section Q Raqib Ibrahim Prof. M.Zia ul Haq 215251754 Case Assignment 1 Question A i) Data items: Example of Data in Lululemon case is sales over $1 billion. Data item is a set of description which gives information but does not convey a meaning. ii) Information: As stated above the sales resulted in over $1 billion but actually the 10 percent of those sales were from the Internet store.

    Read More

  • Nt1310 Unit 3 Data Analysis

    1576 Words  | 7 Pages

    1. Define the following terms: GIS; A geographic information system is system made to capture, store, manipulate, analyse, manage, and present spatial or geographical data. FOSS; Free or Open Source Software. FOSS programs have licenses that allow users to freely run the program for any purpose, modify the program as they want, and also to freely distribute copies of either the original version or their own modified version. ILWIS; Integrated Land and Water Information System is a GIS / Remote sensing software for both vector and raster processing.

    Read More

  • 8 Principles Of Max Weber's Bureaucratic Management Theory

    1901 Words  | 8 Pages

    In organization, there should be established system to achieve the task and there should be relationship between system and task of the organization (McNamra,

    Read More

  • Ritz Carlton Organizational Structure

    2427 Words  | 10 Pages

    The different type of structures (1) Functional – each portion of the organisation is grouped according to its purpose. (2) Matrix - ‘’ creates project teams that cut across traditional functional departments, instead of highlighting the role or status of individuals, it gathers together a team of specialists with the objective of completing a task or a project successfully ‘’ . (3) Divisional – It is the grouping of workers on the basis of products being produced, followed by the functional structure. There are two types of divisional structure , (a) Product structure (b) Process structure (4) Geographical – It is the grouping of workers on the basis of regions, followed by the functional structure and , (5) Hierarchical structure which has been adopted by Ritz Carlton. It shows the different levels of hierarchy, span of control and chain of command.

    Read More

  • Organizational Structure Of Toyota

    2493 Words  | 10 Pages

    It acts as an operating manual that defines the way the jobs are distributed and how individuals interact within the company to achieve their goals (Distelzweig, 2004). A detailed study on organizational structure relates organizational structure to the way information flows through the hierarchical arrangement. There are basically two types of organizational structure; centralized and decentralized. In a centralized system the highest layer of hierarchy is responsible for decision making and controlling departments and division.

    Read More

  • Advantages And Disadvantages Of Relational Database Management System

    1110 Words  | 5 Pages

    Relational Database Management System: This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.

    Read More

More about Advantages And Disadvantages Of Database Model

Open Document