Database And Database Management System

1068 Words Sep 23rd, 2016 5 Pages
Ashraf Zalgaonkir
Pearson Cape Town Campus
Introduction to Databases project
Student Number: MB2014-0413
Teacher: Andrew Davies
Due Date: 23/09/2016
2
Contents Page
Page 1…………………………………………..Cover Page
Page 2……………………………………………Contents Page
Page 3-5…………………………………………….Question 1
Page 6-12……………………………………………Optional Access Screenshots
Page 13-18………………………………………….Question 2
Page 19…………………………………………………References and Bibliography
3
Question 1
1.1)
Database
Database is defined as a set of related data in many tables and uses links through something called foreign keys. In a Database product you can create and modify several databases.
DBMS
It stands for Database Management System, it is a concept of rules that all the latest and major database systems follow. So most databases systems follow these rules but some only follow specific rules.
To summarize, a database is an organized data collection or information that happens to be easily accessible, changed or updated. A DBMS is a type of software that may manage and control databases on a PC.
1.2)
Event: Going to the doctor for a check-up.
Database Event: In going for a check-up, the secretary will first see your old computerized records on her PC. She will thus update the record as I go for the
4
check-up. The doctor may check the database records to show him what illnesses or medical problems the patient has been through the previous time the patient went to the doctor. The computerized records will have information such as:
Previous date…
Open Document