This website uses cookies to ensure you have the best experience. Learn more

Database Assignment

1386 words - 6 pages

1.A) Differentiate between database management system and information retrieval system by focusing on their functionalities.
Database Management System or DBMS or short, is a set of computer programs that are responsible for creating, editing, deleting and generally maintain a database or a collection of data records. database management system is determined by the database system. The database model is how the method of collecting the data is stored, managed and administered.

Among them are:

 catalogs, books or other types of documents
 computerized bibliographic
 address directory
 newspapers, magazines, journals
 collection
 intranet search engines

Advantages of DBMS are :

 increase unavailable: One of the principle advantages of DBMS is the same information can be provided to different users.

 surplus Scale : Data in a DBMS is easier because , as a general rule , information appears only once . This can reduce data redundancy, or in other words , constantly repeating the same data . Lose excess because it can reduce the cost of storing data on disks and other storage devices .

 Accuracy : Accurate , consistent, and regularly update the date data is a sign of data integrity. The opportunity to make mistakes is higher if you need to change the same data to several different places where you need to make changes in one place.

 consistent programs and files : Using database management systems , file formats and programs of the system are standard. This makes all data files will be maintained as the rules and guidelines to be used in all types of the same data . Consistency across files and programs also makes it easier to manage data when multiple programmers are involved.

 User friendly : Data is easily accessed and manipulated by the DBMS . In most cases, the DBMS also reduce dependence on computer experts to meet the needs of individual users of their data.

 Improved security : As stated before, the DBMS allows multiple users easy to access data sources alike. Capacity is usually viewed in terms of benefit, but there are risks faced by the organization . Some sources of information that should be protected and only viewed by the individuals themselves.
Lack of DBMS are:

• There are two major drawbacks to using DBMS among them the cost and data security threats
- Cost: Implement DBMS is to use high cost and time consuming, especially in large organizations.

- Security: The security cover is not allowed to access the database. When the user is not allowed to enter into the database, they do not Boley access all files, not just some. Depending on the type of data involved, security breaches can also pose a threat to individual privacy. Steps should also be taken to make a backup copy of the database file and save it so that eventuality can be avoided such as fire and earthquakes that can destroy the system.

Information retrieval systems:

 information process begins when a user enters a query into the system.
 "text...

Find Another Essay On database assignment

Proprietary Databases Essay

667 words - 3 pages assignment. We can be on vacation away from home and we still have access to search engines and other databases on the go, mobile. I believe that as a whole I can achieve the academic success that I wish to by using Ashford’s Library proprietary database, Meta search databases, as well as my preferred search engine Google. My reasoning behind this statement is because, different academic assignments call for different options for resources and

Database use in Modern Business Essay

697 words - 3 pages . The name of the program is ShopPro(Advantage Systems , 2004) . This program is a stand alone application fully made by programmers. No other applications were imbedded or used has a database ad on module. This program has many useful tools. This paper will discuss each one to fully explain ShopPro capabilities:Customers' InformationThe first screen is a complete customers' database. In this module, customer records can be set up, updated and stored

Plagiarism, APA, and

455 words - 2 pages its database. The APA (American Psychological Association) documentation style is a type of guideline for student to use to help them format their paper as well as determine the layout. It also gives student the opportunity to correctly cite other authors' work.Franklin University also has a very extensive dishonesty policy. If a student is caught in academic dishonesty a faculty member must sent that student written notification. Depending on

ENC-102-OL011 2014 JAN: ENGLISH COMPOSITION II Module 2- Introduction to Research, Part 2

820 words - 4 pages sometimes find a perspective that, to me, seemed much more interesting and causes me to change my writing plan. To stay on track, I began the research process by reading the module objectives and the assignment summary, first, to thoroughly understand the assignment, then, to give myself a basic outline. Reading and understanding the textbook and handbook references introduces new points, and reinforces what I have learned in previous classes

Skills and Certification Design and Implementation Project

1992 words - 8 pages skill versionsCertification: Search by one or many certificationsExpire Date: Search by certification expiration dateThe ultimate success factor would be measured by the ability to search by all database fields to facilitate future report growth and unanticipated needs.A business process must be implemented to ensure that new skills are added and updated to each consultant after a successful training assignment or successful engagement where the

Database Design and Testing

814 words - 4 pages MIS 4330 – Assignment 6 and Assignment 7: Database Design and Testing Assignment: Complete exercises 1-4. Exercises: 1. Recall the AVS scenario from previous assignments. Create an ER Diagram to represent the database design for this system. Include the entities, attributes, relationships, and cardinalities. Name a minimum of three attributes for each entity that you have identified. (20 points) 2. Examine the database entities shown in

Healthlite Yogurt Company and MIS

3381 words - 14 pages CONTENT:Introduction:What is IS? Why should establish IS effectiveness? How to utilize IS to compete in marketplace? Why Healthlite Yogurt Company need to design new information systems?The problems of the company:Centralize the problems of the Healthlite Yogurt Company.New information system:Design tow new information systems for Healthlite Yogurt Company.One is database processing system. The other is electronic data interchange(EDI

Overload Management Issues Within Real-Time Databases

1051 words - 5 pages Testing The reason for the selection of this topic is because it falls under the computer science category. We have been studying databases for four years and so the this topic area will be of great use when venturing into the cooperate world. Knowledge gained will assist in tackling real life situations when it comes to real-time database transactions. Diagnosing problems related to the topic area will prove slightly easier. Real-time

Team Communication

1307 words - 5 pages , all must be ready.Accepting setbacks and allowing room to go in a new direction is very key to team communication. As a result of the feedback and criticism, the team may decide that the entire group needs to change directions. Although this may seem disappointing, it will most likely help the project at hand. Always remember that ultimately "Nothing happens until a sale is made (Gleason, 2006)." The project or assignment is never complete

jweifwe iwuhfif ifhwefwe webwndwmedw - University of Toronto - Essay

780 words - 4 pages Tharini Jayasinghe – 100961066 The Journal Article Assignment – SOCI 1002 The name of the chosen article for the assignment is called Gendered Homophobia and the Contradictions of the Workplace Discrimination for Women in the Building Trades, written by Amy M.Denissen from the California State University in Northridge and Abigail C.Saguy from the University of California in Los Angeles. The article was published in the Gender and Society journal

Using Microsoft Excel to Keep Track of Monthly Payments

826 words - 3 pages software Microsoft Excel 2003 as it was easier to use than other software products. As well Microsoft Excel can perform more useful functions such as Absolute Cell Reference, Functions (MIN, MAX and AVERAGE),Conditional Formatting and many more. Each of these useful in a case such as this. Information Access The information was found for this spreadsheet by using the database used in the previous Assignment B2 by running a query in the

Similar Essays

Strategic Management Case Analyse 1 Essay

617 words - 3 pages plagiarism checking service, such as the "Turnitin" service operated by iParadigms LLC (or such other service utilised by the University at its absolute discretion). I acknowledge that a plagiarism checking service provider may then retain a copy of this assignment on its database for the purpose of future plagiarism checking.Signature of student(s): ___________________________________________ Date: 11/09/2014Last updated: June 2013Approved by: University Learning and Teaching Committee

Problem In Active Real Time Database Application

1117 words - 5 pages real-time application has a good potential. In this paper we will focused on the issues and the question such as sematic, assignment of time constraints and rule selection. Which we have to consider when we are designing or implementing real-time database. And I will highlight the issues associated with event detection, rule triggering, rule selection and evaluating in an active real-time database system. Index terms: - hard real-time, soft

Database Normalization Essay

985 words - 4 pages Database NormalizationBy: K. TurnerNormalization in its most literal sense means: To make (a text or language) regular and consistent, especially with respect to spelling or style. 1 Normalization with regard to database technology takes on a slightly different meaning, but the concepts of consistency and organization remain the same.As a database grows, it grows not only in size, but also complexity. This inevitability provides a need to

My Time As A Research/Database Intern

1063 words - 4 pages For my co-op assignment I worked for the Clark College Foundation as a Prospect Research/Database Intern. When I first entered the foundation I was unsure of how I would fit into the organization. This would be the first time I had ever worked in an office environment and I had no idea what would be expected of me and if I would be able to perform the job that I had been hired for. On my first day my supervisor Chris Mildner took me around the