Best definition : stores both data + relationships between the data. Provides a query language : series of non-programming-level commands for non-technical users to generate reports and retrieve information.
Physical view : how information is physically stored on your hardrive. Logical view : how they access information (english language)
Is it modular? Can it be adapted to increasing demands?
How quickly can you erfom a certain transaction?
Passwords, Access levels. Certain ppl can accesscertain things. Access control. Read-only for ex.
creates, maintains the data dictionary and the structure of the database.
Data dictionary, Variable names, Each field has a name., Business rule, Validation rule, Duplicate, Keys, Foreign key, Primary key
Allows to create, update, read and delete information in a database.
Structured query language
relationship : 1 customer can have many orders, but one order belongs only to one customer.
students and classes many students can have one class and many classes can have students
mayor-city for ex. married to one -- recursive relationship.