Brainscape's Knowledge GenomeTM

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


See full index

CE 165 : DATABASE MANAGEMENT SYSTEM > Chap2&3 > Flashcards

Chap2&3 Flashcards

1
Q

A person, object, or event of importance to the organization.

A

Entity

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

TRUE OR FALSE

Entities that the organization wants to store data about typically becomes a database table.

A

TRUE

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

What are the three types of entity?

A
  1. Entity Instance
  2. Regular Entity
  3. Weak Entity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

This is a type of entity which is also called a strong entity?

A

Regular Entity

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

An entity which depends on other entity for its existence?

A

Weak Entity

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

A particular member of the entity type

A

entity instance

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

An entity which has its own attribute

A

Regular Entity

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

These are characteristics of an entity

A

Attributes

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

TRUE OR FALSE

Attributes typically becomes fields in the entity’s database table.

A

TRUE

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

This is an association between two or more entities.

A

Relationship

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

Enumerate the 7 classifications of Attributes.

A
  1. Key Attribute
  2. Simple Attribute
  3. Composite Attribute
  4. Single Valued Attributes
  5. Multi Valued Attributes
  6. Stored Attribute
  7. Derived Attribute
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

This is a set of permissible values that an attribute can take.

A

Domain Attribute

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

The attribute which is unique for every entity instance.

A

Key Attribute

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

If an attribute cannot be divided into simpler components.

A

Simple Attribute

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

If an attribute can be split into components

A

Composite Attribute

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

If an attribute can take only a single value for each entity instance

A

Single Valued Attributes

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

If an attribute can take more than one value for each entity instance.

A

Multi-Valued Attributes

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

An attribute which need to be stored permanently.

A

Stored Attribute

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

An attribute that can be calculated or derived based on other attributes.

A

Derived Attribute

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

One to one entity relationship is a common type of relationship.

A

FALSE

*not a common type

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

Cardinality of relationship
One entity is related to only one other entity of a particular type.

A

One to One (1:1) Entity Relationship

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

Cardinality of Relationship

This is the most common type of relationship.

A

One to Many (O:M) Entity Relationship

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

An example of this relationship is :

A supplier can supply more than one product to a company.

A

One to Many Entity Relationship

One entity can be related to more than one other entity.

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

One entity can be related to more than one other entity, and those entities can be related to multiple entities of the same type as the original entity.

A

Many to Many (M:M) Entity Relationships

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

What are the 4 Cardinality of Relationship?

A
  1. One to One Entity Relationship
  2. One to Many Entity Relationship
  3. Many to One Entity Relationship
  4. Many to Many Entity Relationship
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

This is a component of DBMS that stores the definition of data characteristics and relationship.

A

The Data Dictionary

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

The Data Dictionary is also known as ___________.

A

Data Repository System

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

Data Dictionary contains all data definitions in a database, including what?

A

*table structures
*Security information (passwords, etc)
*Relationships between the tables in the database
*Basic information about each table, such as the current number of records

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

The Data Dictionary contains any of the data in the tables?

A

FALSE

  • does not contain
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

The Data dictionary does not contain meta data, which information about the database tables.

A

FALSE

*does contain metadata

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

The data dictionary or data repository system ensures that the data entered into the database does not violate any specified criteria.

A

TRUE

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

The two types of Data dictionary are integral and stand alone?

A

FALSE

*Integrated
*Stand-Alone

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

Difference of integrated DD and Stand-alone DD?

A

Integrated- built in the data dictionary
Stand Alone - this is more flexible

34
Q

Enumerate the 6 Classification of Database Management System.

A
  1. Based on Data Model
  2. Based on Number of Users
  3. Based on Database Distribution
  4. Based on Cost of Database
  5. Based on Usage
  6. Based on Flow Control
35
Q

This defines the logical and physical structure of the database.

A

Based on Data Model

36
Q

In here, the data is organized in tables related by common fields. In addition, it is most widely used database model today.

A

The Relational Database Model (RDBMS)

37
Q

Give the properties of Relational Database

A

ACID

Atomicity
Consistency
Isolation
Durability

38
Q

Organizes data in a tree structure.
Typically a one to many relationship between data entities.

A

Hierarchical Database

39
Q

Hierarchical Database is an inverted tree (parent-children relationship)

A

TRUE

40
Q

This allows both one to many and many to many relationships between data elements

A

Network Database

41
Q

What is ERD?

A

Entity Relationship Diagram

42
Q

It represents data using objects and relationships among these objects.

A

Entity Relationship Model

43
Q

What do you call the extension of ER Model?

A

The object-oriented Database Model

44
Q

In Object-Oriented Database Model, database system in which multiple types of data are stored as objects along with their related code.

A

TRUE

45
Q

In OODM, information can be retrieved using queries.

A

FALSE

*objects can be retrieved

46
Q

What is OQL?

A

Object query language

47
Q

The data items or objects of the same kind might have a different set of attributes.

A

Semistructured Data Model

48
Q

What is XML?

A

Extensible Markup Language

49
Q

This represents the semistructured data?

A

Extensible Markup Language

50
Q

What are the two types of database systems based on the number of users?

A
  1. Single User Database System
  2. Multiuser Database System
51
Q

Single User Database System FACTS
* located on a single computer
*designed to be accessed by one user
*widely used for personal applications and very small businesses.

A

TRUE

52
Q

This database system is designed to be accessed by multiple users (most business databases today)

A

Multiuser Database System

53
Q

What are the database systems under database distribution?

A

Centralized and Distributed Database System

54
Q

This database system is located on a single computer such as a server or mainframe.

A

Centralized Database System

55
Q

The data is physically divided among several computers connected by a network, but the database logically looks like it is a single database.

A

Distributed Database System

56
Q

The Three types of DBMS based on their costs are:

A
  1. Low Cost DMBS
  2. Medium Cost DBMS
  3. High Cost DBMS
57
Q

Database can be sold in the form of licenses.

A

TRUE

58
Q

MySQL and PostgresSQL are free DBMS

A

TRUE

59
Q

The cost of these systems vary from $100 to $3000.

A

Low Cost DBMS

60
Q

The cost varies from $10000 - $100000

A

Medium Cost DBMS

61
Q

The cost is more than $100000

A

High Cost DBMS

62
Q

What is OLTP??

A

Online Transaction Processing

63
Q

OLTP supports a larger number of transaction.

A

TRUE

64
Q

This database is designed to meet the need of as many applications as possible.

A

General-Purpose DBMS

65
Q

It is designed for a specific application and it can not be used for another application without performing any major changes.

A

Special Purpose DBMS

66
Q

Active DBMS is a data-driven system or event-driven system where the control flow between the application and DBMS is based on the occurrence of an event.

A

TRUE

67
Q

The user or the application program is responsible to initiate the operation.

A

Passive DBMS

68
Q

In here, data is stored in hard drives.

A

Disk-based systems

69
Q

Passive DBMS is also called as Program driven system.

A

TRUE`

70
Q

IN Memory Databases. TRUE OR FALSE

Data is not stored in the main memory.

A

FALSE

*data is stored

71
Q

IN Memory Databases. TRUE OR FALSE

This is dramatically slower than disk-based databases.

A

FALSE

  • dramatically faster
72
Q

IN Memory Databases. TRUE OR FALSE

It is very essential to have good backup procedures.

A

TRUE

73
Q

IN Memory Databases. TRUE OR FALSE

These are used in high-end systems where performance is crucial and in small footprint embedded applications.

A

True

74
Q

This is a combination of two or more database types or models.

A

Hybrid Database Models

75
Q

This can store and retrieved both XML data and relational data

A

Hybrid XML / Relational Database

76
Q

This is typically hosted on a cloud database provider’s servers that is accessible to users via the web.

A

Cloud Databases

77
Q

What are example of Cloud database in Use.

A
  1. Information retrieval
  2. Support and facilitate e-commerce
  3. Cloud databases allow web pages to be dynamic web pages.
78
Q

data to be accessed and displayed on a web page is often stored in a database (ex: search sites.)

A

information retrieval

79
Q

Display product information, pricing, customer information, shopping cart contents, etc.

A

Support and facilitate e-commerce.

80
Q

Collection of attribute values

A

Tuples

CE 165 : DATABASE MANAGEMENT SYSTEM (5 decks)

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