Contact Us
Sign In / Sign Up for FREE
Go to advanced search...

Database Administration -2 - Essay Example

Comments (0) Cite this document
The database Administrator is responsible for establishing effective control over the database, moreover, the performance/efficiency, integrity or correctness and security of an information system database. However, depending on the experience and organization the role and…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER92.2% of users find it useful
Database Administration -2
Read TextPreview

Extract of sample "Database Administration -2"

Download file to see previous pages The database administrator would have the above given skills in order to perfectly perform his/her roles and responsibilities to manage the information system database in an organization. It is pertinent to mention here that these are the basic and fundamental skills of a database administrator; therefore, the database administrator must have these skills in addition to the specific skill set requirement of the organization (CWJOBS, n.d).
The database is considered accurate if the values stored in the fields of the database are correct. As the organizations rely and presume that the information that is input into a database is faultless as well as accurate. Therefore, the design of the database should be accurate and reliable that will not only help to achieve new business ideas, but also play vital role in promoting the organizational goals. It is sure, if the data gathering and storing process is malfunctioning, the established data will be incorrect as well; this process is known to be as Garbage in Garbage Out (GIGO) (Rushinek & Rushinek, 1985).
Updated and current data have been always important for any organization; therefore, the stored data has to be updated and current with respect to the requirements of the organization. The end users of the database have to be aware of any variation of a standard update schedule of the database. Real-time information is one of a key component of timeliness.
A DBMS system contains metadata i-e data about data, in other words the data and a full explanation of the data. The explanation of the data includes: how data would be accessed, what are the data formats and record structures. On the other hand, the file processing approach is contrasted to this approach, whereas, the structure and format of data and records are required to be known to the application programs.
The changes in the database i-e change in data format, change in index structure or entering a new field etc. are reflected in the catalogue; therefore, ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Database Administration -2 Essay Example | Topics and Well Written Essays - 1000 words”, n.d.)
Database Administration -2 Essay Example | Topics and Well Written Essays - 1000 words. Retrieved from
(Database Administration -2 Essay Example | Topics and Well Written Essays - 1000 Words)
Database Administration -2 Essay Example | Topics and Well Written Essays - 1000 Words.
“Database Administration -2 Essay Example | Topics and Well Written Essays - 1000 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Database Administration -2

Database Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key class_id text 50 Y Not Null PK class_name text 100 Y     class_day text 15 Y     class_max capacity integer 2 Y     class_start_date date 20 Y     Entity DEFINITION Entity Name: BOOKING   Entity Description: All the bookings relevant to classes and visits are recorded here Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key bk_id text 50 Y Not Null PK class_id text 50 Y Not Null  PK and FK ow_id text 20 Y Not Null PK and FK bk_date date 20 Y     Entity DEFINITION Entity Name: INVOICE   Entity Description: Invoice details relevant for each booking is recorded in this relation Attribute...
4 Pages(1000 words)Assignment

Police administration 2 questions

...? Police Administration 2 Questions Police Administration 2 Questions Question The American Bar Association has recognized the position of police chief as being among the most important and most demanding positions in the hierarchy of government officials. The roles of a police chief compares favorably with those of government officials and institutional leaders. The main difference between the duties of a police chief and those of other government officials is the authority accorded to him by the preceding authority and their social and political implication within the country. This essay compares the duties of a police chief with the duties of patrol sergeant, mayor,...
4 Pages(1000 words)Coursework


...? Creating an Extended Entity Relationship Model (EERM) Creating an Extended Entity Relationship Model (EERM) We use a classical four-layered approach to inductive specification of database structures. The first layer is the data environment, called the basic data type scheme, which is defined by the system or is the assumed set of available basic data. The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011). The second layer is diversely treated by database modeling languages... for...
6 Pages(1500 words)Assignment

Database assignment 2

..., Budget Car Hire Company requires various systems to manage its operations. The company has branches all over the world and booking can be made directly via branched or online through the company’s website and agent websites. Three Proposed Applications In this report, three proposed applications that fulfill the companies’ needs will be discussed. Specifically, the three applications are to facilitate transactions and operations. The applications are: Direct Renting from braches. Online booking system. Car purchasing system. The systems will have to be integrated into a single database and network for the purpose of data access and processing. This is the function of the data modeling process. Brief overview of the...
10 Pages(2500 words)Assignment

Database systems and Administration

...? Database management Supervisor] ERD: Department: No Attribute PK FK Data Type Department ID P Alphanumeric 2 Department Name Varchar (100) 3 Country ID F Numeric Job: No Attribute name PK FK Data Type 1 Job ID P Alphanumeric 2 Description Varchar (100) 3 Qualification required Varchar (100) 4 Salary Numeric Product: No Attribute name PK FK Data Type 1 Product ID P Alphanumeric 2 Description Varchar (100) Inventory: No Attribute name PK FK Data Type 1 Inventory ID P Alphanumeric 2 Product ID F Numeric 3 Country ID F Numeric 4 Quantity Numeric Sales: No Attribute name PK FK Data Type 1 Transaction ID P Alphanumeric 2 Money Obtained...
16 Pages(4000 words)Essay


...are held on record. Products are identified by their name and records of the product type and a description of the product are kept. i.) Design an E-R diagram for the above database ii.) Derive a corresponding relational scheme from your E-R diagram. Table Assets: assetID (primary) productID (primary) location LeaseRenewalDate Table Assets Inspection: inspectionID (primary) inspectorID (primary) assetID (primary) maintenanceDate maintenanceAction Table Inspectors: inspectorID (primary) name position Table Products: productID (primary) name type description Question 2: A garden plant supplier keeps data about their customers, orders and the plants they sell in a relational database...
4 Pages(1000 words)Assignment

Database Architecture and Administration

...Database Architecture and Administration Evolution of Database Models The aim of this essay is to present an evolutionary history of various Database Models over the four decades of their existence. The essay attempts to list the strengths and weaknesses of each model and discuss the causes that led to their development. While databases have been used since the beginning of electronic computing, the earliest databases were custom made for organizations, difficult to operate and extremely inefficient. These file-based systems needed specific, custom-built programs to access and manage it. Since each file was isolated from others, it often...
9 Pages(2250 words)Essay

Public Administration 2

...George Tenet and the Last Great Days of the CIA Tenet George was CIA’s (Central Intelligence Agency) Director from 1997 to 2004. Since he excelled in job, George Tenet was requested to remain as CIA’s Director after President Bush took over the Presidency. Tenet became a component in the Head of state’s inner circle something that did not happen with the Clinton’s administration. The minute George Tenet entered the Head of state’s inner circle; he was unable to focus upon rebuilding the CIA agency. Richard White in ‘George Tenet and the Last Great Days of the CIA’ offers the upturn and collapse of the Central Intelligence Agency under the CIA’s Director Tenet George (Stillman, 2000). With any career, ethics will always...
4 Pages(1000 words)Essay

Database Logic and Management questions Module 2

...DATABASE LOGIC AND MANAGEMENT QUESTIONS MODULE 2 Database Logic and Management questions Module 2 Affiliation What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly? An E-R (Entity-Relationship) Model is a graphical representation of entities and their relationships. One of the basic purposes of an E-R diagram is to clarify the system requirements particularly in case of a system which involves implementation of a database (Hoffer, Prescott, & McFadden, 2007; Whitten, Bentley, & Dittman, 2000). In this scenario, (Craven, 2001) discuss some of the major...
2 Pages(500 words)Article

Database Plan: Barriers to Bar-Code Medication Administration

...Database PLAN: BARRIERS TO BAR MEDICATION ADMINISTRATION Number: Lecturer: Introduction The systems of medication administration using bar codes were developed with an aim of reducing drug administration errors a long side associated costs as well as to enhance patient safety. This is possible via safe medication administration which is essential to guarantee quality healthcare. The errors or accidental processes can occur as a result of work created by nurses (Barbara, 2012). The rest of this paper is organized in to barriers to medication problems, conceptual data model for the planned database. The entities planned for the...
4 Pages(1000 words)Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Database Administration -2 for FREE!

Contact Us