ipl-logo

Relational Database Essay

2344 Words10 Pages

Relational Database:
Databases are generally used to store some data in an organized manner. Hierarchical and Network model are highly used in earlier days. But nowadays relational model is used in order to connect two files which contain common fields. One of the most effective ways of storing data is by using relational database. Edgar codd is a father of relational database, who is an oxford trained mathematician working for IBM in a San Jose laboratory. Basically relational database is an application of mathematical concepts. Relational database management system can be introduced to store information and retrieving those information for maintaining financial records, personal information and some other applications.
In 1960, amount of data are stored in …show more content…

30th April(2003). Relational Database: Defining Relationship between Database Tables.

2. Ad hoc reports: The term “Ad hoc queries” indicates that gathering data out of the database that should be more helpful for people who are using railway services. Based on the given business scenario, Westie Train Services of Auckland contains staff members such as drivers, conductors etc. Staffs need to maintain some records about train services. These data can be useful for passengers, railway department, Auckland city council or Central government to deal with the business. Herewith four types of records are explained below.
2.1 Reports on passenger details: Staffs needs to maintain the reports on passenger details. This report helps to check availability, personal details of a passenger that can be used for future use by railway service department or government. Passenger detail includes Passenger number, Passenger name, Contact number, Date of birth. Every passenger has a unique number with name as separate attribute. In addition to that every passenger’s contact number and date of birth will be recorded.
Table name: PASSENGER_DETAILS
P_Number P_Name ContactNumber DOB
2001 John 0234567

Show More
Related

  • Nt1330 Unit 1 Study Guide

    317 Words  | 2 Pages

    Choose one approach to standardization storing of data? a) MIS b) Organized

    Read More

  • Nt1310 Unit 2 Assignment

    1391 Words  | 6 Pages

    Data is organised in two ways, firstly data is stored within the hash table i.e. in an array. Secondly it is stored in linked lists and the hash table is an array of pointers to such linked lists. Applications and some examples 1. Mid-Square -We square the identifier when calculating the hash function. 2.

    Read More

  • Ece160 Unit 6 Essay

    1391 Words  | 6 Pages

    Introduction The purpose of this report is to summarize what our team, the Fig Neutrons, did for the final project of ECE160. For the project we used an Arduino Sparkfun Kit to build a Simon says game with multiple game modes that would display several different game statistics on an LCD screen. The work the team has done includes Charlieplexing LEDs and including code for implementing the LEDs, writing code for a reverse Simon game. We also had to make the game play a different song than the one provided, and write code for the LCD to display wins, losses, game length, and the number of games played.

    Read More

  • Nt1330 Unit 3 Assignment 1

    417 Words  | 2 Pages

    Servers being used Database Server – CouchDB is a database that completely embraces the web. Store your data with JSON documents. Access your documents with your web browser, via HTTP. Query, combine, and transform your documents with JavaScript. CouchDB works well with modern web and mobile apps.

    Read More

  • Pt2520 Unit 1 Assignment

    442 Words  | 2 Pages

    In developing a database, one of the first things one must know is how the database(DB) will be used within the organization. Seconda,y what type of data will be required to develop the database and how it will enhance productivity and reliability to the organization. All the information is gathered in the first phase of the database life cycle, which is planning. In the planning phase, you are gathering information on the need, cost and feasibility of the database within the organization. Also within this phase you would look to see if there are databases within the organization that can meet the requirements.

    Read More

  • Ap Euro Dbq Essay

    323 Words  | 2 Pages

    • Read Section 25-1 in Pearson Red. Take notes as necessary • Answer Section Assessment Questions #2, 4-6 2. How did U.S. leaders respond to the threat of Soviet expansion in Europe? The United States responded to the threat of Soviet expansion in Europe by aiding nations, creating NATO, the Berlin Airlift in response to their stand against communism and opened a policy of containment.

    Read More

  • General Dbq Essay

    307 Words  | 2 Pages

    Many lives were taken when fighting for their country to have justice for what Germany and the British government did. On document 9 it states “you have sickness in your head, for this is not justice.” It demonstrates on how it affected the people being attacked. On the other hand others responded differently. Many African rulers pledge themselves to not start war with other tribes.

    Read More

  • Scope Of Exchange Dbq Essay

    1252 Words  | 6 Pages

    Based on the given documents 1-8, reasons for exchanges among major societies in the period 600-1450 were mainly focused on places of religious importance, the demand for sweet tasting foods, and the abundance of necessary materials, and with this the results of exchanges among major societies in the period 600-1450 were mainly the diffusion of culture through trade, the growth of population where there was a growth of trade, and the spread of ideas or traditions through trade, while the scope and pace of exchange among major societies in the period 600-1450 were mainly increased by the development of major trade routes. Based on the given documents, reasons for exchanges among major societies in the period 600-1450 were mainly focused on

    Read More

  • Ashoka Dbq Essay

    286 Words  | 2 Pages

    In 1947, Indians chose the symbol of the Ashoka Chakra to represent their flag and their country. Their intentions were to honor a great ruler named Ashoka. 2,000 years ago, he ruled the Mauryan empire. His rule caused a boost in religion and established reforms.

    Read More

  • Ap Euro Dbq Essay

    1066 Words  | 5 Pages

    Pobj Summan AP Euro Period 4 10-17-2017 DBQ During the 16th century the large religious movement known as the Protestant Reformation took place. Protestantism was a new way of religion that challenged the usual Catholic religion. It was a very controversial idea throughout Europe, where as many countries accepted it as their religion but the countries part of the Holy Roman Empire were against it.

    Read More

  • Ashoka Dbq Essay

    327 Words  | 2 Pages

    Ashoka had many great strategies to claim land. Ashoka lived a royal because he ruled many people and had many great things. He had many violence wars that helped Ashoka out because he got lot’s of land and took lot’s of people for his army to fight. Was Ashoka a ruthless conqueror or enlightened ruler? Ashoka was an enlightened ruler because of two reasons: he out thinked the others and promoted a strong empire.

    Read More

  • Pt1420 Unit 2 Assignment 2

    102 Words  | 1 Pages

    ASSIGNMENT 02 Key: A key is an attribute or set of attribute in a relation that identifies a tuple in a relation. Followings are the keys used in Data Base Management System. 1) Super Key: A set of attributes of relations for which it holds in all relation there are no two rows that have same values for attributes.

    Read More

  • Essay Explain The Need For Safe Storage And Efficient Retrieval Of Information

    1229 Words  | 5 Pages

    The information or data that needs to be stored could relate to personal employee information that would need to be password protected so only the relevant people can gain access. Only if date if stored in a procedural manner can it be easily retrieved. This can also help if an external body needs to gain access to records for example auditors. Describe the features of different types of systems used for storage and retrieval of information. There are many different ways in which you can store and retrieve information; the main purpose of storing any information is for easy retrieval in the future when it is

    Read More

  • Pros And Cons Of Face Recognition

    1716 Words  | 7 Pages

    But it is mandatory provide there FRS-Face Recognition System, which strengthen the bank account holder’s financial security. Today, for any kind’s agreement national ID card plays an important role. For enlistment of the national ID a person’s photo and signature is mandatory. But the process should be change into 3D camera photo shoot, which will help the persons exact face identification.

    Read More

  • Advantages And Disadvantages Of Relational Database Management System

    1110 Words  | 5 Pages

    Relational Database Management System: This type of database management system that stores the data in the form of related tables. It is a social database administrator which deals with some typical kind of queries and uses SQL for the development of the database. This type of database is a very powerful database as it deals with the relations which makes the data manipulations easier other than any other database. It has the features of data entry, data deletion, and creating of new entry and records etc. the database provides the ease of accessing and maintaining data easily.

    Read More

More about Relational Database Essay

Open Document