computers-achievers

What is DBA in DBMS [Database Management System]? DBA stands for Database Administrator. It manages the logical level of the database design. It manages the physical level of the database design. It controls the logical implementation of the database design. It controls the physical implementation of the database design. It can also controls whole the database structure and sets up the setup of the database system. Database administrator is also known as supervision of the database management system who have knowledge about all the necessary logical and physical level and their implement of their requests in the database management system. It manages the schema definition in the database. It can control routine maintenance of the DBMS. How to the database administrator (DBA) manage the logical level in DBMS? The Database administrator manages the logical views. The DBA consider the problem if there is facing a problem of data value in an attribute of the record. They detect the e...

What is database design in DBMS [Database Management System]? Database Design and their introduction about “What is the database design in the DBMS? The database design is the related to the Logical and physical design of the database. It very the data stored in a database by the logically and physically in the database. The database design is responsible for to provide the requirement of information from the database. This required information from the database is to uses with different of different applications. The first and the basic step of the database design are to make collection and analysis of the data from the database. How to developer collect the detailed requirement improvement their database design? The design of database is very important part of the database. Some database application wants to update with new features for users. So the developers create an interface for user to gives their feedback on their application. Some developers create a survey for their app...

What is “Mapping” in the DBMS? Mapping in DBMS {Database Management System} The mapping is a link or connect and equality to describe between view level, conceptual level and internal level. It used to describe how they are connecting to each other in three levels. It is a process to convert a request of external level which is request both the two level such as logical level and physical level. Simply it is a map of Database structure which shows the links of the three levels basically. There are two types of mapping in DBMS. External conceptual mapping Internal conceptual mapping In the DBMS each users refers only its own external schema. Hence the DBMS must transform a request on a particular or specified external into the request against to the conceptual schema which means logical level of schema in the logical refers where the logical term has perform in the database and then into the request against internal schema which means the internal is schema in the physical...

What do you mean by "Schema" in Database management system? What is schema? The schema is basically the structure of the database to show in a logical and physical type of database structure in database management system. The schema is necessary to use in the database technology to understand the structure of database. Where in the logical level the schema express their logical terms in the structure of schema and in the physical level show their connectivity of the database and other network or conjunction of the computer system in the physical level. So, there are two types of level of schema to define the structure of the database in a different level or categories. Schema in database In this post I have to discuss about the introduction of Schema of database. Here are the points about schema in database given below. The schema is a skeleton structure of database. Schema shows overall structure of data items. It also shows overall data and records and their relatio...

What are the three levels of architecture in Database management system? There are three levels of architecture in DBMS. Database Management system divided into three types of categories. The three levels of architecture are uses to better understanding with their different levels in the DBMS models. These three levels are explained in a short description. The three levels are categorized of DBMS model following below. External level Conceptual Level Internal level External Level This is the level is also known as View level. This level interacts with users directly. It is the closest level to the users. Users can understand with this level about the DBMS model. It is also called Graphical interface level. In database, data are observed by the individuals. There are so many views in a view level category. Every viewer can observe only their own database about their information or personal information of the user. How do you understand by View level in the DBMS? The exte...

Let us take an example of shop retailer is an entity and what are the possible attributes of their marketing purpose using the method of [ER Diagram] Entity Relationship Diagram? How DBMS can be used in retail shops with examples? Here I am using the method of ER diagram apply on the Shop retailer DBMS Database Management System model details with personal attribute and an Official attributes of shop retailer. In the diagram discuss about what are the possible attributes of the shop retailer. The Shop Retailer It is an Entity of shop retailer. This entity is strong entity to connect with line as according to the rule of ER Diagram. There are two categories of shop retailer detail in the diagram. Personal Detail of Shop Retailer It is an entity of Shop retailer with personal detail. There are five connected attributes to the personal detail of shop retailer entity. The strong attributes of personal detail of shop retailer are Name, contact number and address. Offic...