Quiz 1.3 Flashcards
- What is the informal or general definition of a database?
Collection of related data (facts about the real world)
- Give a more formal definition of a database (include the three key implicit properties we discussed in class)?
- Logically Coherent.
- My database needs to have a purpose.
- Representative of the real world.
- What is a Database Management System (DBMS)?
Piece of software that helps us administrate our data.
- What four main actions does the Database Management System (DBMS) help us to facilitate in relation to the database (please complete the actions below as well as providing a short description)?
a. D – Define – data types, attribute names, entities (schema) in the database catalog (meta data).
b. C – Construct – file structures, disk, etc… how we represent our data (attributes make the majority of this).
c. M – Manipulate – Query, update, etc… on my database (modifying the state of the database). SQL – DML (Data Manipulation Language).
d. S – Need to make the database available to multiple users (multiuser vs. single user systems).
- What two other actions does the Database Management System (DBMS) help us facilitate in relation to the database (please complete the words below ?
a. P – Protection, implements RBAC (what is this?).
b. M – Maintain – apply updates to the DBMS software, indexing maintenance, etc…
- In the database approach, data types, constraints, and locations of the data are stored where?
Database Catalog (Meta data)
- This mechanism of storing data (see question 6) separately from the data types, constraints, and locations of the data facilitates this type of data independence or abstraction?
Program data independence.
- What are the two main properties of a transaction (give a short description of each)?
Isolation – as an end user, I need the system to appear as if I’m the only user.
Atomicity – shouldn’t have partial success in manipulation of my database (all pass, or all fail).
- What is the name for the combination of the primary database and secondary DBMS & related software?
The database system.
- The class of users who require access to the database for querying, updating, and generating reports to do their jobs?
End Users.
- Name three different types of users from the class of users described in question 10 (give a short description for each)?
- Casual (you know the rest)
- Naïve (Least about the database management system)
- Sophisticated (Most about the database management system)
o DBA (Database Admin)
Database Designer
Software Engineer
System Engineer, etc… - Standalone
- What are three benefits of using a Database Management System (DBMS) over a file-based system?
Control data redundancy – each user group might have same representation of student.
- Leads to data inconsistency.
- DOE (Duplication of Effort)
Security – implement more granular access i.e., RBAC, etc…
Ensure data abstraction – i.e., program data independence, method data independence.
- When might you choose to use a file based-based system over a Database Management System (DBMS)?
Single user system, overhead cost, short timeline.
- What law predicts that the number of transistors on a microchip will double every two years?
Moore’s law
- Describe the difference of horizontal and vertical scalability?
Vertical scalability increasing the storage medium space, ram, etc.., horizontal scalability – creating more instances of my databases programs (API).