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

Databases - Assignment Example

Comments (0) Cite this document
Summary
In designing databases, the initial steps of drawing the entity relationship diagrams play a vital role in ensuring that the database works efficiently. The key components of these diagrams are entities and the relationships that exist among them. It is therefore wise to draw…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.9% of users find it useful
Databases
Read Text Preview

Extract of sample "Databases"

Databases In designing databases, the initial steps of drawing the entity relationship diagrams play a vital role in ensuring that the database works efficiently. The key components of these diagrams are entities and the relationships that exist among them. It is therefore wise to draw these diagrams before developing the baseball statistics database.
Databases
To begin with, we must identify the attributes within the baseball statics. Identified attributes are as follows. Players are labeled as pitchers and hitters. The hitter statics include homeruns, 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 the two categories i.e. hitter or a pitcher. The ER diagram is as follows.
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 within the pitcher and the hitter. This wastes a lot of space in the data base. To normalize the ERD into INF we eliminate the redundant data.
In 1NF we introduce primary key. The primary key is a unique identifier that identifies an item (Marston, 2004). For example each player have their own unique ids 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 key in other attributes. The awayteamID for example was used in 1NF as the primary key for the Awayteam. 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 to 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.
In 3NF we introduce foreign keys
Player
PlayerId INT PK
FirstName varchar(50)
Secondname varchar(50)
Club varchar (30)

Evidently, drawing this 3NF diagram breaks down the design stage into smaller pieces that are manageable. The database can therefore be developed with ease.
Bibliography
Marston, T. (2004, September 30). The Relational Data Model, Normalisation and effective Database Design. Retrieved February 27, 2015, from Tony Marston: http://www.tonymarston.net/php-mysql/database-design.html Read More
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
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Databases

Databases

..., read, delete and update information somehow. In this sense, Stephens include filing cabinets, the brain and notebooks as databases. With regard to computer science and information technology, a database is generally defined as an organized collection of information in digital form such that a computer program can fast chose the data pieces that are desired (Connolly and Begg (2002). A database may be made for one or more purposes and may be though of as an electronic filing system. Traditionally, databases may be organized by files, records and fields. A file in this respect is a set of records, a field represents one piece of information while a record represents a...
4 Pages (1000 words) Essay

Databases

..., which is mostly preferred when it comes to setting up and storing data as opposed to other models such as relational database models and the networked model. In the recent past. This model has been widely implemented in thing such as storage of financial records among others. The main reason why databases that take up this model are more on demand is due to their relative ease of understanding. This is despite the fact that they are not very much efficient. The inefficiency, which is associated with this database model, is however, covered up by the fact that computers that are in use in the present day are more powerful as compared to back then when the power in computing had not been realized. Normalization There is another aspect...
4 Pages (1000 words) Essay

Databases

...which operate on relations and produce relation results), relation variables, and relational comparison operators. A database suitability of a given kind of database, either object oriented or relational databases, depends on the requirements of the user. The anatomy of a relation consist of the body, which is the cardinality of the relation, attribute name and attribute values (Halpin & Morgan, 2010). The number of attributes is referred to as the degree of the relation, while the number of tuples is the cardinality. On the other hand, a set of attributes is the heading of the relation, and the set of tuples is the body of the relation. To manage a database and provide...
4 Pages (1000 words) Essay

Project 3: Databases

...? Databases Databases Commonly used database include; oracle, SQL and MYSQL. A given database management system provides more than five models. The optimal structure depends on natural organizational application data and application requirements, which include transaction speed, scalability, and cost. MSQL is a relational database management system developed by Microsoft. Database primary function is to retrieve and store data as requested by other software applications (Roza, 2011). There are different versions of MSQL which are targeted different audiences and different workloads. Microsoft SQL server has several security features, which include authorization, authentication, auditing, policy based management and transparent data...
3 Pages (750 words) Essay

SYSTEMS AND DATABASES - COURSEWORK

.... A small ERP solution, SAP Business One or an open source ERP can be used effectively for the purpose to bind and ensure swift data transfer among the various entities. 2. Data store capabilities for the resident register Problem definition: The effective store and management of the resident’s records are quite ineffective at the moment. Solution: A database solution would ensure better storage, addition, modification and deletion of resident records so that bed allocation is handled better. Bed allocation would not only help the care manager but also the placement officer to know the affordable rates for the beds for fund approval process. Databases namely Oracle or MySql server can be used for storing and retrieving the records of beds...
4 Pages (1000 words) Essay

Distributed databases

... columns and utilizing additional tables to keep the outstanding columns. Normalization also comprises this partitioning of columns within tables, but vertical partitioning goes further than that and fragments columns even when normalized. Different physical storeroom might be applied to comprehend vertical fragmenting. Non relational databases initiated the idea of column based databases (Abuelyaman, 2008). The rationale for choosing this partitioning scheme is that it is cost efficient more than other schemes. In addition, it fits the required distributed databases required for this work. In order to surpass the limitations of accessible partitioning algorithm; a fresh algorithm known as VPartition, is recommended that enhances...
2 Pages (500 words) Research Paper

Databases

...accessible. Firstly, the rows in a relational database must all be unique. In case of duplicate rows problems can crop up when resolving which of the two likely selections is the right one. For most DBMSs (databases management systems) users are able to specify that duplicate rows are not permitted, and when that is done the DBMS will block the addition of any rows that are identical to an existing one. Another integrity rule of relational databases is that column values should not be repeating arrays or groups. The third involves the logic of a null value. A database handles situations where information may not be available by employing a null value to show that a...
4 Pages (1000 words) Coursework

Distributed Databases

... to acknowledge that this article has outlined a significant set of valuable information about distributed systems. This is specifically on issues based on controlling concurrency of organization data and most importantly, the security of data and transactions handles by distributed database systems. The authors of the article address indicate that concurrency control and security threat is a very crucial subject of concern in distributed database networks. The article goes further to clarify that there has been no guarantee of execution of secure database transactions in most distributed databases. Specifically, the author outlines that, there is no clear platform for ascertaining that database transactions are always maintaining the ACID...
4 Pages (1000 words) Research Paper

Distributed Databases/Very Large Databases

... the database. Especially distributed database, and it is very large database to handle such a huge type of business. Like many other multinational businesses,Walmart is also maintaining their standard for services throughout the business world. This standard is possible to achieve by the use of effective and efficient databases (Singh, 2013). Relational Database Management System for data storage Walmart is the largest company of departments and warehouses across different locations in the world, so it must have the largest database for storage. The whole process of handling and management is performed through the RDBMS (Relational Database Management System). The concept of warehouse is being used for the Walmart Company. Large database...
2 Pages (500 words) Assignment
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.

Let us find you another Assignment on topic Databases for FREE!

Contact Us