Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

WEB PROG - 3RD QUARTER > Introduction to Database > Flashcards

Introduction to Database Flashcards

1
Q

-It is a collection of information that is organized so that it can easily be accessed, managed, and updated.
-It is a logically organized collection of data helpful in easy search and retrieval of data
-A database isn’t necessarily contained on a computer. A telephone directory is still a huge book sitting next to your phone.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

examples of commonly used databases might be:

A
  • Address book
  • Library catalogue
  • Telephone directory
  • Stock list
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

examples of the sort of information that can be kept in a database:

A
  • Inventory control
  • Payroll systems
  • Personnel
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

popular relational database management systems include:

A
  • Microsoft Access
  • Filemaker
  • Microsoft SQL Server
  • MySQL
    -Oracle
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Drawbacks of using file systems to store data:

A
  • Data redundancy and inconsistency
  • Security problems
  • Data isolation multiple files and formats
  • Difficulty in accessing data
  • Concurrent access by multiple user
    -Integrity problems
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Advantages of Database

A

-Improved availability
-Minimized redundancy:
-Accuracy
-Program and file consistency:
-User-friendly:
-Improved security:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

One of the principle advantages of a DBMS is that the same information can be made available to different users.

A

Improved availability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  • The data in a DBMS is more concise because the information in it appears just once.
  • This reduces data redundancy, or in other words, the need to repeat the same data over and over again.
A

-Minimized redundancy:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

-Accurate, consistent, and up-to-date data is a sign of data integrity.
-DBMSs foster data integrity because updates and changes to data only have to be made in one place.
-The chances of making a mistake are higher if you are required to change the same data in several different places than if you only have to make the change in one place

A

-Accuracy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  • Using a database management system, file formats and system programs are standardized.
  • This makes the data files easier to maintain because the same rules and guidelines apply across all types of data. The level of consistency across files and programs also makes it easier to manage data when multiple programmers are involved.
A

-Program and file consistency:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Data is easier to access and manipulate with a DBMS than without it. In most cases, DBMSs also reduce the reliance of individual users on computer specialists to meet their data needs.

A

-User-friendly:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

-DBMSs allow multiple users to access the same data resources. This capability is generally viewed as a benefit, but there are potential risks for organization.
-Some sources of information should be protected or secured and only viewed by select individuals. Through the use of passwords, database manage-ment systems can be used to restrict data access to only those who should see it.

A

-Improved security:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  • It is responsible for storing data in the database.
  • Database tables consist of row (record) and columns ( field)
A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

-It is a named unit of information
-A discrete piece of information that is part of a record. Each column in the Access table is a different field

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

-It is a group of fields within a table that are relevant to a specific entity.
- A row in a table that contains information about a particular person, place, or thing.

A

Record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

RELATIONAL DATABASE

  • It is a field (or fields) that uniquely identifies the record. Sometimes you can assign a natural primary key.
  • Each column or set of columns in a table that contains unique values is considered a candidate key
A

The primary key

17
Q

-It is the process of applying a series of rules to ensure that a database achieves optimal structure.
- It the process of organizing data to minimize duplication
-Its refers to the process of creating an efficient, reliable, flexible, and appropriate “relational” structure for storing information

A

Normalization

18
Q

-All columns (fields) must be atomic which means no repeating items in columns
- To achieve this, all columns in a table must be atomic and no repeating values.
-This means, for example, that you cannot store first name and last name in the same field.
- The reason for this rule is that data becomes very difficult to manipulate and retrieve if you store multiple values in a single field

A

First Normal Form

19
Q
  • All non-key columns must be fully dependent on the primary key.
  • In other words, each table must store data about only one subject.
A

Second Normal Form

20
Q
  • a table must meet all the requirements for first and second normal forms, and all non-key columns must be mutually independent.
    -Remove columns that are not dependent upon the primary key.
A

Third Normal Form

21
Q

Enumerate the database relationship

A
  • One-To-One Relationships
  • One-To-Many Relationships
  • Many -To- Many Relationships
22
Q
  • It can exist between any two tables in which a row in the first table can be related o only one row in the second table and a row in the second table can be related only row in first table.
    -these least likely type of relationships to be implemented in a relational database.
  • This relationship can be use because one table would contain too much data, or perhaps you would want to separate data into different tables so you could set up one table with a higher level of security
A

One-To-One Relationships

23
Q
  • a row in the first table can be related to one or more rows in the second table, but a row in the second table can be related to only one row in the first table.
  • The user must develop this type of relationship by adding a table called a junction table. You relate the junction table to each of the two tables in one-to-many relationships.
A

One-To-Many Relationships

24
Q

-When you define a dimension, typically each fact joins to one and only one dimension member, whereas a single dimension member can be associated with many different facts.
-the user must develop this type of relationship by adding a table called a junction table. You relate the junction table to each of the two tables in one-to-many relationships.

A

Many -To- Many Relationships

25
Q

RELATIONAL DATABASE

  • It is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables.
    -It identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
A

FOREIGN KEY

26
Q

ENUMERATE THE TWO RELATIONAL DATABASE

A

-PRIMARY KEY
-FOREIGN KEY

WEB PROG - 3RD QUARTER (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions