1,915
10
Essay, 2 pages (350 words)

Rational database


Rational Database
This is a modern data storage and presentation for an easy assessment of information where the data for a certain entity is presented in tables known as relations. It was formulated by E. F. Codd in 1970 when he presented a whole process in a paper. This type of information presentation of data has been taken in and employed by many industries today. An example of this is the British broadcasting corporations (BBC).
Describe the entity that the database would collect data about.
The BBC sports website applies the rational database to organise their sports news. The BBC sports are broadcasted on a daily basis, and their website updated with the recent sports news as collected. The journalists write the story of the news they collect and enter it into a form. After they write their stories, they submit it to the database by pressing the “ submit” on their screens. Immediately they press the ” submit”; the data enters the database. The data is stored in the database in tables that are called store tables.
List five attributes of that entity that would be included in that database.
These tables are organised to have the headlines, the dates, the venues and cities, the content, the images and other attributes of the story. Then the query that will display which information is written down. Therefore whenever a visitor visits the website, the query runs and will show the news as HTML to him when he strikes on the query.
Identify a primary key for the content.
The primary key in the BBC sports as an example is the “ Formula 1”. Hitting on this primary key, one would be directed to the formula one race news.
Defence
There are important things in choosing it as a good primary key for the database. First, it is unique; there is no other ‘ formula 1’. Secondly, the key will be easy to see and easy to access the information from it. It will also be used as a link to the story in the table that cannot be written directly on the current page.

Thank's for Your Vote!
Rational database. Page 1
Rational database. Page 2
Rational database. Page 3

This work, titled "Rational database" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Rational database'. 28 September.

Reference

AssignBuster. (2022, September 28). Rational database. Retrieved from https://assignbuster.com/rational-database/

References

AssignBuster. 2022. "Rational database." September 28, 2022. https://assignbuster.com/rational-database/.

1. AssignBuster. "Rational database." September 28, 2022. https://assignbuster.com/rational-database/.


Bibliography


AssignBuster. "Rational database." September 28, 2022. https://assignbuster.com/rational-database/.

Work Cited

"Rational database." AssignBuster, 28 Sept. 2022, assignbuster.com/rational-database/.

Get in Touch

Please, let us know if you have any ideas on improving Rational database, or our service. We will be happy to hear what you think: [email protected]