StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Components of Databases - Assignment Example

Cite this document
Summary
The assignment "Components of Databases" focuses on the critical analysis of the major issues in the components of databases. In designing databases, the initial steps of drawing the entity relationship diagrams play a vital role in ensuring that the database works efficiently…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.9% of users find it useful
Components of Databases
Read Text Preview

Extract of sample "Components of Databases"

The hitter statics include home runs, batting average, stolen bases, doubles, triples, and walks. The pitcher statistics are strikeouts, walks, saves, innings pitched, earned runs, wins, and losses.

The following design may then be used. We assume that each player belongs to two categories i.e. hitter or pitcher.

An entity is in the first normal form if it contains no repeating sets of data. Similarly, the above attributes contain several repeating attributes. Walks for example are found between the pitcher and the hitter. This wastes a lot of space in the database. To normalize the ERD into INF we eliminate the redundant data.

In 1NF we introduce the primary key. The primary key is a unique identifier that identifies an item (Marston, 2004). For example, each player has a unique ID that can serve as the primary key.

In 2NF we further normalize the diagram and include foreign keys. These foreign keys are items that are used as primary keys in other attributes. The away team D for example was used in 1NF as the primary key for the Away team. It is therefore introduced into the game attribute as a foreign key.

When we develop the 3NF we ensure that there is no redundancy. The relationship between player and batting is one too many. This means that a player can play for only one team at a time. The relationship between a team and a player is many to one meaning that many players can batt.

Drawing this 3NF diagram breaks down the design stage into smaller pieces that are manageable. The database can therefore be developed with ease.

Read More
Tags
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Databases Assignment Example | Topics and Well Written Essays - 500 words”, n.d.)
Databases Assignment Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/information-technology/1680325-databases
(Databases Assignment Example | Topics and Well Written Essays - 500 Words)
Databases Assignment Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/information-technology/1680325-databases.
“Databases Assignment Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/information-technology/1680325-databases.
  • Cited: 0 times

CHECK THESE SAMPLES OF Components of Databases

History in Distributed Databases

Though, the distributed databases require the development of databases using all the traditional techniques of database development except they are based on a different perspective.... The paper "History in Distributed databases" highlights that One of the most important advantages that organizations attain by implementing distributed databases is that it becomes easier for them to deal with increasing database sizes.... This paper has discussed some of the important aspects associated with distributed databases....
10 Pages (2500 words) Essay

Project 3: Databases

databases Name Institution databases Commonly used database include; oracle, SQL and MYSQL.... MSQL, when compared to other databases like Oracle, it's easy to manage and does not have to have gurus in order to manage the database.... It contains a set of components for building rich web applications and social sites.... CBO has changed into the most sophisticated components and has the challenging job evaluating any SQL statement and generating the best execution plan for the declaration (Jarratt, 2004)....
3 Pages (750 words) Essay

Object Database Management System

This essay "Object Database Management System" will talk about the organization of databases which use objects as the main measure tool.... Moreover, the paper will cover the management system for this kind of databases, particularly the implementing aspects.... Firstly, relational databases turn out to be cumbersome to use with composite data.... bject-oriented databases are designed to work well with object-oriented programming languages such Java, C#, and C++....
8 Pages (2000 words) Essay

Images and Database Technology

"Images and Database Technology" paper different aspects of database technology, existing models of database management, and their advantages compared to the traditional way of data processing.... The research paper also makes a review of the most popular DBMS and their characteristic features.... ....
12 Pages (3000 words) Essay

Components of a Database Application, Database Management System

The paper "components of a Database Application, Database Management System" states that Samantha could easily implement MySQL.... Which of the following components of a database application is Samantha likely to need: data entry forms, reports, queries, or application program?...
1 Pages (250 words) Assignment

Components of Database

The following paper entitled 'components of Database' focuses on databases which are the key components of successful businesses.... They help businesses manage their resources efficiently.... This is why pop and mom Enterprise wishes to design the following database....
2 Pages (500 words) Essay

Managing Business Information

Assessment of new application software and how well they are able to be incorporated in the organization's needs for example evaluation of the Components of Databases that can match the needs and objectives of that given organization.... Business information systems will tend to cover various aspects of technology; software and hardware, databases, spreadsheets, e-commerce, m-commerce, telecommunications, enterprise resource planning transaction processing and decision information support, societal and ethical issues that may arise....
6 Pages (1500 words) Coursework

Library Database Design

This report "Library Database Design" discusses the university library has many students who borrow different kinds of books and since there are too many students to automate the process of book control like checking the authorization to use a library, etc.... ... ... ... Since there are too many students with keeping track of all the books made – like for example, the date on which the book was borrowed, the student involved....
6 Pages (1500 words) Report
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us