Home > Free Essays > Tech & Engineering > Data > Hierarchy of Data in the Video Store Database

Hierarchy of Data in the Video Store Database Coursework

Exclusively available on IvyPanda Available only on IvyPanda
Updated: Sep 9th, 2022

The term ‘data’ covers the combination of raw facts stored in a database. The data acts as an interface between the machine components and the human components. A database consists of the operational data and the information about data (Connolly & Begg, 2003). Therefore, data must be organized in a meaningful way in order to get the required information. In this light, the following paragraphs explain the hierarchy of data in relation to a video store database.

A computer arranges data in a hierarchy that starts with bits and bytes and processes to fields, records, files, and databases (Stair & Reynolds, 2006). A bit is the smallest unit of data which can be combined together to form a byte. As illustrated in Figure 1, a byte represents a single character (letter, number, or another symbol). Consequently, Laudon & Laudon (2006) outlines that; a field is a grouping of characters into a word, a group of words, or a complete number. A group of related fields, such as the video title’s number, the name, the actor, the director, the runtime and the year of production, constitutes a record; a group of records of the same type is called a file. Furthermore, a record describes an entity, which can include a video title. On the other hand, an attribute is a characteristic of an entity; for instance, the video title’s director. It is also essential to have a key field that exclusively identifies other records in the database; in this example, title number is the key field.

In a video store database scenario, the video records in Figure 1 could comprise a video title file. The video titles included in this example are: The Matrix, The Shawshank Redemption and The Dark Night (The Internet Movie Database, 2009). More so, at the highest level, a database can be realized. Stair & Reynolds (2006) states, “a database is a collection of integrated and related files” (p. 93). Thus, the video title file illustrated in Figure 1 could be grouped with files on video store members, rentals, category, and certification; to create a video store database.

The Data Hierarchy
Figure 1. The Data Hierarchy
Title# Name Director Actor Cat. # Runtime Year
1001 The Shawshank
Redemption
Darabont,
F
Robins,
T
2 142min 1994
1002 The Matrix Wachowski
, A
Keanu,
R
1 136min 1999
1003 The Dark Night Nolan, C Bale, C 2 152min 2008
Title# Name Director Actor Cat. # Runtime Year
1002 The Matrix Wachowski
, A
Keanu,
R
1 136min 1999

In conclusion, Information System effectiveness depends on how data are stored, organized, and accessed. As a result, it is important to have a clear view of the data hierarchy which is comprised of bits, bytes, fields, records, files and database. In essence, each component in the hierarchy constitute the other; starting with a bit to a database.

References

  1. Connolly, T., & Begg, C. (2003). Database Systems. A practical Approach to Design, Implementation, and Management. (3rd Ed).Patparganj, Delhi: Pearson Education Ltd.
  2. Laudon, K. C., & Laudon, J. P. (2006). Management information Systems: Managing the Digital Firm. (9th Ed).Upper Saddle River, NJ: Pearson Prentice Hall.
  3. Stair, R.M., & Reynolds, G. W. (2006). Fundamentals of information systems. (3rd Ed.). Boston: Thompson Course Technology.
  4. The Internet Movie Database. (2009) Top 250 movies as voted by our users.
This coursework on Hierarchy of Data in the Video Store Database was written and submitted by your fellow student. You are free to use it for research and reference purposes in order to write your own paper; however, you must cite it accordingly.
Removal Request
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda.
Request the removal

Need a custom Coursework sample written from scratch by
professional specifically for you?

801 certified writers online

Cite This paper
Select a referencing style:

Reference

IvyPanda. (2022, September 9). Hierarchy of Data in the Video Store Database. https://ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/

Reference

IvyPanda. (2022, September 9). Hierarchy of Data in the Video Store Database. Retrieved from https://ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/

Work Cited

"Hierarchy of Data in the Video Store Database." IvyPanda, 9 Sept. 2022, ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/.

1. IvyPanda. "Hierarchy of Data in the Video Store Database." September 9, 2022. https://ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/.


Bibliography


IvyPanda. "Hierarchy of Data in the Video Store Database." September 9, 2022. https://ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/.

References

IvyPanda. 2022. "Hierarchy of Data in the Video Store Database." September 9, 2022. https://ivypanda.com/essays/hierarchy-of-data-in-the-video-store-database/.

References

IvyPanda. (2022) 'Hierarchy of Data in the Video Store Database'. 9 September.

Powered by CiteTotal, online essay bibliography generator
More related papers