CS 550 Lecture 1 Questions Answered Correctly!!

CS 550 Lecture 1 Questions Answered
Correctly!!
Database CORRECT ANSWERS A large, integrated collection of data. Data integrity is
a concern. Real world enterprise is modeled through entities and relationships

Entities Examples CORRECT ANSWERS eg. students, courses, teachers, admin

Relationships Examples CORRECT ANSWERS Frodois (student) taking INFS614
(course)

Database Management System (DBMS) CORRECT ANSWERS a software package
used to create, provide access, and administer a database

Why Use a DBMS? CORRECT ANSWERS - Data independence and efficient access.
- Reduced application development time.
- Data integrity and security.
- Uniform data administration.
- Concurrent access, recovery from crashes.

Levels of Abstraction CORRECT ANSWERS Many views, single conceptual/logical
schema and physical schema

Views CORRECT ANSWERS Describe how users see the data

Conceptual Schema CORRECT ANSWERS Defines a logical structure

Physical Schema CORRECT ANSWERS Describes files and indexes used

Data Dependence CORRECT ANSWERS Applications are insulated from how data is
structured and stored

Logical Data Independence CORRECT ANSWERS Protection from changes in logical
structure of data

Physical Data Independence CORRECT ANSWERS Protection from changes in
physical structure of data

Transaction CORRECT ANSWERS Execution of a Database program, an atomic
sequence of database actions (R/W)

ACID Properties CORRECT ANSWERS Atomicity
Consistency
Isolation