Database Essay

554 words - 3 pages

Data management is one of the grey areas that every organization endeavors to improve almost daily. Most important is the data cleaning and data transformation processes. In actual sense, relational database offers a solution to this menace. Data organization, keeping, storage, and retrieval among other essentials can easily be realized by adopting relational data management model. In this kind of model, tables are made use of in such a way that data items are formally described and organized according to their level of relations. The data item contained in a given table represents a relation. I am convinced beyond reasonable doubt that through the use of relational database model, an organization can be able to effectively manage their wide range of information encountered on a daily basis. Relational database model offers a more efficient means of managing data. Some of the huge ...view middle of the document...

The advantages of a relational database are that they contribute to sound logical design, are easy to understand and program, and should be amenable to change as business requirements change. The main earlier systems include file-based systems and Codasyl databases. File-based systems were complex and tended to be inherently restrictive and quickly reached the point where a complete rewrite became necessary if business requirements changed. Codasyl databases were a vast improvement on the old file-based systems, but required a high level of expertise to design properly and, once again, tended to be unable to support changes to business requirements. Because a properly designed relational database reflects business entities and the relationships among those entities, they should be more logical and easier to understand. If the business structure or requirements change in any logical way, the database can be changed in a parallel way, to support those requirements. Relational databases are designed at two levels. First, there is a logical design, normalised at third normal form - where there should not be duplicate data values. Then, there is a physical design, where any necessary denormalisation is carried out.
Relational databases have an excellent security. A relational database supports access permissions, which allow the database administrator to implement need-based permissions to the access of the data in database tables. Relational databases support the concept of users and user rights, thus meeting the security needs of databases. Relations are associated with privileges like create privilege, grant privilege, select, insert and delete privileges, which authorize different users for corresponding operations on the database.
Data integrity in relational database is a method of ensuring that the integrity of the set relationships remains legitimate during the data processing operations. The rules of integrity are designed to prevent the case of orphaned table records on the side of relationships.

Other assignments on Database

Database Design Paper

404 words - 2 pages Database Design Paper DBM380 March 09, 2015 Database Design Paper A database is a computer structure that organizes a collection of data so that it can be accessed, updated and managed as fast and efficiently as possible. There are several classifications of databases, “For example, databases can be classified by the number of users supported, where the data are located, the type of data stored, the intended data usage, and the degree to

Database Management Chapter 2 Essay

416 words - 2 pages 1. Besides redundancy, what other problems are associated with the nondatabase approach to processing data? Another problem with the nondatabase approach is accessing related data. In order to access data that is related to one another, you would have to open multiple spreadsheets, nondatabase systems also have way less security features than a database system. 2. What is a relationship? A one to many relationship? A relationship is an

Database Questions Pg.80

331 words - 2 pages Alex Swan Mr. Davis 9/18/12 Homework Review Questions 3.1 Define the following terms as they apply to the relational model of data: Domain – Set of atomic (indivisible) values. Attribute – it describes a component of the database, such as a table or a field. N-tuple – in mathematics, an ordered set of n elements called its components or coordinates. Relation Schema – It is representation of database highlighting relationships that we

Database Management Chapter 1

859 words - 4 pages Principles of Database Management Systems Homework 1 Ying Li 4861521 Homework 1 Exercise 1.4 Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? Answer: External schemas, which usually are also in terms of the data model of the DBMS, allow data access to be customized (and authorized) at the

Database Systems For Business

2877 words - 12 pages Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database

Google Database Stuructures In Business Databases

1547 words - 7 pages (Assignment title). (Student’s Name) (Professor’s Name) (Course Title) (Date of Submission) Google database technology is such a familiar tool in the operations of HIM departments in hospitals. This technology is usually adequate to allow HIM professionals to work with vendors or information services staff. Database technology is moving from the task of supporting paper systems to actually becoming the central digitized health

Pt2520 Homework 1

305 words - 2 pages Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases

Data

324 words - 2 pages base Database Design Paper DBM 380 A database system arrange information in a computer, enforced by a set of computer programs. An organization of this kind should offer simplicity an easy way to access connect, display and collect information. A database management system allows users the capability to enter data within the database by the use software. This software is designed

Benefit Election System

1290 words - 6 pages transportation company with 1,400 employees working in logistical hubs across the United States. The human resources department currently maintains several tracking mechanisms for its employee information. The company has an HRIS system that was developed in-house that maintains a database of personal information. One of the company’s managers also maintains an Excel spreadsheet for individual compensation decisions and surveys. With the

A Microfinance Mis

263 words - 2 pages offers a charting engine that lets you add charts to your own application (eclipse.org). With BIRT software, you can add a rich variety of reports to your application such as charts, crosstabs, lists, compound reports, and letterhead (eclipse.org). BIRT reports consist of four main parts, data, data transforms, business logic and presentation (eclipse.org). The sample database is available in two forms, the Apache Derby database, which is

Jedi

286 words - 2 pages a) What is a database? A database is an organized collection of related data. b) How does an RDBMS store data? An RDBMS stores related data in tables. 2. What is one benefit of dividing data into tables? Dividing data into tables eliminates unnecessary data duplication, or data redundancy. 3. a) What is a database schema? A database schema is a

Similar Documents

Database Security Essay

281 words - 2 pages * Security in Database System * GROUP 5: * Chandra Muthineni Marat Talantov Bharath Rao Sinan Albayrak * Agenda * Introduction * Threats Of DataBase Security * Classification of Database Security * Process of Creating Database Architecture * Advantages * Conclusion * Q & A * References * Introduction * Database security is a crucial area that a firm should enhance in order to

Database Design Essay

464 words - 2 pages Database Design Paper John Hancock DBM/380 April 23, 2013 April Johnson Database Design Paper Database systems are an organized collection of data. The data is normally organized by a couple different methods; structured and unstructured. Database systems make working in a company a lot easier when an employee is looking for information. By having a database management system in the work place the employees will have improved data

Nosql Database Essay

6247 words - 25 pages thorough highlight presentation yet rather a review of what and how Elastic Search can accomplish for you. Table of Contents 1. Introduction 2. What is Nosql Database Systems? 3. Relational Database Systems 4. Comparison 5. Conclusions 6. REFERENCES 1. Introduction NoSQL stays for Not Only SQL in like manner declared as noseequel. NoSQL is used for securing epic measure of data made by various

Database Search Essay

453 words - 2 pages database are written by nurses and are subject to review by leading authorities in the profession” (British Journal of Nursing, 2016). I thought that this would be most helpful because it is coming from someone who has actually has experience in the profession, not just someone who is doing research on it. The article that I found discussed how it is important to not only assess the five main vital signs (blood pressure, temperature, oxygen