Sign In
Not register? Register Now!
Essay Available:
Pages:
4 pages/β‰ˆ1100 words
Sources:
3 Sources
Style:
APA
Subject:
Technology
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 21.6
Topic:

Databases

Essay Instructions:

Assignment 3: Databases Due Week 7 and worth 110 points You are the trainer for a major technology firm. One of the problems your firm has is hiring new technologists who have a fundamental understanding of relational databases. Therefore, you’ve been asked to create a database orientation paper. Write a four to five (4-5) page paper in which you: 1. Describe what a relational database is and why relational databases are needed. 2. Describe the process of normalization and why it is needed. 3. Contrast and compare logical and physical database design. 4. Critique SQL as a user-friendly query language. 5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:  Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.  Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Essay Sample Content Preview:
Databases
Name:
Institution:
Date:
Introduction
Having a properly designed database is important if accurate information is to be provided to an organization. Initial creation of an effective database ensures that modifications to this initial design will be kept at minimum. Discovering problems after putting into operation, a particular database may turn out to be detrimental to the institution, business, or organization. Database development is a three-phase process that is first logical design that involves the definition of fields, tables, foreign and primary keys, establishment of relationships between tables, and levels of integrity of data. Second is implementation of the logical design using Data Base Management Systems (DMBS) to create tables and how their relationships and using the tools to implement levels of integrity for the data. Finally, is the development of an application for end users.
Q.1
What is a Relational Database?
Databases contain one or more tables of information. The tables contain rows and columns the rows are called records while the columns are referred to as fields or attributes. Databases having one table are called flat databases while a database with two or more related table is a relational database. Therefore, a relational database is a database having symbols that are organized into a collection of relationships (Date, 2012). Dr. Codd applied theories used first order predicate logic theory and the set theory in designing relational databases. Relationship here is, therefore, relation is a formal term used in the logical foundations of mathematics and appeals to the notion of two things being related (Date, 2012).
Figure 1: Relational Database
Source: IGCSE ICT-Types of Database (dineshibakshi.com)
Why are Relational Databases Needed?
Big data has been a problem for most institutions and organizations with the trend in big data indicating a shift towards a point where organizations will be han...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Essay Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now