Database Management System

A database management system and its importance

A database management system has many importance and aids in the implementation functions in an organization by maintaining files of data securely ensuing integrity of the data. This paper is going to look at the attributes and entities of a database, physical and conceptual models while explaining the advantages of having a DBMS.

Databases play a vital role in organizations

Databases play many roles in organizations. According to Atkinson et al., (2017) cataloging files in a database management system (DBMS) is crucial and can range from computer codes to query programs that help in the extraction of information to the system utility while recording the maintenance programs. The file structure in a DBMS gives an orderly way for file accessing and management (Atkinson et al., 2017). DBMS help in the identification of database types since it contains a record of the structure and information using indexing, allows for accessing of data types by using partitioning, and catalogues (Atkinson et al., 2017). Atkinson et al., (2017), database ensures security of the information system by having security tables designated for the user information, password and identification and ensures integrity of the different data sets. Database also has tables and records, within the DBMS the databases get assigned records that can be classified as an item or detailed record while a table is a structure where item and the detailed records are stored (Atkinson et al., 2017).

Entities and attributes in databases

Databases have entities and attributes. A database entity can be explained as the primary element in databases that are relational, CentriQS configurator allows one to create a single entity that is customized for certain organizational needs or many custom entities that are related to each other (Atkinson et al., 2017). Database entity can be a unit, a place, person, a thing or any item that can allow for data to be captured and later on stored and can take the form of tables, properties or workflow (Atkinson et al., 2017). Entity property refers to the attributes of the entity; it is hard to figure out if a database item is an entity or property and one must ask themselves if the item is the major interest of the database (Atkinson et al., 2017). Few properties of the entity can be a representation of the database entity dependency or relationship; settings of the entity refer to system attributes of an entity (Atkinson et al., 2017)

Conceptual and physical models of databases

Databases have conceptual and physical model and both contain different information. Atkinson et al., (2017), claims that data models shows how the data must be utilized to meet end-user requirement. Conceptual model has a high level relationship of entities while the physical model has the representation of an application and the implementation of the specific database logical model of the data (Atkinson et al., 2017). According to Atkinson et al., (2017) conceptual model contains ten to twenty entities together with group entities while the physical model has the representation of the data design and shows facilities and constraints that face a given DBMS since it represents how the database will be built from the model. The physical model shows the structures of the table such as column name, primary key, and column constraints amongst others (Atkinson et al., 2017). According to Atkinson et al., (2017), conceptual model contains relationship between the different entities and may include cardinality or null ability; it does not have any limited count for the attributes and may include enterprise coverage of the concepts in business like store and products among others. Physical model contains 10 to 1000 tables, and may be embedded together with other physical data types. It has columns with datatypes and the optionality while the tables and columns will have definitions (Atkinson et al., 2017).

Datatypes and entities in organizations

Datatypes are crucial in organizations since they serve many purposes, and have entities that have attributes. DBMS ensure that it is easy to identify data types, aids in cataloging files and ensuring integrity is upheld. DBMS have physical and conceptual model that contain different information.

Reference

Atkinson, M., Dewitt, D., Maier, D., Bancilhon, F., Dittrich, K., & Zdonik, S. (2017). The Object-Oriented Database System Manifesto. In W. Kim, J.-M. Nicolas, & S. Nishio (Eds.), Deductive And Object-Oriented Databases (Pp. 223–240).