Skip to main content

Databases, primary and foreign keys.

According to Oppel (2011), database is like a big digital file cabinet that stores information that can be easily accessed, managed, and updated. It helps organize data and makes it easier to find and use. Importand part of databases is establishing relationships between data, thats where primary and foreign keys come in:

  • A primary key is a unique code for each record in a table, helping to identify and work with it easily.
  • A foreign key is a code that links one table to another. It's usually a field in one table that matches the primary key in another table, ensuring that data is consistent between them.

They ensure that information is consistent across different parts of the database, which is important for making sure everything works smoothly. For example, in a customer database, each customer might have a unique ID number, and that number would be used to connect all of the information about that customer together. Overall, databases and keys help people manage information in a more efficient and effective way.

References:

Oppel, A.J. (2011). Databases Demystified. New York: McGraw-Hill.

Comments

Post a Comment

Popular posts from this blog

Welcome post

Hello I am Simas, a 28-year-old computing enthusiast from Lithuania and I am passionate about gaming and have a keen interest in the newest tech. Growing up, I spent countless hours playing my favorite games, and this passion has only grown stronger as I gotten older. I love exploring the latest gaming technology, from cutting-edge graphics cards and high-performance processors to the newest gaming peripherals like VR headsetes, consoles and such. Outside of gaming, I am always on the lookout for the latest tech trends, whether it's the newest smartphones or the latest gadgets and gizmos. I am eager to stay ahead of the curve and be at the forefront of the tech world, constantly exploring new possibilities and opportunities.
Post a Comment
Read more

ERD definition

 According to Li and Chen (2009), ERD is a diagram that shows how different things in a database relate to each other.These terms are related to ERD: Entities are the things being modeled, like customers or products.  Attributes are the characteristics of an entity, like its name or size.  Cardinalities show how many of one thing are related to another, like one-to-many or many-to-many.  Relationships show how entities are connected, and can be one-to-one, one-to-many, or many-to-many. ERDs are helpful for designing and building a database that meets the needs of a business or organization. References:  Li, Q. and Chen, Y.L., 2009. Entity-relationship diagram. In Modeling and analysis of enterprise and information systems (pp. 125-139). Springer, Berlin, Heidelberg.
Post a Comment
Read more

Webpage design and programming language

Here are some of the common computing definitions: Cookies are small text files that are stored on a user's computer or mobile device when they visit a website. They are designed to hold a small amount of data that can be retrieved by the website or a third-party server (Park, 2000).  User interface (UI) refers to the visual, interactive, and functional elements of a software application, website, or other digital product that enable users to interact with it. A well-designed UI should be intuitive and easy to use, enabling users to navigate the product and perform tasks with minimal effort and without confusion (Kay, 1990). Page source refers to the underlying code of a web page, including HTML, CSS, and JavaScript. It can be viewed by users to inspect and modify the code of a web page, and is interpreted by web browsers to display the content of a website (Conesa-Fuentes, et. al., 2013). Meta tags are snippets of code that provide information about a web page, but are not display...
Post a Comment
Read more