diff options
| -rw-r--r-- | assignments/1/README.md | 2 | ||||
| -rw-r--r-- | doc/01-introduction.md | 32 |
2 files changed, 34 insertions, 0 deletions
diff --git a/assignments/1/README.md b/assignments/1/README.md index aedd06c..9e83c51 100644 --- a/assignments/1/README.md +++ b/assignments/1/README.md @@ -11,11 +11,13 @@ Answer all of the following questions, and upload your completed work here. ### Question 1 (15 marks) Answer the following questions (250 words max/question). + * Explain the concept of program-data independence, and explain how it is achieved in the database approach. * Briefly contrast and compare the following development approaches: the systems development life cycle and the prototyping methodology. * Discuss the difference between entity type and entity instance. ### Question 2 (15 marks) + Give a simple example of an E-R diagram for each of the following concepts: a. Associative entity diff --git a/doc/01-introduction.md b/doc/01-introduction.md index fbf162d..e6c6c68 100644 --- a/doc/01-introduction.md +++ b/doc/01-introduction.md @@ -1,3 +1,35 @@ Chapter 1: Introduction to Databases # What is a database? + +# DBMS + +* protect +* define and control +* backups +* maintain data. enter, change and delete data +* retrieve +* Programming and GUI interface + +Example: + +customers +* id +* name +* address + +products +* id +* description +* product_finish + +orders +* id +* created_at + +line_items + +* id +* order_id +* product_id +* quantity |