WVU BCOR 330 EXAM #2 QUESTIONS AND ANSWERS
Database management system differs from a tradition file system in that a database
management system - Answers --can centralize data
Database application - Answers -is a collection of forms, reports, queries and programs
that processes a database.
True of the components of an entity(object)-relationship data model? - Answers --
attributes describe the characteristics of entities
Database - Answers -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 - Answers --describes the structure of a database
Tables that are not normalized will likely have problems related to... - Answers -data
integrity (problems)
-incorrect or inconsistent information
-users lose confidence information
-system gets a poor reputation
-can only occur if data are duplicated
Reports - Answers --can be used to compute values as they present data
-structured presentation of data using sorting, grouping, filtering, and other operations
Forms - Answers -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- - Answers --
normalize tables as necessary so easy has one theme.
-represent each entity with a table
-represent relationships
Primary key: - Answers --a column or group of columns that identifies a UNIQUE row in
a table
Query
, Structured query lanaguage-SQL - Answers -- 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- -
Answers -perform user reviews
An advantage of database management systems (DBMS) over traditional file system? -
Answers --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 - Answers -1.Read
2.insert
3.modify
4.delete dare
Administering the database - Answers --set up security system, user accounts,
passwords, permission limits users permissions
-back up database improve performance of database application, remove unwanted
data.
Accurate description of the DATA MODEL - Answers --it is a logical representation of
the data in a database that describes the data and relationships that will be stored in the
database
In a database = - Answers -bytes are groups into COLUMNS
Bytes or characters
Rows or records (vertical)
Colums or fields (horizontal)
Table or file
Key - Answers -- a column or group of columns that identities a UNIQUE row in a table.
Database management system differs from a tradition file system in that a database
management system - Answers --can centralize data
Database application - Answers -is a collection of forms, reports, queries and programs
that processes a database.
True of the components of an entity(object)-relationship data model? - Answers --
attributes describe the characteristics of entities
Database - Answers -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 - Answers --describes the structure of a database
Tables that are not normalized will likely have problems related to... - Answers -data
integrity (problems)
-incorrect or inconsistent information
-users lose confidence information
-system gets a poor reputation
-can only occur if data are duplicated
Reports - Answers --can be used to compute values as they present data
-structured presentation of data using sorting, grouping, filtering, and other operations
Forms - Answers -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- - Answers --
normalize tables as necessary so easy has one theme.
-represent each entity with a table
-represent relationships
Primary key: - Answers --a column or group of columns that identifies a UNIQUE row in
a table
Query
, Structured query lanaguage-SQL - Answers -- 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- -
Answers -perform user reviews
An advantage of database management systems (DBMS) over traditional file system? -
Answers --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 - Answers -1.Read
2.insert
3.modify
4.delete dare
Administering the database - Answers --set up security system, user accounts,
passwords, permission limits users permissions
-back up database improve performance of database application, remove unwanted
data.
Accurate description of the DATA MODEL - Answers --it is a logical representation of
the data in a database that describes the data and relationships that will be stored in the
database
In a database = - Answers -bytes are groups into COLUMNS
Bytes or characters
Rows or records (vertical)
Colums or fields (horizontal)
Table or file
Key - Answers -- a column or group of columns that identities a UNIQUE row in a table.
