BIA 253 - Exam 2 - Gerhart - Creighton University Exam All Possible Questions and Answers with complete solution

Reasons for Learning Database Technology - Answer-1) Knowledge of whether a database will facilitate the development of a new business initiative 2) Must be able to construct information from data found in databases 3) Evaluation of a data model may be required when change is needed for a database 4) Creation of a database may be needed in the future What is the Purpose of a Database? - Answer-Keeps track of data with multiple themes What is a Database? - Answer-tables or files + relationships among rows in tables + metadata Primary Key - Answer-A column or group of columns that identify a unique row in a table Foreign Key - Answer-A key of a different table than the one in which it resides Relational Database - Answer-Databases that carry their data in the form of tables and represent relationships using foreign keys Metadata - Answer-Data that describes data What is a Database Management System (DBMS)? - Answer-A program used to create, process, and administer a database What is the Difference Between a Database Management System and a Database? - Answer-DBMS is a software program while a database is a collection of tables, relationships, and metadata Creating the Database and its Structures - Answer-Database developers use the DBMS to create tables, relationships, and other structures in the databaseProcessing the Database - Answer-DBMS provides applications for four processing operations: to read, insert, modify, or delete data Structured Query Language (SQL) - Answer-An international standard language for processing a database Database Administration - Answer-A person or department that develops procedures and practices to ensure efficient and orderly multiuser processing of the database, to control changes to database structure, and to protect the database Database Administration Development Responsibilities - Answer-1) Create and staff DBA function 2) Form steering committee 3) Specify requirements . 4) Validate data model 5) Evaluate application design