What is a deadlock and how can it occur?A database deadlock is a condition that occurs when two database sessions database or more have data locked, and these database sessions request a lock on data that the various sessions are already locked. Deadlock occurs when sessions are waiting for each other during this state, no transactions can take place and sessions are stuck in waiting mode. This is called an impasse. “The two queries then wait endlessly for each other to post what they each need to continue. This is called “dead end” or “death embrace”. (Gillenson, 2015)Part B1.What is data administration?Data administration is a form of data resource management which is an organizational task, it requires working in specific areas of systems information to create plans, diagrams, organize, designate and link various controls. on data resources. The various data resources are most often stored in databases and are part of a database management system or software like Excel or Access or an open source spreadsheet. In many organizations, data administration, which is handled by the database administrator, involves many tasks such as those that follow in this quote. “In order to reduce errors, improve performance, and improve one worker's ability to understand the work being done by another, it is important that the data administration function establishes standards regarding data and its use. An example of standards is controlling how attribute names, table names, and other data-related names are formed. Attribute names should be meaningful and consistent” (Gillenson,