Database Technology Administration Database Technology Essay

Download this Essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Essay:

"

"STUDENT INFORMATION TABLE" (

"STUDENT ID" CHARACTER (4) NOT NULL,

NAME CHARACTER (25) NOT NULL,

"STREET NUMBER" CHARACTER (10) NOT NULL,

"STREET NAME" CHARACTER (25) NOT NULL,

CITY CHARACTER (25) NOT NULL,

STATE CHARACTER (10) NOT NULL,

EMAIL CHARACTER (25) NOT NULL,

"PHONE NUMBER" CHARACTER (15) NOT NULL );

CONNECT RESET;

SQL FOR Book_Information

CONNECT TO LIBRARY;

CREATE TABLE "USER";

CREATE TABLE BookInformation (

"BookISBN" CHARACTER (10) NOT NULL;

"AUTHOR" CHARACTER (25) NOT NULL;

"TITLE" CHARACTER (50) NOT NULL;

"PRICE" CHARACTER (10) NOT NULL;

CONNECT RESET;

SQL STATEMENT FOR CD

CONNECT TO LIBRARY;

CREATE TABLE "USER";

CREATE TABLE CD (

"CD-Id" CHARACTER (25) NOT NULL;

"AUTHOR" CHARACTER (25) NOT NULL;

"TITLE" CHARACTER (25) NOT NULL;

"PRICE" CHARACTER (25) NOT NULL;

CONNECT RESET;

Experience Gained from this Assignment

The assignment has enhanced my greater understanding on the method to use IBM DB2 Express to develop database. Although, it takes me several hours to download the software; however; I have learned several techniques to develop the database. Although, I have already developed the method to create database from the classroom note, however, the IBM DB2 Express has improved my understanding on the method to use the software to develop a database table. In addition, the assignment has developed my knowledge on the database normalization. Through normalization process, I have been able to improve the functionality of the table. While this assignment has improved my knowledge on the database development, there are still some challenges faced in the assignment; first, it took me some time to write the SQL code to create the table. Essentially, thorough understanding of SQL is very important in the database, and understanding of SQL is very important in this assignment.

PART 4 OF THE ASSIGNMENT

Normalization is the process of simplifying database in the normal form to give the database optimal structure. The normal form should be in a linear progression of a rule where higher normal form achieves better and more efficient form. Normalization theory reveals normal forms as follows:

1. First Normal Form (INF)

2. Second Normal Form (2NF)

3. Third Normal Form (3NF)

4. Boyce Codd Normal Form

5. Fourth Normal Form

6. Fifth Normal Form

The student database has met First Normal Form (INF) normalization requirements based on the following reasons:

First Normal Form (INF) reveals that all column values in the database must be atomic. The INF dictates that for every row-by-column in a given table, there should be only one value and not list of value or array of value. The benefit of this rule is that if all the list of values is stored in a single form, there is no way to retrieve data from the database, and there is no way to manipulate those values. The Student Table does not violate INF rules because the lists of values are stored in a separate column. Typically, the data stored in the Student Table are atomic because it is easy to retrieve information from the table, and it is easy to create report from the table. While INF prohibits the presence of repetition, the Student Table satisfies the requirements of the INF because the table stores single item columns in separate column.

Second Normal Form (2NF)

A table is in Second Normal Form (2NF) if it has satisfied the requirement of INF and if its non-key column is fully dependent on the entire primary key. Similarly, "tables should only store data related to one entity and the entity should be described by its primary key. In addition a table is said to be in Third Normal Form (3NF), if it is in 2NF and if all non-key columns are mutually independent." (Litwin, Getz & Gunderloy, 2002 P. 13)." Based on the rules of the 2NF and 3NF, it is critical to redesign a new table to satisfy the Second Normal Form and Third Normal Form requirements. The new tables are created to meet normalization standard and the tables are created using SQL in DBMS.

SQL FOR STUDENT INFORMATION TABLE

CONNECT TO LIBRARY;

CREATE TABLE "USER."

"STUDENT INFORMATION TABLE" (

"STUDENT ID" CHARACTER (4) NOT NULL,

NAME CHARACTER (25) NOT NULL,

"STREET NUMBER" CHARACTER (10) NOT NULL,

"STREET NAME" CHARACTER (25) NOT NULL,

CITY CHARACTER (25) NOT NULL,

STATE CHARACTER (10) NOT NULL,

EMAIL CHARACTER (25) NOT NULL,

"PHONE NUMBER" CHARACTER (15) NOT NULL );

CONNECT RESET;

NEW STUDENT INFORMATION TABLE

STUDENTID

STREETNUMBER

STREET NAME

CITY

STATE

EMAIL

PHONENUMBER

CHAR (4) NOT NULL

CHAR (25) NOT NULL

CHAR (10) NOT NULL

CHAR (25) NOT NULL

CHAR (25) NOT NULL

CHAR (25)

CHAR (25)

CHAR (15)

JOHN

PINE

SACRAMENTO

CA

401-452-6241

MARY

45

ROSE

SAN DIEGO

CA

714-452-0211

JASON

WINCHESTER

SAN JOSE

CA

562-890-2233

BOB

SANTA

CRUZ

CA

800-256-4587

LILY

EL CAMINO

ALBANY

KY

650-123-8000

MATT

CAMPBELL

BOWLING GREEN

OH

312-567-4650

DAVID

PEACH

JACKSON

MS

650-338-9910

JASON

MOODY

OCCASION SIDE

CA

310-456-6790

TIM

DECATUR

DECATUR

GA

770-323-9955

SUE

DACULA

DACULA

GA

770-808-8688

SQL FOR COURSE INFORMATION

CONNECT TO LIBRARY;

CREATE TABLE "USER." "COURSE INFORMATION TABLE" (

"COURSE ID" CHARACTER (10) NOT NULL,

"COURSE TITLE" CHARACTER (50) NOT NULL,

CREDIT CHARACTER (1) NOT NULL );

CONNECT RESET;

NEW TABLE FOR COURSE INFORMATION

COURSEID

COURSETITLE

CREDIT

CHAR (10) NOT NULL

CHAR (50) NOT NULL

CHAR (1) NOT NULL

PRINCIPLES OF FINANCE AND FINANCIAL INFORMATION SYSTEMS

4

COMPUTER HUMAN INTERACTION, GROUPWARE, USABILITY

4

Business ETHICS AND SOCIAL ISSUES IN COMPUTING

4

MARKETING AND MARKETING INFORMATION SYSTEMS

4

Management AND OPERATION INFORMATION SYSTEMS

4

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

NETWORK TECHNOLOGY AND NETWORK ADMINISTRATION

4

Thus, the above table has satisfied requirements of First Normal Form (1NF) and Second Normal Form (2NF). However, they have not yet satisfied the Third Normal Form (3NF). To ensure that all the tables meet the normalization process and satisfy the 3NF, the table must be mutually independent. (Johnson, 2011).

The paper provides the SQL statement and tables that meet 3NF

SQL STATEMENT OF STUDENTS WHO LIVE CALIFORNIA

CONNECT TO LIBRARY;

CREATE TABLE "USER."

"STUDENT WHO LIVE IN CALIFORNIA" (

"STUDENT ID" CHARACTER (4) NOT NULL,

NAME CHARACTER (25) NOT NULL,

"STREET NUMBER" CHARACTER (10) NOT NULL,

"STREET NAME" CHARACTER (25) NOT NULL,

CITY CHARACTER (25) NOT NULL,

STATE CHARACTER (10) NOT NULL,

EMAIL CHARACTER (25) NOT NULL,

"PHONE NUMBER" CHARACTER (15) NOT NULL );

CONNECT RESET;

TABLE OF STUDENTS WHO LIVE IN CALIFORNIA

STUDENTID

STREETNUMBER

STREET NAME

CITY

STATE

EMAIL

PHONENUMBER

CHAR (4) NOT NULL

CHAR (25) NOT NULL

CHAR (10) NOT NULL

CHAR (25) NOT NULL

CHAR (25) NOT NULL

CHAR (25)

CHAR (25)

CHAR (15)

JOHN

PINE

SACRAMENTO

CA

401-452-6241

MARY

45

ROSE

SAN DIEGO

CA

714-452-0211

JASON

WINCHESTER

SAN JOSE

CA

562-890-2233

BOB

SANTA

CRUZ

CA

800-256-4587

JASON

MOODY

OCCASION SIDE

CA

310-456-6790

SQL STATEMENT OF STUDENTS WHO LIVE OUTSIDE CALIFORNIA

CONNECT TO LIBRARY;

CREATE TABLE "USER."

"STUDENT WHO LIVE OUTSIDE CALIFORNIA" (

"STUDENT ID" CHARACTER (4) NOT NULL,

NAME CHARACTER (25) NOT NULL,

"STREET NUMBER" CHARACTER (10) NOT NULL,

"STREET NAME" CHARACTER (25) NOT NULL,

CITY CHARACTER (25) NOT NULL,

STATE CHARACTER (10) NOT NULL,

EMAIL CHARACTER (25) NOT NULL,

"PHONE NUMBER" CHARACTER (15) NOT NULL );

CONNECT RESET;

TABLE OF STUDENTS WHO LIVE OUTSIDE CALIFORNIA

STUDENTID

STREETNUMBER

STREET NAME

CITY

STATE

EMAIL

PHONENUMBER

CHAR (4) NOT NULL

CHAR (25) NOT NULL

CHAR (10) NOT NULL

CHAR (25) NOT NULL

CHAR (25) NOT NULL

CHAR (25)

CHAR (25)

CHAR (15)

LILY

EL CAMINO

ALBANY

KY

650-123-8000

MATT

CAMPBELL

BOWLING GREEN

OH

312-567-4650

DAVID

PEACH

JACKSON

MS

650-338-9910

TIM

DECATUR

DECATUR

GA

770-323-9955

SUE

DACULA

DACULA

GA

770-808-8688

SQL STATEMENT FOR STUDENTS WHO TAKE ITM440 COURSE

CONNECT TO LIBRARY;

CREATE TABLE "USER." "STUDENTS WHO TAKE IITM40 COURSE" (

"NAME" CHARACTER (25) NOT NULL,

"COURSE ID" CHARACTER (10) NOT NULL,

"COURSE TITLE" CHARACTER (50) NOT NULL,

CREDIT CHARACTER (1) NOT NULL );

CONNECT RESET;

NAME OF STUDENTS WHO TAKE ITM440 COURSE

COURSEID

COURSETITLE

CREDIT

CHAR (25) NOT NULL

CHAR (10) NOT NULL

CHAR (50) NOT NULL

CHAR (1) NOT NULL

JOHN

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

MARY

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

JASON

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

BOB

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

LILY

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

MATT

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

DAVID

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

JASON

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

TIM

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

SUE

DATABASE TECHNOLOGY AND DATABASE ADMINISTRATION

4

SQL STATEMENT FOR STUDENT NAMES, COURSE TAKEN AND GRADES

CONNECT TO LIBRARY;

CREATE TABLE "USER." "STUDENT NAMES, COURSE TAKEN AND GRADES" (

"NAME" CHARACTER (25) NOT NULL,

"COURSE TITLE" CHARACTER (50) NOT NULL,

"GRADE" CHARACTER (1) NOT NULL );

CONNECT RESET;

TABLE FOR STUDENT NAMES, COURSE TAKEN AND GRADES

COURSETITLE

GRADE

CHAR (25) NOT NULL

CHAR (50) NOT NULL

CHAR (1) NOT NULL

JOHN

DATABASE TECHNOLOGY AND DATABASE ADMINNNNISTRATION

A

JOHN

Principles of Finance and Financial Information Systems

B

JOHN

Computer-Human Interaction, Groupware, and Usability

B

MARY…[continue]

Cite This Essay:

"Database Technology Administration Database Technology" (2011, December 25) Retrieved December 3, 2016, from http://www.paperdue.com/essay/database-technology-administration-48682

"Database Technology Administration Database Technology" 25 December 2011. Web.3 December. 2016. <http://www.paperdue.com/essay/database-technology-administration-48682>

"Database Technology Administration Database Technology", 25 December 2011, Accessed.3 December. 2016, http://www.paperdue.com/essay/database-technology-administration-48682

Other Documents Pertaining To This Topic

  • Technology in Edu Technology Has Changed the

    Technology in Edu Technology has changed the ways schools operate, the ways teachers communicate, and the ways students learn. At every level of education, from kindergarten until graduate school, technology is being used as a means to develop and deliver course material. Technology is also being used in administrative offices, and also in the home as students have greater access to educational technologies. In traditional classroom environments, technology is being used

  • Database Security

    Database Security The focus of this study is that of database security. Databases and database technology are such that play critical roles in the use of computers whether it be in business, electronic commerce, engineering, medicine, genetics, law, education or other such entities requiring the use of computer technology. A database is quite simply a collection of data that is related such as a database containing customer information, supplier information, employee

  • Database Administration Today in Evaluating

    Design criteria exist at the levels of the technical, system integration aspects of the database to other systems through XML. This integration is critically important to ensure that the applications created can be effectively used over time and not have any scalability issues. There is also the need for designing the databases at the presentation layer to provide for scalability and flexibility of being able to create applications relatively quickly

  • Database Administrator Manager of it and the Value of a College Education...

    Database Administrator, Manager of IT, and the value of a college education As a result of swift distribution of computers and information technology, a necessity for well trained workers to design and promote new hardware and software systems and to integrate new technologies. These workers comprises of computer systems analysts, database administrators, and computer scientists. Based on the choices and procedures of employers and on development of new areas of specialization

  • Database Security Design of an

    With optimistic concurrency control, the database checks resources to determine if any conflicts have occurred only when attempting to change data. If a conflict occurs, the application must read the data and attempt the change again. Pessimistic concurrency, on the other hand, control locks resources as they are required, for the duration of a transaction. Unless deadlocks occur, a transaction is assured of successful completion 5.5 Audit Tracking Although auditing does

  • Databases Access SQL MS SQL

    Oracle supports stored programs such as stored procedures and packages. This enables the developers to centralize application logic in the database. Oracle provides powerful functions and sub-queries in its SQL statements. Developers can distribute systems by database links, materialized views and distributed queries. This feature saves much cost for developing distributed systems and applications. And there's a lot of features integrated with Oracle, compare to other database it is

  • What it Takes to Be a Database Administrator

    Database Administrator What It Takes To Be A Database Administrator A database can be defined as an organized collection of data, most probably in digitized form. Data is organized within such databases primarily in such a way that it displays and supports the processing of the relevant aspects of the information as it is required by those who use the database. Databases are usually software management systems that are quite complex. The


Read Full Essay
Copyright 2016 . All Rights Reserved