Preview

Potential constraints on my logical data model

Satisfactory Essays
Open Document
Open Document
373 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Potential constraints on my logical data model
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

  • Better Essays

    Databases are made to be used to add and review data, quickly and effectively. "You can enhance…

    • 2384 Words
    • 10 Pages
    Better Essays
  • Satisfactory Essays

    I think this relates to database development in a number of ways. One is how it starts, gathering information and finding the intent of the system. Next you must plan out how to set up the database, which is the vital information? What are the minor details? Then you set up your database fill in some test information insure it works properly and make needed adjustments. Finally you implement your database design where in it works properly you merely maintain and fix any errors.…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    When the conversations are taking place, it is very important for the designed to obtain and identify the problems by collecting as much information as possible from the hierarchy and the end users. Without this information, it will be very difficult for the designer to complete this project. It is only natural for the designer and hierarchy to have different views on what they may feel are the problems, however they must come to some agreement and ultimately it is the database designer job to get the responses he/she will need to determine why the database system is not functioning properly. Listed below are some of the problems and constraints that could be possible while trying to plan and complete this…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is gathered, I will divide this information into tables. Information will be properly placed into columns and I will set a primary key. Upon completion of table design, I will set the relationships between tables. I will refine my design and apply normalization rules to my design.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    New database must be designed to store work records. Integrate and redesign current client data to the new database. After the new system is implemented, clients will be able to submit service requests, consultants can have access to all client information and remotely access client information.…

    • 782 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    employees who will use the new database some extensive seminars, or other form of training to ensure that users have the knowledge on how the system will work. This will decrease redundancy and decrease data entry errors. I look forward to hearing from you regarding your thoughts, and concerns, with the database.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    A database language must enable the user to perform complex queries designed to transform the raw data into useful information.…

    • 1917 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Is3110 Chapter 1

    • 789 Words
    • 4 Pages

    | 2. The determination of database requirements is part of a process known as systems development.…

    • 789 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    week 4 Discussion 1

    • 447 Words
    • 2 Pages

    Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 1 BIS221

    • 536 Words
    • 3 Pages

    Databases allows companies to organize all their information on one place, making it easy for people to access and share information.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Logical Design Pt. 2

    • 641 Words
    • 3 Pages

    Hello sirs, my name is , it has come to my attention that there are some misconceptions about the value in normalizing your database. I wanted to write this correspondence to address any concerns that you may have about flexibility while entering your data into the system. This letter is to assure you and the other members of your executive board that you will have some flexibility within your E-R Model.…

    • 641 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input (tech-faq.com)”. To ensure practical use over a long period of, databases ought to be built with high-level of data integrity and the capability to recover data in the event of hardware failure. Data that has been destroyed or corrupted is useless within a business’s data system structure.…

    • 624 Words
    • 3 Pages
    Satisfactory Essays