Familiar with the structure of DB and DBMS

System analysts: Determine requirements of end users

What is the first phase of the Database Development Life Cycle?

Which phase of the Database Development Life Cycle focuses on identifying the requirements and constraints of the database system?

Data design involves

Implementation doesn't involves

A major purpose of a database system is to provide users with an abstract view of the data.

Conceptual View

External View

For the system to be usable, it must not retrieve data efficiently

describes what data are stored in the database, and what relationships exist among those data

The highest level of abstraction describes only part of the entire database

The lowest level of abstraction describes how the data are actually stored

describes the entire database in terms of a small number of relatively simple structures

ANSI: American National Standards Institute

Change to internal level shouldn’t affect the conceptual level

The overall design of the database is called the database instance

The collection of information stored in the database at a particular moment is called … of the database

A database system is a collection of interrelated data and a set of programs that prevent users to access and modify these data.

Specified during the database design process