def create_an_order():
with open('users_database.csv', 'w+'):
...
with open('orders_database.csv', 'w+'):
...
# users_database.csv
username, password, age
Alex, strongstrongpass123, 23
Bogi, nosostrongpass, 21
...
# orders_database.csv
order_no, client, price
1234, Alex, 20.00
...
"A database is an organized collection of data, generally stored and accessed electronically from .... "
At the end it's just a file in the filesystem :)
The software we use to interact with the database.
Examples:
Natural and "Surogate" (syntetic)
A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table.
In other words: A way to make a relation between tables.