Brainscape's Knowledge GenomeTM

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


See full index

ICT and programming > database management > Flashcards

database management Flashcards

1
Q

how is data stored?

A

data is stored in files that contains records, and in turn contain fields

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

what is a database

A

is a collection of data or information which is stored in a logical and structured way

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

other names of a database software?

A

-Database manager
-Database management system (DBMS

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

what is database software used for?

A

store, organise and manipulate data

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

what does data manipulation include

A

-adding new data
-deleting old data (which is not necessary to store any longer)
-updating data/information

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

why do we need a database

A

-To keep records of customers, staffs, products, etc.
-To develop reports
-To perform research
For longitudinal tracking

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

examples of non computerised database

A

dictionary, telephone directory, address book

(printed)

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

examples of computerised database

A

Netflix, phone contacts, game library, Facebook

electronic

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

how is Netflix a database

A
  • it stores movies/films in a datbase
    -easily searched and sorted
    -can search by genre, rating, age
    -can sort by release date, takings
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

how is your phone contacts a database

A
  • all info about contacts are stored in a database on the phone
  • can store pictures, names, numbers, emails

easily searched and sorted

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

some common areas of using database applications

A

banking (transactions)
airlines (reservations/schedules)
universities(registration, grades)

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

popular database software

A

oracle, microsoft SQL, mySQL, microsoft access

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

name 3 data models

A

relational mode, hierarchal model, object-oriented model

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

what is the relational database model

A

A data store designed in an organised way, making it easier to search for the information you need.

entities and relationships are stored in tables

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

what is a record in relational database model?

A

A Relational Database is a collection of tables that are related to one another based on a common field

Each line or row in a table is called a Record

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

what is the primary key in relational database model?

A

Each record should have a field which is unique in every record and this field is called Primary Key

such as id number of student

17
Q

what is a foreign key in relational database model

A

The Primary Key of one entity is a Foreign Key in another entity

18
Q

what are the fields of an entity in a relational database model

A

The fields of an Entity are column headings in a table and each field has a particular data type such as customer_Id is a text type data and order-date is a date type data

19
Q

what is a query in a relational database model

A

If we want to find some particular records from a number of records, we need to run a query

20
Q

what is a data model?

A

A data model attempts to represent the data requirements of the organisation

-describing data
-relationships between data
-constraints on the data used by an organisation

21
Q

what is the purpose of a data model?

A

The purpose of data model is to represent data and to make sure the data is understandable. If it does this, then it can be used to design a database.

One of data model is known as Relational model

22
Q

what are the structural components of relational models

A

field (attribute) - a named column of a relation

Record (Tuple) - A row of a relation

file (relation) - A table with columns and rows

Domain - Range of allowable values for one or more attributes

relational database - A collection of tables that are related to one another based on a common field

23
Q

relational model in terms of university students

A

some info uni keeps of a student : id number, name, address, number, gender, nationality, DOB

each of these is 1 piece of information, this is called a field

all of the fields put together to make a record (all data about 1 person in a table)

all records are stored together in a file

a file consists of a collection of particular records

24
Q

why is the domain concept important

A

The domain concept is important because it allows us to define the meaning and source of values that attributes can hold.

As a result, more information is available to the system and can reject operations that do not make sense

25
Q

a field or a collection of fields is called the ______ ____ to provide uniqueness

A

primary key

26
Q

when does primary key become foreign key

A

When the primary key of one table is represented in a second table to form a relationship, it is called a foreign key

27
Q

name 7 properties of a relational table

A

Table name is distinct from all other table names in the database

Each cell of a table contains one single value

Each column has a distinct name

Values of a column are of the same domain

Each record is distinct

Order of columns (fields) has no significance

Order of records has no significance

28
Q

what does DBMS mean

A

database management system

29
Q

what is a DBMS

A

Consists of programs that control the database structure and access to the data

Information changes only have to be updated once

30
Q

what are the 4 functions of a DBMS

A

-Data storage, retrieval and update
-Concurrency control services
-Recovery services
-Security

30
Q

what does concurrency control services mean in DBMS

A

Multiple users make updates to the database simultaneously

ensures that updates are made correctly and at the end the result is accurate

important data could be lost or inaccurately stored if there is no intervention

31
Q

what is security as a function of a DBMS

A

-Protection of DB against unauthorised access
-users may only be access certain pieces of the database, and be denied access to areas that does not relate to their specific needs

32
Q

what are recovery services in relation to DBMS

A

DBMS provides ways to recover a database so that data is not permanently lost

ICT and programming (8 decks)

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