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…
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
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
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
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…
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;
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
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
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…
DBMS
c4a
BI
BW
DML
Cloud for Analytics
Business Intelligence
Business Warehouse
Database Manipulation Language
c4a
Cloud for Analytics
BI
Business Intelligence
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
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
DBMS
File-Based Approach
Database
DBMS
Advantages of DBMS
A collection of application programs that perform services fo…
A shared collection of logically related data, and a descript…
A computer software application that interacts with the user,…
Control of Redundancy... Improved consistency... Data independence…
File-Based Approach
A collection of application programs that perform services fo…
Database
A shared collection of logically related data, and a descript…
37 terms
dbms
AGGREGATE FUNCTION
DATABASE
NORMALIZATION
FORMS OF NORMALIZATION
COUNT... MIN... MAX... SUM... AVG
COLLECTION OF ELECTRONIC DATA FILES OF AN ORGANIZATION
TECHNIQUE USED TO DESIGN TABLES TO MINIMIZE DATA REDUNDANCIES
1NF... 2NF... 3NF
AGGREGATE FUNCTION
COUNT... MIN... MAX... SUM... AVG
DATABASE
COLLECTION OF ELECTRONIC DATA FILES OF AN ORGANIZATION
DBMS
Relationship
ERD Model
Primary key
Foreign Key (FK)
An association between entities two tables sharing an attribute
consists of a collection of entities and relationships among…
an attribute that can uniquely identify each instance of an e…
An attribute which is a PK in another table
Relationship
An association between entities two tables sharing an attribute
ERD Model
consists of a collection of entities and relationships among…
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
7 terms
DBMS
Superkey
BCNF
3NF
1NF
set of attributes of a relation schema upon which all attribu…
Each attribute must be determined by a superkey
Each attribute is determined by a superkey, or it must be a m…
All attributes must be atomic
Superkey
set of attributes of a relation schema upon which all attribu…
BCNF
Each attribute must be determined by a superkey
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,…
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…
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…
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
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
DBMS
Integrity
Efficiency
Consistency
Backups
structure of database can change, by the applications using t…
Avoids redundant data and inconsistency.
Data is the same, regardless who views it.
Easy to back up data from one location
Integrity
structure of database can change, by the applications using t…
Efficiency
Avoids redundant data and inconsistency.
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 :…
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…
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…
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.
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:…
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
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
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
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…
21 terms
DBMS(Prelim_Enumeration)
<null>
<null>
<null>
<null>
Controlled access to database(5)
Database approach, data languages(2)
logically related data(3)
Views-Benefits(4)
<null>
Controlled access to database(5)
<null>
Database approach, data languages(2)
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…
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
Components of DBMS
Data Manipulation tool
DBMS Interface controls
Data Dictionary
Data Maintenance tool
Helps the user to add, change or delete information in a data…
This tool controls the flow of data between the programs that…
This helps user to create and maintain the data definitions a…
Helps users to manage the overall database environment by pro…
Data Manipulation tool
Helps the user to add, change or delete information in a data…
DBMS Interface controls
This tool controls the flow of data between the programs that…
14 terms
DBMS Terms
database security threats to avoid
ethic code
ethic code
ethic code
theft and fraud.... loss of confidentiality.... loss of privacy ... lo…
Contribute to society
avoid harm to others
be honest and trustworthy
database security threats to avoid
theft and fraud.... loss of confidentiality.... loss of privacy ... lo…
ethic code
Contribute to society
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
Components of DBMS
Data Manipulation tool
DBMS Interface controls
Data Dictionary
Data Maintenance tool
Helps user to add, change, and delete information in a databa…
this tool controls the flow of data between the programs that…
this helps user to create and maintain the data definitions a…
helps users to manage the overall database environment by pro…
Data Manipulation tool
Helps user to add, change, and delete information in a databa…
DBMS Interface controls
this tool controls the flow of data between the programs that…
98 terms
DBMS Final
HAVING
WHERE Subqueries
FROM subqueries
SELECT argument order
specifies an aggregate condition (WHERE cannot handle it)
Queries: IN/NOT IN, ANY/ALL, EXISTS/NOT EXISTS/UNIQUE... SELECT…
SELECT attrs FROM (SELECT attrs FROM ...) AS name;... find the…
SELECT FROM WHERE GROUP BY HAVING ORDER BY
HAVING
specifies an aggregate condition (WHERE cannot handle it)
WHERE Subqueries
Queries: IN/NOT IN, ANY/ALL, EXISTS/NOT EXISTS/UNIQUE... SELECT…
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…
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
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
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
DBMS Final
Syntax for joining multi-table queries
SELECT
FROM
WHERE
Use IN and EXISTS operators to query multiple tables
List all columns you want to display
List all tables involved in the query
Condition that restricts the data to be retrieved only to tho…
Syntax for joining multi-table queries
Use IN and EXISTS operators to query multiple tables
SELECT
List all columns you want to display
1 of 10