Week 8 - Relational Database
A relational database is a system used to store and organize information in a structured way. Instead of keeping everything in one long file, it separates information into tables. These tables work a lot like spreadsheets, with columns that describe the type of data, such as a name or a date, and rows that contain the actual data. What makes relational databases special is that the tables can be connected, or related, to each other. For example, one table might hold customer information, while another stores their orders, and the database links those pieces together. This approach was first introduced in 1970 by E. F. Codd, a researcher at IBM. Before that, information was often kept in flat files, which made it hard to find specific details or make connections between different pieces of data. Codd’s idea completely changed how businesses manage large amounts of information. To interact with a relational database, people use a language called SQL, or Structured Query Language. It al...