- Published: October 11, 2022
- Updated: October 11, 2022
- University / College: The Australian National University
- Language: English
- Downloads: 30
Database design is simply defined as the production of database that is thorough. It requires an understanding of both the business functions you want to use and the ideas along with features used in that particular business function. This paper discusses data types for completing a database design in which various languages may be used.
There are different data types. According to Gordon (1991), when designing a database there is a need to think of a field data type as a set of qualities that apply to all the values that are contained in the field and that determines what kind of data the values can be. An example is text fields where values stored can only contain numbers, letters, or even punctuation characters (Gordon 1991). There are also data types that begin with “ n” prefix, where it stands for National language character set. Ayewah (2008) states that by using this there is the passing of an nchar, ntext or nvarchar value contrasting to char, text or varchar. Unicode is used in database applications that are designed to ease code pages that go past Western Europe. Unicode is designed to make extended characters that are set to simply get into the columns of a database (Ayewah, 2008).
Hubel and Wiesel (2009) say that one can adjust the space each record uses in a table through changing the field size property. They add that the size of a field can be changed for storing text data though it has smaller effects on the amount of space to be used. A major problem in Unicode data is that since the requirement is a 16-bit character, a lot of the same ANSI coding assumptions that will break on DBCS will also do the same on Unicode because Unicode enabling isn’t an automatic process (Churcher, 2012). Therefore, through this research it necessary that one should know the data type to use to come up with a good database design.
References
Ayewah, N., Hovemeyer, D., Morgenthaler, J. D., Penix, J., & Pugh, W. (2008). Using static analysis to find bugs. Software, IEEE, 25(5), 22-29.
Churcher, C. (2012). Beginning database design: From novice to professional. Apress.
Hubel, D. H., & Wiesel, T. N. (2009). Uniformity of monkey striate cortex: a parallel relationship between field size, scatter, and magnification factor. Journal of Comparative Neurology, 158 (3), 295-305.
.