Database Technology and Database Administration Essay

Pages: 15 (4402 words)  ·  Style: APA  ·  Bibliography Sources: 15  ·  File: .docx  ·  Level: College Senior  ·  Topic: Education - Computers

Database Technology Administration

Database Technology and Database Administration

Scenario

The local community library intends to develop a database system to track customers and books that customers will like to checkout. As a new employee of local community library, I am asked to assist the library to track the following information:

Customer Social Security Number

Customer email, phone number and birth date

Date of applying for a library card.

The paper provides the sketch of a customer information table to provide greater understanding on the data to be included in the table.

Customer Information Table

This section provides a sketch of customer table that displays column heading and all the attributes of the table. The table contains five records.

Customer Information Table

Customer_ID

First_Name

Last_ Name

City

State

Zip_Code

Social_ Security_ Number

Email

Phone_ Number

Library_ Card_ Date

John

Wayne

Muntain View

NY

60640

11111

(650) [HIDDEN]

12/02/2010

John

Smith

Long Beach

Il

60641

11112

(714) [HIDDEN]

15/05/2010

Mary

Download full Download Microsoft Word File
paper NOW!


Jane

Los Alamitos

AL

60642

11113

(562) [HIDDEN]

14/05/2011

Anthony

Philip

Chicago

IL

60643

11114

(800) [HIDDEN]

13/04/2001

Higgins

Sandler

New York City

NY

60644

11115

(800)-2589-111

TOPIC: Essay on Database Technology and Database Administration Assignment

28/09/2011

Task 2: Customer Table

This section designs more tables that reveal customer checkout that track the CDs and the books that the customer has checked from the library. The tables reveal the relationship between customer and customer checkout. The data of each book is revealed in the Customer Checkout table, and the primary key consists of two pieces of data such as customer number and Checkout number. From the table, one customer can check out one or more CDs/books at a time. However, only one customer could check out order at a time.

Table revealing Customer Checkout

Task 3: Entity Relation Diagram for the Community Library

This section provides Entity Relation (ER) diagram for the complete design of the community library. To complete the ER diagram. The paper uses the Visio to draw the chart. The paper also writes down the table schema and the relationship among them. The paper follows Chen Model in presenting the ER diagram. (Orr,2007).

Fig 1: ER Diagram for the Community Library

Experience gained in the Assignment

The experience gained in this assignment is that the author has understood that a library database must contain the customer information, the physical location and the book and CD information. From the database designed, it is revealed the library can keep track of all books and CDs as well as their attributes, locations, status and late returns. The ISBN is used to identify each book ordered by the customers. To sign up for a library, a customer will have to provide his or her personal details such as names, address, email, phone number and date of birth, and a customer is assigned an ID as an identification method. At the checkout operation, a customer is required to present a library card. Moreover, the assignment has enhanced the greater understanding of the author about the method to use the ER diagram to relate the entities in the database. Relationship of the entities in the ER diagram assists the author to create tables.

Correct Table Design Based on Requirement

From the ER diagram, it is clear that the customers, cards, and CD correspond to entities in the ER model. From the ER diagram, the books and CDs are separated to allow database to store multiple items without redundancy. It is critical to eliminate redundancy in order to eliminate repeating group. In addition, the ER diagram has revealed the customer operation till the checkout operation.

NORMALIZATION FOR COMMUNITY LIBRARY

BOOK INFORMATION

ISBN

Address

City

State

CDs

CD ID

YEAR

PRICE

SHIP TO

Customer ID

Address

City

State

ORDERS

Quantity

ORDER CONFIRMATION

Customer ID

Item

Ship Date

Tracking Number

Invoice

PART 3 OF THE ASSIGNMENT

Scenario

The university intends to develop a database system to store student information and track the progress of students in their coursework. The database to be developed will generate the following report:

Students living in California

Student living outside California

Name of students taking ITM440 course

Name of students living in California and take ITM440 course

Student names, courses taken, and letter grade for each course.

Any other information likely to be retrieved from the database

1) Student Information Table

The section provides the student information table which contains student information such as Student ID, Name,

Street Number, Street Name, City, State, Email and Phone Number.

Student Information Table

Student_ID

Street Number

Street Name

City

State

Email

Phone_ Number

John

Pine

Sacramento

CA

408-452-6241

Mary

45

Rose

San Diego

CA

mary&yahoo.com

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

650-123-8000

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

2) Course Information Table

This section provides course information table that contains course ID, course title and course credit.

Course Information Table

Course ID

Credit

Principles of Finance and Financial Information Systems

4

Computer-Human Interaction, Groupware, and Usability

4

Business Ethics and Social Issues in Computing

4

Marketing and Marketing Information Systems

4

Management and Operations Information Systems

4

Database Technology and Database Administration

4

Network Technology and Network Administration

4

Systems Acquisition, Systems Development, and Project Management

4

Introduction to Software and Technical Support

4

Knowledge Management, Business Intelligence, and Enterprise Systems

4

3) Use ER diagram to represent the data modeling.

This section provides ER diagram for the data modeling of student information that includes Student_ID, Name, Street Number, Street Name, City, State,

Email, and Phone Number. The ER diagram also reveals the Course ID, Course Tile, and Credit allotted to each course.

ER DIAGRAM FOR STUDENT INFORMATION

SCHOOL

PK

School_Name

PK 1

PK2

Schoo_Code

School_city

School_zip code

DEPARTMENT

PK

Dept_Code

PK 1

PK2

School_Code

Dept_Neame

Dept_Number

COURSE

PK

Course_ID

PK1

PK2

PK3

Course_Title

Course Credit

Grade

STUDENT

PK

Student_ID

PK1

PK2

Student _ Name

Stu_Street Number

Stu_ Street Name

Stu_ City Student_State

Student Email

Stu_Phone Number

PROFESSOR

PK

Employee_Number

PK1

PK2

Dept_Code

Prof_Speciality

Prof_Rank

ENROLL

PK

Enroll_Code

PK 1

PK2

Enroll_Date

Enroll_Number

4) The problem encountered in this assignment is about the ER diagram. Completing ER diagram accurately takes time and since ER diagram is very critical in the database design, the author spent great lot time in completing ER diagram accurately. Another challenge faced in this assignment is the problem of downloading the IBM DB2 Express. It is very cumbersome to download the IBM DB2 Express to complete the assignment. The IBM DB2 software contains large file, and it takes significant amount of time before downloading the entire file. The issue found in the design is the process of using DB2 only to create the database. The assignment ought to have allowed the students the option of choosing one of the major database software instead of specifying only DB2 to create the database. Moreover, BD2 Express is not so popular among students in creating database.

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

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

PART 3 OF THE ASSIGNMENT

This section provides normalization of Community library database. By using IBM DB2, the paper proceeds to create the database. Normalization is the process of identifying and correcting poor table structure. The goal of using normalization is to reduce redundancies in the database as well as eliminating data anomalies. Tossy (2008) argue "the process of breaking the first table into two tables is called normalization." Using this procedure, the paper breaks the Community library data into Third Normal (3NF) to decompose the relationship.

Customer Information Table

Customer_ID

First_Name

Last_ Name

City

State

Zip_Code

Social_ Security_ Number

Email

Phone_ Number

Library_ Card_ Date

John

Wayne

Mountain View

NY

60640

11111

(650) [HIDDEN]

12/02/2010

John

Smith

Long Beach

Il

60641

11112

(714) [HIDDEN]

15/05/2010

Mary

Jane

Los Alamitos

AL

60642

11113

(562) [HIDDEN]

14/05/2011

Anthony

Philip

Chicago

IL

60643

11114

(800) [HIDDEN]

13/04/2001

Higgins

Sandler

New York City

NY

60644

11115

(800)-2589-111

28/09/2011

Book Information

Book ISBN

Author

Price

John

Wayne

$85

John

Smith

$70

Mary

Jane

$65

Anthony

Philip

$78

Higgins

Sandler

$80

CD Information… [END OF PREVIEW] . . . READ MORE

Two Ordering Options:

?
Which Option Should I Choose?
1.  Download full paper (15 pages)Download Microsoft Word File

Download the perfectly formatted MS Word file!

- or -

2.  Write a NEW paper for me!✍🏻

We'll follow your exact instructions!
Chat with the writer 24/7.

Database Administration Thesis


Database Administration and Project Management Term Paper


Database Shadowing or Mirroring Term Paper


Technologies Impact on Healthcare Term Paper


Database Security Design of an Online Membership Term Paper


View 200+ other related papers  >>

How to Cite "Database Technology and Database Administration" Essay in a Bibliography:

APA Style

Database Technology and Database Administration.  (2011, December 25).  Retrieved December 4, 2021, from https://www.essaytown.com/subjects/paper/database-technology-administration/6681412

MLA Format

"Database Technology and Database Administration."  25 December 2011.  Web.  4 December 2021. <https://www.essaytown.com/subjects/paper/database-technology-administration/6681412>.

Chicago Style

"Database Technology and Database Administration."  Essaytown.com.  December 25, 2011.  Accessed December 4, 2021.
https://www.essaytown.com/subjects/paper/database-technology-administration/6681412.