How is data structured in a simple database?

Answer 1

Columns and rows... multiple tables are related by keys (creating a unique per-row ID number in the parent table, and referencing that ID number in the child tables)

Answer 2

Hello,

(ANS) Databases can be as simple or complex as required. If you think about it, a database is just a collection of information. But what counts is how that information is structured and what kind or form of container you use to hold that information.

**A Book or a diary could be thought of as a database of a kind?

**A simple database might just contain a single column of data and that data might just be held in a single flat file. Nothing at all complicated.

**Databases can become far more complex and thus more interesting as a subject in its own right when database tables are linked into relationships. i.e. for example a simple medical database would link table A (patient name & address, postcode, telephone number, NHS number,etc) to table B (patient symptoms, current drug treatments, any allergic reactions, last or previous operations,etc,etc.) If either of these two tables (table A + B) were not linked then the data is pretty meaningless and has no value. The data in this database is only of value and only has meaning by being related to each other. A+B makes the data valuable and could even be life saving in an extreme situation.

IR

Answer 3

The simplest form is a flat database, an example would be filling a text file with data (a csv, comma separated file). There are no relational links to anything, it's just purely data setup in columns and rows. Most databases are relational however, meaning that there are multiple tables and they can (they don't have to be) linked together by primary and foreign keys.

Answer 4

One to One (relationship Parent)
One to Many (Parent Child)