Database Environment Classification Essay

1635 words - 7 pages

Introduction:
Database environment can be classified into three simple categories:
a. Human:
Database Administrator - They are responsible to monitor and maintain the databases in an organization.
Systems Developers - They are responsible for the development of the computer applications which will talk to the database in do the necessary operations and display the results to the end users.
b. Machine:
User Interface - This is how the computer application looks and what the end user will use to interact.
Application Programs- This is the core of the computer application. These are the programs which are related to the application, so that user can use the system to get output .
c. Database:
Repository- It is a centralized knowledge base . It contains all the data definitions , report format and definitions of organizations which are related and system components.
Database Management System- It is a commercial software system which is used to create , maintain and provide controlled access to the repository.
Database - It is a collection of logically related data which is required to meet the needs of applications or users of organizations.

SQL is a special purpose programming language designed for managing data held in relational database management systems(RDBMS). [1]

1. SQL Components:
There are three components.
a. Data Definition Language .
b. Data Manipulation Language .
c. Data Control Language .
Data Definition Language (DDL):
This component is used to CREATE and ALTER (or) modify the tables and the objects of that database.
CREATE TABLE 'TABLENAME' , DROP TABLE 'TABLENAME' and ALTER TABLE 'TABLENAME' are the main commands which come under the category of DDL.
Definition of any object is stored in Data Dictionary by using CREATE command and is deleted from Data Dictionary only if DROP command is used or else it remains there permanently.
Data Manipulation Language (DML):
This component is used to manipulate the data within the tables present in the database .
SELECT, INSERT, UPDATE and DELETE are main DML related operations . Using the commands the data in the tables present as rows and columns can be manipulated.
Data Control Language (DCL):
This component is used to create privileges to users for access to data or to revoke them from manipulating the data .
GRANT and REVOKE are the main DCL related operations, which will result in granting the users privilege to access the data and REVOKE command to revoke user privileges based on the requirement and rules of access (which is defined by the organization or administrator) .

2. SQL Structure:
The basic relational model structure consists of tables with rows and columns.
These tables are given names and data related to them are maintained respectively.
The sequence of steps when a new Database is created and to make it relational:
a....

Find Another Essay On Database Environment Classification

haz can Essay

1690 words - 7 pages percentage of damage, is given by relationship between specific occupancy classifications and the building types (FEMA, 2009). The loss estimation may be run on aggregated building stock data at the census dissemination level to represent dollar exposure or calculated at building by building level for data provided by the user. The essential facility database contains assets such as police stations, fire stations, hospitals and schools. The

Database Management Essay

1268 words - 5 pages Administration Subsystem manages the overall database environment. This includes security, backup and recovery and change management is normally used by data administrators (Cummings, 2010). What is artificial intelligence? Explain the artificial intelligence systems used widely in business. Artificial Intelligence is science way of making machines emulate humans thinking in behavior (Cummings, 2010). It is the ability of a machine to

Project and Procurement Management Relationship

1003 words - 4 pages discussing problems regarding the accuracy of data in the procurement environment and its effect on the objectives of procurement management.In "Bad Data - The Problem with Procurement," Daniel Teachey discusses a problem that plagues most organizations today - the accuracy and validity of product data. Organizations are trying to cut costs across the board, especially in today's economic downturn. Procurement managers are being tasked to find ways

Machine Learning

2808 words - 11 pages 1. Introduction Humans can expand their knowledge to adapt the changing environment. To do that they must “learn”. Learning can be simply defined as the acquisition of knowledge or skills through study, experience, or being taught. Although learning is an easy task for most of the people, to acquire new knowledge or skills from data is too hard and complicated for machines. Moreover, the intelligence level of a machine is directly relevant to

Booklet the displays all the infor for employee and employer rights and responsibilities.

980 words - 4 pages to train new employees and be keen on database design and structures.?Good interpersonal skills?Ability to work in a group?Ability to design software as a group.IDENTIFY THE QUALITIES OF EMPLOYEES REQUIREDFLOW CHART Pathway for Software Engineer CompanyChief Executive OfficerManagerAssistant ManagerSupervisorStuff MembersStarting PointEMPLOYEE RESPONSIBILITIESEMPLOYER RESPONSIBILITIESThe Regulations concerning noise require an employer, in

Workplace Observation

829 words - 3 pages since the very first day they are hired. The company provides the right tools to resolve conflict between the employees and always tries to improve ways to make the work environment be enjoyable and successful for the company and the employees. References Church, A.H. (1995). Diversity in workgroup settings: a case study. Leadership & Organization Development /journal, 16, pp.3-9. Retrieved July 8, 2005 from ProQuest database DBS Policies and Procedures, (2005) Fluke.com J.R. Schermerhorn, Jr., J.G. Hunt, & R.N. Osborn Wiley, 2003. Organizational Behavior

Reasons why GMOs are Safe to Consume

667 words - 3 pages originates from a review article provided by Alessandro Nicolia and other Italian researchers who have complied “An overview of the last 10 years of genetically engineered crop safety research.” Specifically, the classification of 1783 scientific records on GR crop safety. The most popular claim against crop biotechnology by its opponents are that GMO’s lack in depth scientific studies. For example; David Schubert of Salk Institute of

Research Project Paper 1 for RES/341

677 words - 3 pages it should be taken more seriously than it has been in the past. They stateResearch Project Paper 4that even though there is an illusion of isolation and protection, an online environmentcan offer a habitat for predators in gaming and social environments. Using the internetwisely by exerting caution when dealing with others will promote a safe and happyuser experience.ReferencesMarie Griffiths, Ben Light. (2008). Social networking and digital gaming media convergence: Classification and its consequences for appropriation. Information Systems Frontiers, 10(4), 447-459. Retrieved July 23, 2008, from ABI/INFORM Global database. (Document ID: 1508193381).

Business Analysis of Dysfunctional Sports Fan: The assignment was to state the problem and the research method used in the article

971 words - 4 pages of the game experience were significantly more likely to be classified as highly dysfunctional fans than less dysfunctional fans. Also, as anticipated highly dysfunctional fans reported significantly higher levels of consumption in sports media that accommodate complaining and confrontational tendencies than did those classified as less dysfunctional.Reference:Wakefield, K.L., Daniel, L.W., (2006). An examination of dysfunctional sport fans: Method of classification and relationships with problem behaviors. Journal of Leisure Research, 38[2], 168-186, 19p. Retrieved June 18, 2006, from the EBSCO Host database.

Learning from Data

9920 words - 40 pages . Recognizing the role of feedback in using knowledge to make decisions leads to the necessity of examining the mechanisms of transferring decisions from one level of management to another, until a course of action is taken and the confrontation with the environment in which actions are exercised takes place.The unifying theme of learning is the specific mechanism of decision-making processes making institutions determine what kinds of knowledge can be

Management of Information System:China Merchant Bank

1769 words - 7 pages efficient, informational, systemic and maintainable database, which will help to achieve a modern banking environment. Through the MBS, customers will have a more wealthy life; CMB is looking forward to a fair profit and ready for the future growth.Current management strategy used to achieve business objectivesThe key to CMB multifunctional banking system success is the management strategy we implement. The major management strategy will concentrate on

Similar Essays

Postmodern Approach To Organizing Information Essay

1307 words - 5 pages their thinking (Young, 1996). Postmodernism’s ideological challenge to traditional library classification theory has not lead to a rejection of orthodox classification systems, such as Library of Congress or Dewey Decimal Classification. However, most writers agree that librarianship in the future will combine aspects of positivism and postmodernism. The Internet Movie Database (IMDb) embodies many of the characteristics of a postmodern

Schema Integration Essay

2304 words - 9 pages modeling of a database schema, automated design of relational database sub schemas in the 3rd normal form, and automated integration of relational database sub schemas [89]. One of the important aspects of IIS CASE is the detection and resolution of schema conflicts. Further details can be seen in [89], [90]. 12.10.2. WebSphere Studio Application Developer Integration Edition It is IBM’s integrated development environment including a

Servic Level Essay

829 words - 3 pages Operations Support Guide SUBJECT \* MERGEFORMAT Project Name Ministry of[Complete file/properties to populate fields on this page and in the document headers]Project NameProject #:Operations Support GuidePrepared by: Author's NamePrepared for:Date Submitted: [Date]Project Sponsor: Project SponsorClient Acceptor:Project Manager:Document Number: 6450-20/Project Number /OSGSecurity Classification: LowVersion: 1.2Last Updated: October 28

A Comparative Study Of Breast Cancer Detection Based On Svm And Mlp Bpn Classifier

1177 words - 5 pages very much important in the field of medical science as well as in Bioinformatics. In our work, MLP BPN-based and SVM-based classification techniques are applied to the Breast Cancer Wisconsin dataset from the UCI machine language repository for detection of breast cancer. Works Cited [1] R. Agrawal, T. Imielinski, and A. Swami, Database mining: a performance perspective. IEEE Transactions on Knowledge and Data Engineering, 5 (6), p. 914