Database Management Systems Lecture Notes
Studied by 0 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/9
Earn XP
Description and Tags
These flashcards encompass key terms and definitions related to Database Management Systems as covered in the lecture.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
10 Terms
Database Management System (DBMS)
A program used to create, process, and administer a database.
SQL
Structured Query Language, used to perform operations on databases.
Entity
Something the user wants to track, always singular (e.g., Order).
Attributes
Characteristics that describe an entity, e.g., Order_Number.
Primary Key
An attribute associated with one and only one entity, uniquely identifying it.
Cardinality
A term used to describe the relationships between entities, indicating maximum numbers.
Crows Feet
A notation used to represent multiple relationships in an Entity Relationship Model.
Enterprise DBMS
A type of DBMS that processes large organizational databases and supports many users.
Personal DBMS
A type of DBMS designed for smaller, simpler database applications.
Backup/Recovery
Functions provided by a DBMS to secure and restore databases.
Note 
Flashcards (72)