62.3k views
1 vote
Imagine you work for the public housing agency of a city, and you have been charged with keeping track of who is living in the agency's developments over time. To help you in this task, you have decided to use a relational database for your record keeping. Your task is to design a database that allows you to capture the facts described below:

1 Answer

3 votes

In this question, we are missing some of the information that is necessary in order to answer this question properly. However, we can look at what a relational database is in order to help you answer the question on your own.

A relational database is a set of tables from which data can be accessed. This can take place even without the need to reorganize the database tables. The programming interface of a relational database is the Structured Query Language (SQL). This approach was invented by E. F. Codd, who came up with it in 1970 while he was a programmer at IBM.