Database Design Number

DatabaseDesign

Number:

DatabaseDesign

Definitionof a Database Systems And Its Uses

Theuse of computers has been adopted in almost all the sectors of humanlife. One of the key uses is the management of information this useentails holding data that is retrieved later or when needed. A largeamount of data stored in a computer is referred as a database, andthe software’s that are formed to help in managing this data isdefined as a database management system (bdms).The databasehas become one of the most important structural elements in theever-growing area of the World Wide Web (Adam&amp Bhargava, 1999).

‘Database’forms the basis of the majority of the content-driven applicationsand websites as they serve as a special tool for the development ofmechanisms for data manipulation. In simpler words, a ‘database’can be referred as a controlled compilation of database systems onthe other hand, they are software-applications for computers thathelp the users to interact with the database, in addition to otherapplications such as to fetch and analyze data. It allows computerusers to create and access&nbspdata&nbspina&nbspdatabase(Zaniolo,1997).

Thereare different and varying functionalities of database systems, theprimary functions of a database structure is enabling the developersto create, define, query, update and manage the database. Moreover, adatabase system acts as secondary storage management tools, as wellas offering data protection. Finally, the system offers theenvironment for the interface between human and machine and offeringcompilation and optimization of the database by the user (Date,2012).

Databasearchitecture definition and examples

Databasearchitecture is the development and implementation of softwarespecified to meet up the requirements of consumers, which comes indifferent types. Types of databases that may be created includerelational or multimedia, additionally, database architectures use ofunique language when creating the programs for the databases. Forexample, (SQL) structured-query-language.Examples include programs such as Microsoft Access, Oracle, which aretwo widespread database programs among others. This is structuredescribed by a set of formal language that is equally supported bythe database systems and refers to the organization of data as ablueprint of how a database is constructed. Data architecture isentailed of composed models, policies, standards and rules thatgovern data collection, how it’s stored, arranged as well as howits put into use in data systems as well as in organizations (Singh,2011).

Theissue of architecture in database entails the aspect of designing,development, implementation, as well as the protection of programsfor computers, which organize and store information for laterretrieval for either an organization or institution. Databasearchitectures are usually differentiated through the way applicationlogics are distributed through the system. This contains threecomponents i.e. Presentation Logic (this entails presenting and formatting of thedata on the user’s computer), Processing Logic (this entails theprocessing of data logic), and finally the StorageLogic(this is involved with retrieval and storage of data from the actualstorage devices) (Singh,2011). Some of the major examples include Microsoft®,Microsoft® SQL Server®, and Oracle®.

Inthe recent times there are different and numerous databases used indifferent sectors depending on the functionality intended for theusers and the data involved. For example in the university set up,student and lectures data is stored in within the school computersystems with different platforms created to access the informationwhen required. In the university examples include web based programssuch as Microsoft Access. This allows for students to access examresults as well as allowing the lectures to feed studentsinformation. The Microsoft Access program gives the users theplatform to retrieve, change and use information from theinstitutions main database. This falls under the web-basedarchitecture.

References

Adam,N. R., &amp Bhargava, B. K. (1999).&nbspAdvanceddatabase systems.

Date,C. J. (2012).&nbspDatabasedesign and relational theory: Normals forms and all that jazz.

Sebastopol,Calif: O`Reilly Media.

Singh,S. K. (2011).&nbspDatabasesystems: Concepts, design and applications.Delhi: Dorling

Kindersley(India).

Zaniolo,C. (1997).&nbspAdvanceddatabase systems.San Francisco, Calif: Morgan Kaufmann

Publishers.