fundamental understanding of relational databases.Normalization and SQL as User friendly Language

Feb 3rd, 2012
Studypool Tutor
Price: $15 USD

Tutor description

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: Describe what a relational database is and why relational databases are needed. Describe the process of normalization and why it is needed. Contrast and compare logical and physical database design. Critique SQL as a user-friendly query language.

Word Count: 1495
Showing Page: 1/6
1. Describe what a relational database is and why relational databases areneeded.A simple database is a program that has ability to store and retire data rapidly as per userrequirements. Database have been in use by business since start of computer era howeverdatabase were in shape of one long text file called Tab delimited file or Flat file databases .It was text based data storage in single file where each entry was separated withuse of special characters. Each record about person, or groups had different types ofinformation grouped together. It was very difficult to search and create report of requireddata.(Colin,2005)In early 1960s there were two navigational data models hierarchical model , and Codasylmodel were used by businesses these both had manual facility to search and navigaterecords. In 1970 E.F Codd from IBM wrote many papers introducing new approach todatabase development that later formed the basis of relational database. Since then itbecame standard and popular model for databases.According to Jain (2009 ) A relational data base is data base where data is organized intocollection of relations. The relation is mathematical term used for this type of databasemodel that has underlying basis on mathematics.(Hector,2008 ). The data is stored in formof tables that are interlinked in (relation) making retrieve, search and navigation ofrequired data easy. With use of relational database user can compare information veryquickly due to tabular

Review from student

Studypool Student
" Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1823 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors