Potential constraints on my logical data model

Satisfactory Essays
Potential constraints on my logical data model
Budget
The budget can really alter the way the database ends up like, if the budget is really low then the database will not turn as good as if more money were spent on it. This can really change the database greatly and a knowledgeable amount of money needs to be put into any database for it to return satisfaction.
Timescale
If the client sets a time that the database needs to be finished by then the database may or may not need to be created fast and efficiently, this can also effect the database greatly as if there is only a little amount of time spent on it, it won’t be as great as one that would have more time spent on it.
Client
The database needs to be created to exactly as the client requests and as he needs it as this is one of the most important factors of building any database: to make it to the user’s requirements.
Client knowledge and skill
The database needs to be adjusted so that the client can adapt to it and use it correctly, for this to happen the database needs to be designed around the client’s knowledge and skill
Hardware and software
Knowing the hardware and software that the client will be using is very crucial in designing any database as if there computer is slower, the database will need to be adjusted to the computers requirements. Building the database to meet the requirements of the client's computer is very crucial for efficiency.
My knowledge and skill
The database can only be built using my best knowledge and skill; I cannot create anything beyond my own skills.
Validation rules
Validation rules are very important for databases, they provide error reports for the user, an example would be a telephone number being only 11 characters.
Combo boxes
Combo boxes allow the feature of a tick box in the database; this greatly improves efficiency when filling in forms and the like.
Relationship integrity
Enforcing relationship integrity is vital because it restricts your

You May Also Find These Documents Helpful

  • Powerful Essays

    The Physical Data Model (PDM) describes how the information represented in the Logical Data Model is actually implemented, how the information-exchange requirements are implemented, and how the data entities and their relationships are maintained. There should be a mapping from a given Logical Data Model to the Physical Data Model if both models are used. The form of the Physical Data Model can vary greatly, as shown in Figure 31. For some purposes, an additional entity-relationship style diagram…

    • 4439 Words
    • 18 Pages
    Powerful Essays
  • Satisfactory Essays

    Transforming Logical Data Models into Physical Data Models Susan Dash Ralph Reilly IT610-1404A-01 According to an article written by Tom Haughey the process for transforming a logical data model into a physical data model is: The business authorization to proceed is received. Business requirements are gathered and represented in a logical data model which will completely represent the business data requirements and will be non-redundant. The logical model is then transformed into a first cut physical…

    • 444 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Logical Data Modelling

    • 912 Words
    • 11 Pages

    Last Class: RPCs and RMI • Case Study: Sun RPC • Lightweight RPCs • Remote Method Invocation (RMI) – Design issues Computer Science CS677: Distributed OS Lecture 1, page 1 Today: Communication Issues • Message-oriented communication – Persistence and synchronicity • Stream-oriented communication Computer Science CS677: Distributed OS Lecture 1, page 2 Persistence and Synchronicity in Communication • General organization of a communication system in which hosts…

    • 912 Words
    • 11 Pages
    Powerful Essays
  • Best Essays

    Data warehousing logical design Mirjana Mazuran mazuran@elet.polimi.it December 15, 2009 1/18 Outline Data Warehouse logical design ROLAP model star schema snowflake schema Exercise 1: wine company Exercise 2: real estate agency 2/18 Introduction Logical design Starting from the conceptual design it is necessary to determin the logical schema of data We use ROLAP (Relational On-Line Analytical Processing) model to represent multidimensional data ROLAP uses the relational…

    • 1398 Words
    • 6 Pages
    Best Essays
  • Powerful Essays

    Bibliography: • African Studies and Rural Development; Shinichi Takeuchi • Codrin Paveliuc; The Effects of Rural Development Policies, www.academia.edu • Dimensions of Agricultural Extensions; What is Rural Development, www.agriinfo.com • Jean Marara; Constraints and Handicaps of Rural Development in Rwanda • Michael Holton; 10 Reasons Why Rural Community is Hard to Do, www.beefmagazine.com • Solomon Lipman; What is Economic Development, www.svbic.com…

    • 1901 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Data Models

    • 521 Words
    • 3 Pages

    Data Models Consider a simple student registration. Specifically we want to support the tasks of students registering for or withdrawing from a class. To do this, the system will need to record data about what entities? What specific data about the entities will need to be stored? What is the cardinality between students and courses? Diagram the data model. While, considering a student class registration system for registering or withdrawing a system must have the capability to record data in…

    • 521 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Evolution of Data Models

    • 1131 Words
    • 5 Pages

    The Evolution of Data Models The quest for better data management has led to different models that attempt to resolve the file system’s critical shortcomings. Because each data model evolved from its predecessors, it is essential to examine the major data models in roughly chronological order. 1.1 The Hierarchical Model A Hierarchical Database Model is a data model in which the data is organized into a tree-like structure. The structure allows representing information using parent/child relationships:…

    • 1131 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Abstract The objective of the study is to identify the constraints, potentials and recommending solutions as regards agribusiness development in Bangladesh. The methodology of the study included survey, PRA, RRA and FGD with different sector peoples comprising farmers, agribusiness-man, policy makers and specialists. The study covered 22 districts of 6 Divisions covering in all a randomly selected population. The existing situation of the as documented through Agricultural and Agribusiness Project…

    • 9879 Words
    • 40 Pages
    Powerful Essays
  • Good Essays

    Enterprise Data Model

    • 5539 Words
    • 23 Pages

    The Enterprise Data Model Introduction An Enterprise Data Model is an integrated view of the data produced and consumed across an entire organization. It incorporates an appropriate industry perspective. An Enterprise Data Model (EDM) represents a single integrated definition of data, unbiased of any system or application. It is independent of "how" the data is physically sourced, stored, processed or accessed. The model unites, formalizes and represents the things important to an organization…

    • 5539 Words
    • 23 Pages
    Good Essays
  • Best Essays

    Areas of conflict between the Contract Administrator and the Client 2 4.0 Difference in the relationship of the CA with the client and the contractor 5 5.0 Request for variation orders 6 6.0 The likely effects of the increase in the pit size 6 7.0 Data Warehouse Modelling 6 8.0 References 6 1.0 Professional Practice RICS practice standards 2011 recommends to “avoid personal appointments” (contract administration. 2011) by referring to the CA as a professional practice. For this reason the…

    • 2191 Words
    • 9 Pages
    Best Essays