Name the two major reasons for choosing to use a database rather than a spreadsheet: and ,
A database is made up of and
Columns are also known as while rows are also known as
A field is made up of a group of
bits
Bytes
Characters
Rows are also known as Fields
The components of a database are: , and .
A database uses a which is found in every record.
To remain , queries must be limited to determine only information required to run the business.
Metadata is data about
The following are Database Management Systems (DBMS) which must be licensed from the vendor.
DB2
Access
MySQL
SQL Server
Oracle Database
User permissions will allow a user to perform none, some, or all of the following operations:
Read
Insert
Modify
Delete
In order to query a database, most popular DBMSs use:
SQL
One of thethree main duties of a database administrator are: Setting up a security system which involves , and .
Permissions determine who can , , and data.
A database security system involves creating , , and .
A database administrator has four main categories of tasks. They are: , , and .
A problem tracking system is created for the phase. A change tracking system is created for the phase.
Forms make it easier for users to:
View data
Insert new data
Update existing data
Delete existing data
Run reports
Queries allow users to search for data in an efficient manner.
Reports are less structured than queries.
Application programs query the database on behalf of the user.
A dynamic content report allows the user to click on a field to or
Multi-user processing problems occur when two or more users are simultaneously changing the same data.
Data models are used to determine entities and their relationships. These are required for database design.
A student's date of birth is an entity.
An identifier (or key) must be unique.
Each attribute has and entity.
1:N signifies a relationship.
N:M signifies a relationship.
A vertical bar on a crow's foot diagram means that one entity is required.
A small oval on a crow's foot diagram signifies that the relationship need not have an entity of that type.
The normalization of a data model means converting into .
Data integrity problems can result in:
Loss of confidence in the information
Incorrect or inconsistent information
A poor reputation for the system
Raises for everyone
Combining two tables into one can create problems with .
Each entity should have its own with one in each .
The final judge of whether a data model is accurate is
The database administrator
Experienced representatives of the business
A new types of DBMS called is becoming popular in situations where relational models aren't needed or don't fit.
The three main attributes of NoSQL are that it supports , and can be replicated on many servers in the cloud.
Examples of NoSQL are , and .
Conversion to NoSQL is being done by many companies because it is easy to learn and easy to convert older systems.
SQL injection is one of the most common form of attacks.
