Database Management Flashcards
Database
Organized collection of related data
Database management system
Software application that manages the database and controls access to the data stored in the data base
Database administrator
Person who is responsible for developing and managing the organizations database
Table
Data base date is stored here. A collection of data about specific topic
Primary key
Field that uniquely identifies each record
Foreign key
An attribute that is common in both of the entities in a relationship which is the primary key of one entity that. Ingrates to the other entity to Connect those entities
E-R diagram
Most common technique for data modeling consists of entities attributes and relationships
Entity
Person place event or thing where we collect data
Attributes
Each entity has certain characteristics known as attributes
Relationship
Describe associations between two or more entities
Querying data
Retrieve and display data from a database we use query
Structured query language
Most common query language
Query by example
Using templates instead of query language
