UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
Components of DB System
1)Hardware (comp, storage, printers)
2)Software (OS, DBMS software, apps)
3)People (all users, admin, end users, programmers)
4)Procedures (rules, enforce standards)
5)Data (collection of facts stored)
Functions of DBMS
1) Data Dictionary management (stores definition of data elements and their relationships)
2) Data storage management (creates/ manages complex structures required for data storage)
3)Data transformation and presentation (conforms entered data for user)
4) Security management (access, items)
5)Multi user access control (ensure people can access concurrently)
6)Backup and recovery management (backup and data recovery to ensure safety/ integrity)
7)Data integrity management (DBMS promotes and enforces integrity rules, minimizing redundancy)
8)database access languages and app programming interfaces (data access through query language)
9)Database communication interfaces (accepts user requests via multiple, different network
environments)
Different types of database systems
-single user
-desktop database
-multi user database
-workgroup database
-enterprise database
-Centralized database
-distributed database
-cloud database
-general purpose database
-discipline specific database
single user D
one user at a time
desktop database
single user on personal comp
multi user D
, multiple users at a time
work group
when multiuser supports a small number of users (<50)
enterprise D
when database is used by entire org and supports >50 users
centralized D
supports data located at single site
distributed D
database that supports data across several sites
cloud D
created and maintained useing cloud services
general purpose D
contains a wide variety of data used in multiple disciplines
discipline specific D
contain data focused on subject specific area
Database model types
Hierarchical
Network
Relational
Entity relationship
object oriented
ERDM
Big data
NOSQL database
Hierarchical Model
-large amounts of data
-similar to upside down tree
-efficient/fast
-1:M
-first formal DB
Network Model
-better than hierarchical
-first model to have standards
LATEST UPDATE (ALREADY GRADED A+)
Components of DB System
1)Hardware (comp, storage, printers)
2)Software (OS, DBMS software, apps)
3)People (all users, admin, end users, programmers)
4)Procedures (rules, enforce standards)
5)Data (collection of facts stored)
Functions of DBMS
1) Data Dictionary management (stores definition of data elements and their relationships)
2) Data storage management (creates/ manages complex structures required for data storage)
3)Data transformation and presentation (conforms entered data for user)
4) Security management (access, items)
5)Multi user access control (ensure people can access concurrently)
6)Backup and recovery management (backup and data recovery to ensure safety/ integrity)
7)Data integrity management (DBMS promotes and enforces integrity rules, minimizing redundancy)
8)database access languages and app programming interfaces (data access through query language)
9)Database communication interfaces (accepts user requests via multiple, different network
environments)
Different types of database systems
-single user
-desktop database
-multi user database
-workgroup database
-enterprise database
-Centralized database
-distributed database
-cloud database
-general purpose database
-discipline specific database
single user D
one user at a time
desktop database
single user on personal comp
multi user D
, multiple users at a time
work group
when multiuser supports a small number of users (<50)
enterprise D
when database is used by entire org and supports >50 users
centralized D
supports data located at single site
distributed D
database that supports data across several sites
cloud D
created and maintained useing cloud services
general purpose D
contains a wide variety of data used in multiple disciplines
discipline specific D
contain data focused on subject specific area
Database model types
Hierarchical
Network
Relational
Entity relationship
object oriented
ERDM
Big data
NOSQL database
Hierarchical Model
-large amounts of data
-similar to upside down tree
-efficient/fast
-1:M
-first formal DB
Network Model
-better than hierarchical
-first model to have standards
