What is a relational database?

Relational Database is collection of interrelated data managed with their relations. Database holds both the structure (schema) of the relations and the data itself. These structures are usually called tables For example, a to represent people working in different organizations, we could have a Person table, an Organization table, and Works table.

Person table would hold a unique identifier of each worker, along with other personal information. Organization table would hold a unique identifier of each organization, along with other information about that entity. Works table would hold the pairs of unique identifiers - one pair for each person working in one organization If a Person is never allowed to work in more than one Organization, we could avoid using the Works table and store the organization's identifier as a field within the Person table.

That is called a foreign key For instance, we have a table with name student and we have a table with name courses. The tables have some attributes for student(student number-sid,student name-sname,student last name-slname,student department-sdep) and for course(course number-cid,course name-cname) etc. Here we can see relational database because students take courses and here we can create a new table with attribute (student number-sid,course number-cid) because many student can take many course. Ahmet Eralp KÜÇÜK Relational Database matches data by using common characteristics found within the data set webmaster at service.ztronics.

Com Addendum: While the above answer is what most people would consider a proper definition of a relational database, it is in fact not correct. The name "Relational Database" was coined by it's creator Dr. Edgar F. Codd in 1970 in his book titled "A Relational Model of Data for Large Shared Databanks".

The new database model was based on two branches of mathematics; Set Theory and First Order Predicate Logic The name itself was derived from the term "relation" which is a part of Set Theory and in fact has nothing to do with the coincidence that there is usually one field in each table of a relational database that correlates with another field in another table (aka Foreign Key Relations). It is in fact entirely possible to create a relational database without any of these foreign keys Dallas Caley Reference: SQL Queries For Mere Mortals, by Michael J. Hernandez and John L.

Viescas. Addison Wesley 2000.

A relational database is a structured collection of information that is related to a particular subject or purpose, such as an inventory database or a human resources database. You use databases to manage information. Information, such as product name, cost, and on-hand inventory, is stored in a database.

Within the database, you organize the data into storage containers called tables. Tables are made up of columns and rows. Columns represent individual fields in a table.

Rows represent records of data in a table. You can think of database tables as grids, as in the following example: Each field in the table contains one piece of information. In an employee table, for example, one column contains the employee name, another contains the employee phone number, and the address, city, state, zip, and salary are all stored in their own columns.

Each record represents one set of related information. For example, an employee table might store information about one employee per row. The ...

A relational database is a collection of data items organized as a set of formally described tables from which data can be accessed easily. A relational database is created using the relational model. The software used in a relational database is called a relational database management system (RDBMS).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions