Database Management Flashcards
What is DBMS
Database Management Software
What are the advantages of DBMS (9)
Data Sharing
Data Independence
Better Data integrity
Controlled Redundancy
Data consistency
Data Security
Faster Application Development
Concurrency Control
Recovery and Backup
What are 6 examples of DBMS
Microsoft SQL server
Oracle
Microsoft Access
BlackFish
PostgreSQL
MySQL
What are the 2 factors that determine whether you will need a desktop or server-based database
Size
Accessibility
What is a single-user database
A standalone application that runs on your computer and only supports one user at a time E.g. Microsoft Access
What is a distributed database
A database that runs on a server first so multiple users can connect to it. Resources allocated to the database are being shared amongst all the users connected to it at any instance
What is the most common example of a distributed database
Databases that run on the cloud
Why are databases that run on the cloud powerful
Can be expanded easily and make use of the power and bandwidth provided by multiple computers.
What is an example of a distributed database
Amazon Web Services
What are 4 examples of database careers
Database Administrator
Database Programmer
Database Analyst
Database Project Manager
What is a database administrator
Primary person involved in managing the data of a company or program
What is a database programmer
Any employee whose primary job is to create databases and database queries
What is a database analyst
Responsible for working with companies to identify opportunities to set up and improve their data systems
What is a database project manager
The person who must make sure that any database projects are completed on time
