Write about your understanding of database. Explore the database advantages and write about database concepts such as primary and foreign keys

 


Database:

A database is a place where collections of information that can stored and accessed by users. Furthermore, it can be accessed by many users. Moreover, it can be spread out to many locations (Beri, et al, 1989).

What is a Database from my understanding:
A database is a place where information is stored. Furthermore, it can control who accesses and edits the data. In other words, it is like a library for data.



Advantages of Database:
  • Increases the amount of users that can access the data.
  • Boosting data security.
  • Helps organisation to spot errors and bugs.
  • Controls who can access and store that data.
  • Helps in decreasing data redundancy.
  • Structures the data

Database Concepts:

-Primary key: is a key that contains a value. In addition, value must be the same and unique across the table. Beside that, this key can placed in multiple columns in a table (Sir, et al, 2015).

-Foreign key: this key is used to connect the tables. Furthermore, the values of should match of those found in a different table (Sir, et al, 2015).
Reference List:

Beeri, C., Bernstein, P.A. and Goodman, N., 1989. A sophisticate's introduction to database normalization theory. In Readings in artificial intelligence and databases (pp. 468-479). Morgan Kaufmann. Available at: https://doi.org/10.1016/B978-0-934613-53-8.50004-2 [Last Accessed 15 February 2023]

Sahana. (2022) Advantages and Disadvantages of Database. Available at: Advantages and Disadvantages of Database - Tech Quintal (Accessed: 15 February 2023).

Sir, M. Bradac, Z. and Feidler, P. (2015) 'Ontology versus Database ', IFAC-PapersOnLine ,48(4), pp. 220-225. Available at: https://doi.org/10.1016/j.ifacol.2015.07.036 [Last Accessed 15 February 2023]





Comments

Post a Comment

Popular posts from this blog

Invention of WWW and E-commerce

Image
  Invention of WWW and E-commerc e Tim Berners-Lee, 41, is the person who invented the World Wide Web. Which means he is the creator of WWW. Tim Berners-Lee has stated that he developed some software to keep track of his “memory” since he said he is neither good at names nor faces. So he created it as a “memory substitute”. For this reason, technology has advanced increasingly. He is the reason that we can look at a photo online and click on it to find out the photographer’s name. ( Wright, R., 1997) Michael Aldrich is the person who created e-commerce. Moreover, 1995 was the year when e-commerce started growing. Furthermore, the internet and the web were the main factors that helped e-commerce grow ( Laudon and Traver., 2013).  Even though e-commerce has become more popular over the last decade, it has been around for over 30 years. Furthermore, the  idea of e-commerce is associated with notions of the internet economy and digital economy. In addition, all these concepts...
Read more

Analyse and compare different examples of product pages

Image
Introduction: In this blog I will be analysing and comparing different product pages from websites. I have also chosen websites that sell clothes since I am creating a similar website.    White Fox boutique: This product page is quite simple. Both the description and image are available and in good quality. And the description is short and simple. Also, you can easily navigate your way through the pages. Furthermore, this website has different categories. In addition, you can see the prices of the products and the different colours that are available. Overall, this is a good product page and very straightforward. ZARA: Although Zara's homepage appears attractive, many people complained that shopping and browsing the website were difficult. First of all, the size of the description is small. Furthermore, it can be a bit challenging to find what you are looking for. Also, it seems to appear that they are cramming several product images in one row. On the other hand, the colours ...
Read more

Essentials features of an e-commerce website

Image
                    What features should I use for my website?                  _______________________________________________________ The sources that I have used to write this blog all agreed that there are some points that developers must do in order to get a number of satisfied customers. For instance , many e-commerce website creators spend an amount of time in these unnecessary and irrelevant features. These include, use of frames , consistency , cohesion , and amount of advertisement   ( Udo, G.J. and Marquis, G.P., 2002.   42 (2), pp.10-16.) .  These four elements might not satisfy customers and have a rather negative affect on your website.  On the other hand, according to   Udo, Godwin J., and Gerald P. Marquis   focusing your attention on the download time can have a noticeable increase in your ranking. It can also be considered the most beneficial an...
Read more