LEARNING UNIT 5: CHAPTER 9
, DATABASE SCHEMA
Organization of individual stored data items into higher level groups, such as tables.
Associations among tables or classes
Details of physical data store organization, including types, lengths, locations, and indexing
of data items
Access and content controls, including allowable values for specific data items, value
dependencies among multiple data items, and lists of users allowed to read or update data
items
CHARACTERISTICS OF A DBMS
Simultaneous access by many users and many applications
Direct access to data with a data interface
Uniform and consistent access
Integration and distribution of data across multiple servers
DA AND DBA RESPONSIBILITES
WHAT IS A RELATIONAL DATABASE?
PARTIAL DISPLAY OF A RELATIONAL DATABASE TABLE
, DATABASE SCHEMA
Organization of individual stored data items into higher level groups, such as tables.
Associations among tables or classes
Details of physical data store organization, including types, lengths, locations, and indexing
of data items
Access and content controls, including allowable values for specific data items, value
dependencies among multiple data items, and lists of users allowed to read or update data
items
CHARACTERISTICS OF A DBMS
Simultaneous access by many users and many applications
Direct access to data with a data interface
Uniform and consistent access
Integration and distribution of data across multiple servers
DA AND DBA RESPONSIBILITES
WHAT IS A RELATIONAL DATABASE?
PARTIAL DISPLAY OF A RELATIONAL DATABASE TABLE