WVU Bcor 330 exam #2 / Verified and
100% correct/ A+ Graded.
database management system differs from a tradition file system
in that a database management system - --can centralize data
-database application - -is a collection of forms, reports, queries
and programs that processes a database.
-true of the components of an entity(object)-relationship data
model? - --attributes describe the characteristics of entities
-database - -is a collection of data organized to serve many
applications efficiently by centralizing the data and controlling
redundant (unnecessary) data
-keeping track of data is the primary reason
-metadata - --describes the structure of a database
-tables that are not normalized will likely have problems related
to... - -data integrity (problems)
-incorrect or inconsistent information
-users lose confidence information
-system gets a poor reputation
-can only occur if data are duplicated
-reports - --can be used to compute values as they present data
-structured presentation of data using sorting, grouping, filtering,
and other operations
-forms - -views data, insert new, update existing, delete existing
data
provides security, data consistency, special purpose processing
ex. handle out of stock situations
, -steps required in transforming a data model into a relationship
database- - --normalize tables as necessary so easy has one
theme.
-represent each entity with a table
-represent relationships
-primary key: - --a column or group of columns that identifies a
UNIQUE row in a table
-Query
structured query lanaguage-SQL - -- is a request that is executed
to retrieve data from a database, makes databases more useful
by search using values provided by user.
-international standard
-used by nearly all DBMS
ex. insert into student! ([Student Number], [Student Name], HW1,
HW2, MidTerm)
VALUES (1000, 'Franklin, Benjamin', 90, 95, 100);
-Important action to ensure mistakes aren't made in the
development of database- - -perform user reviews
-an advantage of database management systems (DBMS) over
traditional file system? - --a DBMS uncouples programs and data,
enables (allows) data to stand on its own
-program to create, process, administer a database
-licensed from vendors: IBM, Microsoft, Oracle, and others
-DB2, Access, SQL Server, Oracle Database
Open source: MySQL- license-free form most applications
-DBMS Process Operations - -1.Read
2.insert
3.modify
100% correct/ A+ Graded.
database management system differs from a tradition file system
in that a database management system - --can centralize data
-database application - -is a collection of forms, reports, queries
and programs that processes a database.
-true of the components of an entity(object)-relationship data
model? - --attributes describe the characteristics of entities
-database - -is a collection of data organized to serve many
applications efficiently by centralizing the data and controlling
redundant (unnecessary) data
-keeping track of data is the primary reason
-metadata - --describes the structure of a database
-tables that are not normalized will likely have problems related
to... - -data integrity (problems)
-incorrect or inconsistent information
-users lose confidence information
-system gets a poor reputation
-can only occur if data are duplicated
-reports - --can be used to compute values as they present data
-structured presentation of data using sorting, grouping, filtering,
and other operations
-forms - -views data, insert new, update existing, delete existing
data
provides security, data consistency, special purpose processing
ex. handle out of stock situations
, -steps required in transforming a data model into a relationship
database- - --normalize tables as necessary so easy has one
theme.
-represent each entity with a table
-represent relationships
-primary key: - --a column or group of columns that identifies a
UNIQUE row in a table
-Query
structured query lanaguage-SQL - -- is a request that is executed
to retrieve data from a database, makes databases more useful
by search using values provided by user.
-international standard
-used by nearly all DBMS
ex. insert into student! ([Student Number], [Student Name], HW1,
HW2, MidTerm)
VALUES (1000, 'Franklin, Benjamin', 90, 95, 100);
-Important action to ensure mistakes aren't made in the
development of database- - -perform user reviews
-an advantage of database management systems (DBMS) over
traditional file system? - --a DBMS uncouples programs and data,
enables (allows) data to stand on its own
-program to create, process, administer a database
-licensed from vendors: IBM, Microsoft, Oracle, and others
-DB2, Access, SQL Server, Oracle Database
Open source: MySQL- license-free form most applications
-DBMS Process Operations - -1.Read
2.insert
3.modify
