Brainscape's Knowledge GenomeTM

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


See full index

Database Management > Unit 1- Understanding Database Systems > Flashcards

Unit 1- Understanding Database Systems Flashcards

1
Q

What’s a database management system (DBMS)?

A

This is the
software that manages and controls access to the
database.

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

What’s a database?

A

A database is a collection of related data.

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

What’s a Character?

A

Collection of related bits (8-bits - byte)

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

What’s a – Fields (columns):?

A

single category of data to be
stored in a database

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

What’re a – Records (rows/tuples):

A

collection of related
fields in a database

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

What’s a table?

A

collection of related records

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

What’s a file?

A

a group of related records

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

What’s a primary key?

A

A primary key is a constraint in a table which uniquely
identifies each row record in a database

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

Characteristics of primary keys?

A
  • There can be only one primary key in a table.
  • Null or duplicate values are not allowed for the primary
    key column
  • A primary key column must contain unique values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Characteristics of primary keys?

A
  • There can be only one primary key in a table.
  • Null or duplicate values are not allowed for the primary
    key column
  • A primary key column must contain unique values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What’s a foreign key?

A

Foreign keys are the field of the table used to point to the
primary key of another table.

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

Characteristics of foreign keys

A
  • Using a foreign key we can identify records from multiple
    tables.
  • It accepts duplicate values as well as null values.
  • The purpose of foreign keys is to maintain data integrity and
    allow navigation between two different instances of an entity.
  • Foreign key also helps you to reduce data redundancy.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

whats a candidate key?

A

A candidate key is a set of one or multiple columns in a
database table.

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

Characteristics of candidate keys

A
  • It can identify a record uniquely just like a primary key.
  • The Primary Key of a table is selected from one of the
    candidate keys.
  • So, candidate keys have the same properties as the primary
    keys.
    – Candidate Key is a super key with no repeated attributes.
  • There can be more than one candidate keys in a table.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What’s a secondary key?

A

A secondary key shows the secondary value that is
unique for each record

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

Characteristics of secondary key

A
  • In the event that a primary key is not enough to
    distinguish the record, a secondary key can be used
    to identify the record
  • It is also termed as Alternate Key
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What’s a composite key?

A

Composite Key is a combination of two or more columns
that uniquely identify rows in a table.

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

Characteristics of composite key

A

The attributes in the set may not be unique when
considered separately.
* However, when taken all together, they will ensure
uniqueness.
– The combination of columns guarantees uniqueness,
though individual uniqueness is not guaranteed.

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

Whats a super key?

A

A super key is a group of single or multiple keys which
identifies rows in a table.
– Super Key is the set of all the keys which help to identify rows in a
table uniquely

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

Characteristics of Super key

A
  • This means that all those columns of a table than capable of
    identifying the other columns of that table uniquely will all
    be considered super keys.
  • A Super key may have additional attributes not needed for
    unique identification.
  • A super key is a superset of a candidate key
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Whats An index key

A

An index key is a column, an ordered collection of columns, or an
expression on which you define an index.

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

What is Structural dependence?

A

This exists when changes in the database
structure affect DBMS ability to access data

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

What is Structural independence ?

A

exists when changes in the
database structure do not affect DBMS ability to
access data

23
Q

What is * Data dependence ?

A
  • Data dependence is a function of the data storage
    characteristics, rather than of the file structure
24
Q

What’s Data independence

A

Data independence exists when it is possible to make
changes in the data storage characteristics without
affecting the application program’s ability to access
the data.

25
Q

What is a File-based system:

A

– A collection of application programs that perform
services for the end-users, such as the production of
reports.
File-based systems were an early attempt to computerize
the manual filing system

26
Q

list some File-oriented Approach
Disadvantages

A
  1. Data redundancy: There will be duplicates, as the files are created
    independently.
    – This increases maintenance costs
    – And also leads to data inconsistency, due to duplicates and/or similar data stored in
    different formats.
  2. Separation and isolation of data: When data is isolated in separate files, it is
    more difficult to access data that should be available.
  3. Data dependence to the physical format (the files themselves)
  4. Lack of flexibility: This means we are very limited on what we can do with our
    data:
    – Limited information retrieval options
    – Can only use pre-programmed reports
  5. Incompatible file formats: Because the structure of files is embedded in the
    application programs, the structures are dependent on the application
    programming language
27
Q

*What is the Database Approach?

A
  • Database Approach
    – Shared collection of logically related data which
    can be shared among application
28
Q

list 5 advantages of the DB APPROACH

A

Reduced Data Redundancy – Most data items are stored in only one file, which greatly
reduces duplicate data.
2. Improved Data Integrity – When users modify data in the database, they make changes
to one file instead of multiple files. Thus, the database approach increases the data’s
integrity by reducing the possibility of introducing inconsistencies.
3. Shared Data – The data in a database environment belongs to and is shared, usually
over a network, by the entire organization. Organizations that use databases typically
have security settings to define who can access, add, modify, and delete the data in a
database.
4. Easier Access – The database approach allows nontechnical users to access and maintain
data, providing they have the necessary privileges.
5. Reduced Development Time

29
Q

LIST 3 Differences BETWEEN File based system AND Database system

A
  1. The data and program are inter- dependent IN THE FILE APPROACH WHILE IN DB The data and program are independent of each other.
  2. File-based systems caused data redundancy While Database system control data redundancy.
  3. File-based systems caused data inconsistency HOWEVER In database systems data is always consistent. Because data
    appeared only once.
30
Q

HOW DOES Data Support Business
Decisions?

A

A strong data strategy can help businesses stay one
step ahead of competitors, helping tap into niche
markets and predict trends.

ALSO

Effective decision making, whether it’s around
company growth, hiring practices, sales or marketing
campaigns.

31
Q

– File retrieval and maintenance?

A

A DBMS provides several tools that allow users and programs to retrieve and maintain data in the database. Requests for information from a database are made in the form of a query.

32
Q

data manipulation?

A

The act of changing or modifying data to make it more understandable and structured is known as data manipulation.
● Data manipulation provides organizations with many advantages, such as consistent data, project data, and more in-depth analysis.

33
Q

Query language?

A

This used to retrieve information from a database.

They provide a means of retrieving records or parts of records and performing various calculations before displaying the results.

34
Q

Forms?

A

-A form is a window or screen that contains numerous fields to enter data, each with a field label to make it more user friendly than generating queries.

35
Q
  1. Reports??
A

A report is a database object that comes in handy when you want to present the information in your database for any of the following uses:

Display or distribute a summary of data. Archive snapshots of the data. Provide details about individual records.

36
Q
  1. Data security???
A

Data security refers to the protective measures employed to secure data against unapproved access and to preserve data confidentiality, integrity, and availability.

37
Q

Backup DBMS????

A

A backup is a copy of data that protects against unexpected data loss and application errors, allowing you to make it available again if needed.

38
Q
  1. Recovery??????
A

Recovery techniques in DBMS are used to recover the data when the new state of the data is lost or the entire data in the system is lost.

Logs are used to keep a record of the actions in a database and these logs are used to recover the data to the database.

39
Q

WHAT ARE THE Components of a DBMS?

A

● DDL
● DML
● Query Language-
● Report Generator

40
Q

DDL- The Data Definition Level ??

A

The Data Definition Level (DDL) is used to define the contents and structure of a database, which can be viewed at the logical, conceptual, or physical levels.

41
Q

● DML?

A

● DML- The DML provides procedural commands for data manipulation, such as Delete, Sort, Insert, Select, Display, Add, etc.

Data Manipulation Language or DML is a subset of operations used to insert, delete, and update data in a database.

A DML is often a sublanguage of a more extensive language like SQL; DML comprises some of the operators in the language●

42
Q

● Query Language-??

A

● Query Language-Query language is a user-oriented language that allows users to make ad-hoc queries from a database using simple words from a natural language.

It is similar to DML, but offers more commands for retrieval of information. SQL is a set of standard commands that allow users to make any query from a data-base using powerful commands like SELECT, PROJECT and JOIN.

43
Q

List all the Types of database models:

A

– Hierarchical Model
– Network Model
– Relational Model
– Object-oriented Model
– Object- relational Model
– Multi-dimensional Model
– NOSQL

44
Q
  • Hierarchical model ???????
A
  • Hierarchical model organizes data into a tree-like-structure,
    with a single root, to which all the other data is linked.
45
Q
  • Hierarchical model ???????
A
  • Hierarchical model organizes data into a tree-like-structure,
    with a single root, to which all the other data is linked.

Hierarchical model efficiently
describes many real-world
relationships like index of a book,
recipes etc.

46
Q

Network Model ??????

A

Network Model is an extension of the Hierarchical model
* In this model data is organized more like a graph, and are
allowed to have more than one parent node.

47
Q

Relational model??

A

In relational model, data is organized in twodimensional tables and the relationship is maintained by
storing a common field.

48
Q

Object oriented data model??

A
  • Object oriented data model is based upon real world
    situations
    – These situations are represented as objects, with
    different attributes
    – All these object have multiple relationships
    between them
48
Q

Object oriented data model??

A
  • Object oriented data model is based upon real world
    situations
    – These situations are represented as objects, with
    different attributes
    – All these object have multiple relationships
    between them
49
Q

Objects?

A

The real world entities and situations are represented as
objects

50
Q

ATTRIBUTES?

A

Every object has certain characteristics.
These are represented using Attributes. The behaviour of the
objects is represented using Methods

51
Q
  • Class?
    .
A

Similar attributes and methods are grouped together using a
class. An object can be called as an instance of the class.

52
Q
  • Inheritance??
A

A new class can be derived from the original class.
The derived class contains attributes and methods of the original
class as well as its own

53
Q

An Object relational model (HYBRID)

A

An Object relational model is a combination of a Object oriented
model and a Relational model
* This means that when developing these databases, you can include
methods and data types.

54
Q

Multidimensional model ?

A

Multidimensional model is defined by dimensions and facts
– The dimensions are the perspectives or entities concerning
which an organization keeps records

Database Management (2 decks)

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