In this report, I will be examining the potential constraints on a logical data model and I will also be explaining how the potential constraints will affect the database model.
With each field that’s in the database will have a data domain because a data domain rises to the data type that a field may occur in a database which puts in a field to ensure that when viewing a table it will be much easier to pick up by the database, with the correct detail. Also, if the data domain is inputted incorrectly, then the entire data will be incorrect and will not be usable for the domain. This meaning that the data will be all over the places. However if the data domain is correct, then the information will be accurate and the data will flow through the table.
Entity is about something that exists in the database. Most often entity constraints will ensure that all the small mistakes do not ascend in the database and that all the correct data is inputted into the database accordingly. For example, within many of the fields is a primary key that has been included in the table, then it will not work correctly and all the data that in the table, the user will not be able be read or understanding the data.
The referential constraints is the rule in which the standards of a foreign key is only valid if it appears as standards of a parent key or if some of the components of the foreign key is valueless. It also something that is the state of a database, meaning that all the standards and the foreign keys are valid which foreign key is a set of columns in a database table where the standards are required to have a match of at least a primary key of the standards of the parent table.
User requirement is totally needed when you are creating any kind of projects you’re planning, particularly involves computer system project which is where most of the fail projects are held in. When a database is created with the wrong user requirement, it will affect the entire database even where the correct information that has been inputted, which will also be hard to find any information and in the wrong position or in the wrong order.
Operational constraints refers to hardware and software that can be used by any other organisation in which it must be taken into account and consideration. Meaning, a platform constraints will refer to the platform that will take into getting the finest out of the organisations business to the highest standards as possible which as for the hardware and the software, the organisation needs to make sure that the operational of both the hardware and software are in the right resources.
With having organisational conventions, these restrictions will mean that the designer of the convention will have to think carefully about how he/she could implement the techniques to stop this from happening. The designer should also confirm that he/she has a plan for any restriction that might be avoided and made into a real life scenario to have a backup plan of how to divert the restriction back to the unique place.
Any performance that is in a database is restricted by the hardware that is used by the organisation. If a user is to say that the hardware is out-dated, then the designer of the database will may have to make sure that the database is simple and it be wouldn’t hard to understand for the user. Which also includes that the features that the designer is going to make the database much easier to understand.
User constraints is the definitions of a table that is owned by a current user which all the columns that are on the table will make sure that they are the same. If the user is experienced in making top range databases, then be able to do more than average or medium so that a user who are having trouble with the higher work that the more experienced user will be doing. Having a good IT skills are relevant for any IT related work, whether the skills are for beginners or for the most experienced user. The user will also have to make sure that he/she knows the basics of knowledge of IT. Also users who have a medium skill may be able to know the knowledge that most experienced users knows as the medium user is going towards.
When creating the database, it is essential that the database have all the information’s that the user has to make a database possible even without it, it will be quite difficult for the user to create a database. If the user was wasting too much time on a database, he/she have to make sure that it is not taking too long to finish off and if the database is taking a very little amount of time to complete. The user should also make sure that a database has extra time, as it will have to include all the basics of database with all the relevant information of making the database.
If the organisation wants to make a simple database, then it will cost a little amount of money because it has not been used for many features that was needed to make the database. Although, if the database was to be created with top range database, then it costing an extra cash. Meaning, an expensive database will have all the resources that are available for the database which is by creating a database to make sure that the organisation has enough money to give at the end of the database creation for the designer.
My conclusion about this task is that, I have examined the potential constraints on a logical data model and I have also explained how the potential constraints will affect the database model.
Information Technology Level 3 BTEC National Book