QUESTION: Review the bolded terms below and their definitions. Explain these concepts in your own words. Next, think about how you would apply a relational data structure in your current or potential work environment or industry, and explain how this type of structure would be useful. Lastly, using the terminology in this section and general information on the subject, provide an example of a relational database you would be interested in creating.
The two terms selected are: relation and normalization
The technical definitions of these terms are quoted below for reference. Please summarize the concepts.
In a relational database, a relation is a table with columns and rows. Relations are used to hold the data about the objects in the database.
Normalization is the process of organizing a relational database into tables so that the database contains a set of relations with the desired attributes. Normalization may reduce the duplication of data items within the database and often results in the creation of additional tables.
If helpful, Current work environment/role: defense industry data management analyst
