DBMS

0.0(0)
Studied by 0 people
linked notesNote
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/28

encourage image

There's no tags or description

Looks like no tags are added yet.

29 Terms

1
New cards
Database
An organized collection of inter-related data that ensures safety, security, and integrity of data.
2
New cards
DBMS
Software that provides essential services to create, maintain, and manage the database.
3
New cards
Advantages of DBMS
Control of data redundancy, data consistency, data sharing, privacy and security, backup and recovery, and enforced standards.
4
New cards
Relational Database
Data organized as tables.
5
New cards
Entity
A distinct object in a database that is represented as a table.
6
New cards
Attribute
Columns in a table that define properties of an entity.
7
New cards
Tuple
A row in a database table that represents a single record.
8
New cards
Relation
Another term for a table in a relational database.
9
New cards
Domain
The pool of data from which original data is collected.
10
New cards
Cardinality
The number of rows in a table.
11
New cards
Degree
The number of columns in a table.
12
New cards
Relational Database Management System (RDBMS)
Software that provides essential tools to create, manage, and maintain data in the form of tables.
13
New cards
Primary Key
An attribute or a set of attributes that uniquely identifies a tuple or row in a table.
14
New cards
Candidate Key
Attributes that can be selected as the primary key.
15
New cards
Alternate Key
A candidate key that is not selected as the primary key.
16
New cards
Foreign Key
An attribute of a table that is the primary key of another table.
17
New cards
Parent Table
The table that contains the primary key.
18
New cards
Child Table
The table that contains the foreign key referencing the primary key of the parent table.
19
New cards
SQL (Structured Query Language)
A language used to access and manipulate databases.
20
New cards
MySQL
A popular open-source relational database management system.
21
New cards
Data Types: Numeric
Data types that represent numbers, including integers and decimals.
22
New cards
Integer
A numeric data type that can be positive or negative.
23
New cards
Numeric[Number(x,y)]
A numeric data type where 'x' indicates total digits and 'y' indicates decimal places.
24
New cards
Decimal
A data type for numbers with fixed decimal points.
25
New cards
Non-Numeric Data Types
Includes char(x) for fixed length, varchar(x) for variable length, date, and datetime formats.
26
New cards
char(x)
A fixed-length character data type.
27
New cards
varchar(x)
A variable-length character data type.
28
New cards
Date Format
A date representation in 'yyyy-mm-dd' format.
29
New cards
Datetime Format
A datetime representation in 'yyyy-mm-dd hh:mm:ss' format.