UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+)

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
components of a DB System (Database System) (4)

hardware, software, data, procedure, and database access language.

Functions Of DBMS (Database management system)

data dictionary management, data integrity management, data storage management, data security
management

Types of Database Systems (location and # of users)

- Centralized database.
- Distributed database - near its greatest demand - Enterprise database - more than 50 users
- Work group database - less than 50 users
End-user database.
Commercial database.
Operational database.
Relational database.
Object-oriented database.
Graph database.

Relational Database

(most used model today) A relational database consists of multiple tables that relate to each other. The
relation between tables is formed in the sense of shared columns

Object Oriented database

is a database system that can work with complex data objects — that is, objects that mirror those used
in object-oriented programming languages.

Network Database

(standards were first introduced) A database organized according to ownership of records, allowing
records to have multiple owners and thus providing multiple access paths to the data

Hierarchical database

a set of data items that are related to each other by hierarchical relationships. Hierarchical relationships
exist where one item of data is the parent of another item.

Database Models