How can we help?

You can also find more resources in our Help Center.

Study sets matching "dbms"

Study sets
Classes
Users

Study sets matching "dbms"

15 terms
DBMS
Relationship
Primary key
Foreign Key (FK)
Composite Key
An association between entities two tables sharing an attribute
an attribute that can uniquely identify each instance of an e…
An attribute which is a PK in another table
More than one column used to create a unique identifier
Relationship
An association between entities two tables sharing an attribute
Primary key
an attribute that can uniquely identify each instance of an e…
52 terms
DBMS
Relationship
ERD Model
Data Dictionary
Primary key
An association between entities two tables sharing an attribute
consists of a collection of entities and relationships among…
example... TABLE NAME TABLE DESCRIPTION # OF ATTRIBUTES... TABLE N…
an attribute that can uniquely identify each instance of an e…
Relationship
An association between entities two tables sharing an attribute
ERD Model
consists of a collection of entities and relationships among…
48 terms
dbms
What is SQL, and why is it important?
Write an SQL SELECT statement to displ…
Name and briefly describe the five SQL…
Write an SQL SELECT statement to count…
SQL stands for Structured Query Language, and is the most imp…
SELECT * ... FROM STUDENT ... WHERE Grade >= 90;
COUNT: computes the number of rows in a table. ... SUM: totals n…
SELECT COUNT(*) AS NumStudents ... FROM STUDENT;
What is SQL, and why is it important?
SQL stands for Structured Query Language, and is the most imp…
Write an SQL SELECT statement to displ…
SELECT * ... FROM STUDENT ... WHERE Grade >= 90;
40 terms
DBMS
A column is a nonkey column if it is _…
A(n) ____ is a column or collection of…
An alternate key is a ____.​... Select on…
From all the ____ keys, one is chosen…
b
c
b
c
A column is a nonkey column if it is _…
b
A(n) ____ is a column or collection of…
c
13 terms
DBMS
1. Redundancy
2. Other problems associated with non…
entity
attribute
is the duplication of data or string data in more than one sp…
difficulty accessing related data and limited security
the thing you want to store and process data for
a characteristic of that entity
1. Redundancy
is the duplication of data or string data in more than one sp…
2. Other problems associated with non…
difficulty accessing related data and limited security
108 terms
DBMS
Database systems
Data
Information
Knowledge
An organization of components that define and regulate the co…
raw, unprocessed facts
processed facts that reveals meaning
data and information that are refined based on facts and beli…
Database systems
An organization of components that define and regulate the co…
Data
raw, unprocessed facts
13 terms
DBMS
1. Redundancy
2. Other problems associated with non…
entity
attribute
is the duplication of data or string data in more than one sp…
difficulty accessing related data and limited security
the thing you want to store and process data for
a characteristic of that entity
1. Redundancy
is the duplication of data or string data in more than one sp…
2. Other problems associated with non…
difficulty accessing related data and limited security
67 terms
DBMS
Database
Database Management System or DBMS
database management system
Administrators
collection of related data and data is a collection of facts…
refers to the technology of storing and retrieving users' dat…
stores data in such a way that it becomes easier to retrieve,…
maintain the DBMS and are responsible for administrating the…
Database
collection of related data and data is a collection of facts…
Database Management System or DBMS
refers to the technology of storing and retrieving users' dat…
20 terms
DBMS
c4a
BI
BW
DML
Cloud for Analytics
Business Intelligence
Business Warehouse
Database Manipulation Language
c4a
Cloud for Analytics
BI
Business Intelligence
48 terms
dbms
What is SQL, and why is it important?
Write an SQL SELECT statement to displ…
Name and briefly describe the five SQL…
Write an SQL SELECT statement to count…
SQL stands for Structured Query Language, and is the most imp…
SELECT * ... FROM STUDENT ... WHERE Grade >= 90;
COUNT: computes the number of rows in a table. ... SUM: totals n…
SELECT COUNT(*) AS NumStudents ... FROM STUDENT;
What is SQL, and why is it important?
SQL stands for Structured Query Language, and is the most imp…
Write an SQL SELECT statement to displ…
SELECT * ... FROM STUDENT ... WHERE Grade >= 90;
DBMS
A ____ is a set of field values for a…
Viewing and printing options for forms…
Data in Date/Time fields are automatic…
To design a form using the Form Wizard…
Detail Record
PRINT PREVIEW
Right
CREATE
A ____ is a set of field values for a…
Detail Record
Viewing and printing options for forms…
PRINT PREVIEW
122 terms
DBMS
HTML stands for
Does HTML require an hmtl or htm exten…
Do HTML tags always come in pair?
Are HTML tags case sensitive?
Hyper Text Markup Language
Yes
No
No
HTML stands for
Hyper Text Markup Language
Does HTML require an hmtl or htm exten…
Yes
25 terms
DBMS
1. Redundancy.
2. Other problems associated with non…
entity
attribute
is the duplication of data or string data in more than one sp…
difficulty accessing related data and limited security
the thing you want to store and process data for
a characteristic of that entity
1. Redundancy.
is the duplication of data or string data in more than one sp…
2. Other problems associated with non…
difficulty accessing related data and limited security
39 terms
DBMS
What is a DBMS
What is a database
Characteristics of Database Approch
Actors in Database environment
Database Management Systems are the software that provides us…
Collection of data... logically connected... Multiple Users
Sharing , Consistency , Security , Integration , data control
Hardware , Software (with Application Software) , People(User…
What is a DBMS
Database Management Systems are the software that provides us…
What is a database
Collection of data... logically connected... Multiple Users
27 terms
DBMS
SQL
RDBMS
1970
1974
Computer language for storing and manipulating
Basis for SQL / dbms that based on relational model
Dr. E.F Ted (father of RDBMS)
SQL appeared
SQL
Computer language for storing and manipulating
RDBMS
Basis for SQL / dbms that based on relational model
10 terms
DBMS
Database
Data warehouse
Database management system
High level or conceptual model
Collection of related data
A larger database storing historical data. Used for analysing
Set of programs software to define construct and manipulate d…
For naive people. ER modelling
Database
Collection of related data
Data warehouse
A larger database storing historical data. Used for analysing
15 terms
DBMS
Tables (DBMS tool)
Linking tables (DBMS tool)
Data types (DBMS tool)
Forms (DBMS tool)
These are the structures where data is stored
Relational databases are linked together. The primary key of…
Each field has a specified data type which makes it easier fo…
These provide a user friendly method of inputting or selectin…
Tables (DBMS tool)
These are the structures where data is stored
Linking tables (DBMS tool)
Relational databases are linked together. The primary key of…
12 terms
DBMS
In the ANSI-SPARC three-level architec…
In the ANSI-SPARC three level architec…
In the ANSI-SPARC three-level architec…
Logical data independence is the immun…
F - that would be the conceptual level, the external level is…
F - it describes what data is stored in DB and relationships…
T
F - logical data independence is the immunity of external
In the ANSI-SPARC three-level architec…
F - that would be the conceptual level, the external level is…
In the ANSI-SPARC three level architec…
F - it describes what data is stored in DB and relationships…
18 terms
DBMS
Database
Metadata
Index
ANSI-SPARC Schema Model
Integrated, self-describing & related data.... Software manipula…
Data about the data.... ex. data type, field size, primary key,…
Allows database to access a record without having to search t…
1. External view: how data is presented to users; different f…
Database
Integrated, self-describing & related data.... Software manipula…
Metadata
Data about the data.... ex. data type, field size, primary key,…
61 terms
DBMS
picture
picture
naive users, application programmers,…
recover the database contents to a sta…
key components of dbms
how they connect to each other
what type users
what is recovery
picture
key components of dbms
picture
how they connect to each other
10 terms
DBMS
ALTER
UPDATE
DELETE
INSERT
ALTER TABLE EMPLOYEE... ADD SEX VARCHAR(1)... OR... ALTER TABLE EMPLOY…
UPDATE EMPLOYEE... SET SEX='M'... WHERE FNAME='JONES'... OR... UPDATE EMP…
DELETE FROM COURSE... WHERE UNITS>3... AND DEPATMENT_ID='0001'
INSERT INTO DEPARTMENT (DNAME, DNO)... VALUES ('ACCOUNTING', '1')
ALTER
ALTER TABLE EMPLOYEE... ADD SEX VARCHAR(1)... OR... ALTER TABLE EMPLOY…
UPDATE
UPDATE EMPLOYEE... SET SEX='M'... WHERE FNAME='JONES'... OR... UPDATE EMP…
8 terms
DBMS
What is a DBMS?
What does DBMS stand for?
Where is data stored in a DBMS?
What does a DBMS allow?
A DBMS is a tool to store, edit and organise data in a…
DBMS stands for Database Management System
In a DBMS data is stored in one central location.
A DBMS allows data to be shared by many users
What is a DBMS?
A DBMS is a tool to store, edit and organise data in a…
What does DBMS stand for?
DBMS stands for Database Management System
88 terms
DBM
material som abrerar snabbast (nöts ner)
mekaniska egenskaper
3 olika metoder för initiering av en p…
Iniator för de olika polymersationsmet…
glasjonomer (GPA har sämst mekaniska egenskapersv
metaller : styva, tänjbara, låg termisk expansion ... keramer :…
ljushärdande... kemiskt härdande... dualhärdande
ljus = kamferkinon eller PDD är iniatorer... kemisk = peroxid pl…
material som abrerar snabbast (nöts ner)
glasjonomer (GPA har sämst mekaniska egenskapersv
mekaniska egenskaper
metaller : styva, tänjbara, låg termisk expansion ... keramer :…
20 terms
DBM
Chen Notation
Kardinalitäten
Entität
Enitätstyp
C = Choice, Can... M = Must, Multiple
1:1 --> 1 zu 1... 1:c --> 1 zu [0 oder 1]... 1:m --> 1 zu mindesten…
Eindeutig bezeichnendes Objekt (ich)
Definiert welche Attribute(Eigenschaften) ein Objekt haben ka…
Chen Notation
C = Choice, Can... M = Must, Multiple
Kardinalitäten
1:1 --> 1 zu 1... 1:c --> 1 zu [0 oder 1]... 1:m --> 1 zu mindesten…
23 terms
DBM
Cognitive
Affective
Behavioral
Awareness
consumers engage in mental (thinking) process which lead to a…
emotional or feeling responses occur which are associated wit…
refers to undertaking actions with respect to the advertised…
tv ads, product placement, event sponsorship
Cognitive
consumers engage in mental (thinking) process which lead to a…
Affective
emotional or feeling responses occur which are associated wit…
63 terms
DBM
Vilka är de vanligast förekommande bin…
Vad keraktiseras metaller av?
Vilka meterial består en komposit av?
Vad innebär hygroskopisk spänning? Näm…
Jonbindningar
- Kan deformeras plastiskt... - Goda värmeledare ... - Styva... - Meta…
- Filler... - Initiator... - Färg... - Polymermatrix... - Accelerator... - S…
Vatten absorption som leder till expansion!... Fördel: Reducera…
Vilka är de vanligast förekommande bin…
Jonbindningar
Vad keraktiseras metaller av?
- Kan deformeras plastiskt... - Goda värmeledare ... - Styva... - Meta…
24 terms
Keyboard Keys DBMS
Is a key located on the top-left of a…
This key is used to return a cursor to…
The key that advances the cursor to th…
Togglekey that enables or disables all…
(ESC)ape
Enter
Tab
Caps Lock
Is a key located on the top-left of a…
(ESC)ape
This key is used to return a cursor to…
Enter
23 terms
DBMS Tobacco
nicotine
addictive
tar
bronchi
an addictive drug found in tobacco leaves and in all tobacco…
Capable of causing a user to develop intense cravings.
a thick, oily, dark liquid that forms when tobacco burns.
Passages through which air enters and spreads through the lun…
nicotine
an addictive drug found in tobacco leaves and in all tobacco…
addictive
Capable of causing a user to develop intense cravings.
24 terms
Introduction to DBMS
Why do we need databases?
What is the database approach?
What is decentralized data management?
What are the dangers of decentralized…
Organizations realize the importance of information to solve…
Organizations must have access to operational data that is:…
In Decentralized Database, a big database is partitioned as p…
- Redundancy... - Inconsistency... - Insecurity... - Inaccuracy... - Non-…
Why do we need databases?
Organizations realize the importance of information to solve…
What is the database approach?
Organizations must have access to operational data that is:…
DBMS Midterm
Purposes and Functions of DBMS
Three Tiered Application Design
Server
Instance
1) Create a single point of entry to and ownership of the dat…
Presentation - Logic - Storage
A computer that has the DBMS software installed
Running DBMS Program ("bcacad3" instance of Oracle running on…
Purposes and Functions of DBMS
1) Create a single point of entry to and ownership of the dat…
Three Tiered Application Design
Presentation - Logic - Storage
62 terms
DBMS Final
Relationships in a ER model are usuall…
Additional theorems. x v (x ^ z) = x,…
What is the name of an integrated coll…
What is wrong with the ER diagram havi…
Verbs
Absorption
Database
address is a non-atomic attribute
Relationships in a ER model are usuall…
Verbs
Additional theorems. x v (x ^ z) = x,…
Absorption
93 terms
DBMS final
Entities in a ER model are usually ide…
In which of the following software eng…
If X->->Y and Y->->Z-. Y is an example…
If X->->Y and W ]Z then WX->->YZ is an…
Nouns
planning
MVD transitivity
MVD augmentation
Entities in a ER model are usually ide…
Nouns
In which of the following software eng…
planning
22 terms
Digital Citizenship Vocabulary DBMS
anti-virus software
avatar
cyberbullying
flame
programs designed to protect computers from viruses, malware…
an image, photo or graphic used to represent you on the Inter…
using online tools to harass, hurt, or embarrass someone
a mean message sent of over the Internet
anti-virus software
programs designed to protect computers from viruses, malware…
avatar
an image, photo or graphic used to represent you on the Inter…
28 terms
DBMS(Prelim)
to represent data in an understandable…
Database
System catalog(Meta Data)
DBMS
purpose of data model
shared collection of logically related data, and a descriptio…
Provides description of data to enable program-data independe…
A software system that enables users to define, create, maint…
to represent data in an understandable…
purpose of data model
Database
shared collection of logically related data, and a descriptio…
14 terms
DBMS MODEL
Who developed hierarchial model
Who developed relational model
Who developed entity relational model
About data in hierarchial model?
Joined efforts of IBM and NORTHAMERICAN ROCKWELL
E.f. Codd. Known as father of relational model
Chen in 1976
The data is sorted hierarchically, either in top down or bott…
Who developed hierarchial model
Joined efforts of IBM and NORTHAMERICAN ROCKWELL
Who developed relational model
E.f. Codd. Known as father of relational model
14 terms
DBMS ANSI
end users view of the data
easy to identify specific data require…
helps ensure security constraints in t…
makes the application program developm…
external model
external model
external model
external model
end users view of the data
external model
easy to identify specific data require…
external model
21 terms
DBMS Midterm
Lock
Shared locks
Exclusive lock
WAL
A mechanism used to control access to database objects
an object can be held by two different transactions at the sa…
no other transactions hold any lock on this object
property that makes sure the log is written before it is exec…
Lock
A mechanism used to control access to database objects
Shared locks
an object can be held by two different transactions at the sa…
47 terms
DBMS Final
3 Stages of Database Development
Entity Relationship data model elements
Relationship Degree
Binary Relationships
1. Requirements Analysis Stage... 2. Component Design Stage... 3. I…
1. Entities... 2. Attributes... 3. Identifiers... 4. Relationships
Defines the number of entity types participating in the relat…
Only two entities are involved in the relationship
3 Stages of Database Development
1. Requirements Analysis Stage... 2. Component Design Stage... 3. I…
Entity Relationship data model elements
1. Entities... 2. Attributes... 3. Identifiers... 4. Relationships
231 terms
dbms final
7.) The SQL command that lets you inse…
7.) The SQL command that lets you save…
7.) The SQL command used to list the c…
7.) The SQL command that enables you t…
INSERT
COMMIT
SELECT
UPDATE
7.) The SQL command that lets you inse…
INSERT
7.) The SQL command that lets you save…
COMMIT
26 terms
Technology Vocabulary DBMS Test
Anti-virus software
IP Address
Virus
Troll
a program that finds and removes viruses from a computer
A number that uniquely identifies each computer or device con…
a harmful program that will go into a computer and prevent it…
A person who annoys or posts comments just to get a rise out…
Anti-virus software
a program that finds and removes viruses from a computer
IP Address
A number that uniquely identifies each computer or device con…
14 terms
DBMS Final
NoSQL
SAP HANA
MongoDB
MariaDB
Document-Oriented... Graph... Key-Value/Wide Column
In-memory database... Relational database... Fast... Expensive
Document-Oriented database... Easily scalable... No ER diagrams
Relational database... Binary drop in replacement for MySQL... Open…
NoSQL
Document-Oriented... Graph... Key-Value/Wide Column
SAP HANA
In-memory database... Relational database... Fast... Expensive
83 terms
DBMS Final
Data
Information
Knowledge
database approach
raw, unsummarized, unanalyzed facts. Have no context or are t…
data processed to be useful in decision making
knowing what data is needed and how to use it. Ability to cre…
emphasizes the sharing and integration of data across the ent…
Data
raw, unsummarized, unanalyzed facts. Have no context or are t…
Information
data processed to be useful in decision making
14 terms
DBMS Working with Images
crop
upload
effects
digital image
Remove a portion of a picture that you don't want.
to send a file from one computer to another through a network.
picture formatting characteristics that includes shadows, ref…
A picture in electronic form. It may be referred to as a file…
crop
Remove a portion of a picture that you don't want.
upload
to send a file from one computer to another through a network.
55 terms
DBMS CH 1
Data
Information
Data management
database
are raw facts
is the result of processing raw data to reveal its meaning. D…
is a discipline that focuses on the proper generation, storag…
is a shared, integrated... computer structure that stores a coll…
Data
are raw facts
Information
is the result of processing raw data to reveal its meaning. D…
27 terms
Chapter 5 DBMS
alternate key
Boyce-Codd normal form (BCNF)
candidate key
concatenation
a candidate key that was not chosen to be the primary key
a relation is in Boyce-Codd normal form if it is in second no…
a minimal collection of columns (Attributes) in a table on wh…
the combination of two or more rows in an operation, such a a…
alternate key
a candidate key that was not chosen to be the primary key
Boyce-Codd normal form (BCNF)
a relation is in Boyce-Codd normal form if it is in second no…
58 terms
Chapter 2 DBMS
Data Model
One to Many Relationship (1:M or 1..*)
Many to Many Relationship (M:N or ..)
One to One Relationship (1:1 or 1..1)
A relatively simple representation, usually graphically, of m…
This occurs when a parent record in one table can potentially…
Refers to a relationship between tables in a database when a…
Occurs when one parent record or field has either zero or one…
Data Model
A relatively simple representation, usually graphically, of m…
One to Many Relationship (1:M or 1..*)
This occurs when a parent record in one table can potentially…
30 terms
DBMS CH 06
Relational Algebra
Why is relational algebra closed?
Relational algebra expression
Select Operation:Symbol
Basic set of operations for relational model
The result of an operation is a new relation, which may have…
A sequence of relational algebra operations forms a relationa…
σ (sigma)
Relational Algebra
Basic set of operations for relational model
Why is relational algebra closed?
The result of an operation is a new relation, which may have…
7 terms
DBMS components
Interfaces for users
Database admin
Related systems
Manipulation language
Means by which users access databases
Responsible for DBMS management and support
A DBMS can support many related systems that provides input t…
Controls database operations including storing, retrieving, u…
Interfaces for users
Means by which users access databases
Database admin
Responsible for DBMS management and support
28 terms
DBMS(Midterm.1)
client(tier 1)
server(tier 2)
transaction processing monitors
1995
manages user interface and runs application
holds database and DBMS
program that controls data transfer between clients and serve…
three layers proposed, each potentially running on a differen…
client(tier 1)
manages user interface and runs application
server(tier 2)
holds database and DBMS
44 terms
Final Exam 3230 DBMS
When you read from and/or write to a d…
Most real-world database transactions…
A transaction is a ___________________…
To ensure consistency of the database,…
Transaction
database
logical
consistent
When you read from and/or write to a d…
Transaction
Most real-world database transactions…
database
1 of 10