Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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

Chap2&3 Flashcards

(80 cards)

Start Studying
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
What are the 4 Cardinality of Relationship?
1. One to One Entity Relationship 2. One to Many Entity Relationship 3. Many to One Entity Relationship 4. Many to Many Entity Relationship
26
This is a component of DBMS that stores the definition of data characteristics and relationship.
The Data Dictionary
27
The Data Dictionary is also known as ___________.
Data Repository System
28
Data Dictionary contains all data definitions in a database, including what?
*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
29
The Data Dictionary contains any of the data in the tables?
FALSE * does not contain
30
The Data dictionary does not contain meta data, which information about the database tables.
FALSE *does contain metadata
31
The data dictionary or data repository system ensures that the data entered into the database does not violate any specified criteria.
TRUE
32
The two types of Data dictionary are integral and stand alone?
FALSE *Integrated *Stand-Alone
33
Difference of integrated DD and Stand-alone DD?
Integrated- built in the data dictionary Stand Alone - this is more flexible
34
Enumerate the 6 Classification of Database Management System.
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
This defines the logical and physical structure of the database.
Based on Data Model
36
In here, the data is organized in tables related by common fields. In addition, it is most widely used database model today.
The Relational Database Model (RDBMS)
37
Give the properties of Relational Database
ACID Atomicity Consistency Isolation Durability
38
Organizes data in a tree structure. Typically a one to many relationship between data entities.
Hierarchical Database
39
Hierarchical Database is an inverted tree (parent-children relationship)
TRUE
40
This allows both one to many and many to many relationships between data elements
Network Database
41
What is ERD?
Entity Relationship Diagram
42
It represents data using objects and relationships among these objects.
Entity Relationship Model
43
What do you call the extension of ER Model?
The object-oriented Database Model
44
In Object-Oriented Database Model, database system in which multiple types of data are stored as objects along with their related code.
TRUE
45
In OODM, information can be retrieved using queries.
FALSE *objects can be retrieved
46
What is OQL?
Object query language
47
The data items or objects of the same kind might have a different set of attributes.
Semistructured Data Model
48
What is XML?
Extensible Markup Language
49
This represents the semistructured data?
Extensible Markup Language
50
What are the two types of database systems based on the number of users?
1. Single User Database System 2. Multiuser Database System
51
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.
TRUE
52
This database system is designed to be accessed by multiple users (most business databases today)
Multiuser Database System
53
What are the database systems under database distribution?
Centralized and Distributed Database System
54
This database system is located on a single computer such as a server or mainframe.
Centralized Database System
55
The data is physically divided among several computers connected by a network, but the database logically looks like it is a single database.
Distributed Database System
56
The Three types of DBMS based on their costs are:
1. Low Cost DMBS 2. Medium Cost DBMS 3. High Cost DBMS
57
Database can be sold in the form of licenses.
TRUE
58
MySQL and PostgresSQL are free DBMS
TRUE
59
The cost of these systems vary from $100 to $3000.
Low Cost DBMS
60
The cost varies from $10000 - $100000
Medium Cost DBMS
61
The cost is more than $100000
High Cost DBMS
62
What is OLTP??
Online Transaction Processing
63
OLTP supports a larger number of transaction.
TRUE
64
This database is designed to meet the need of as many applications as possible.
General-Purpose DBMS
65
It is designed for a specific application and it can not be used for another application without performing any major changes.
Special Purpose DBMS
66
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.
TRUE
67
The user or the application program is responsible to initiate the operation.
Passive DBMS
68
In here, data is stored in hard drives.
Disk-based systems
69
Passive DBMS is also called as Program driven system.
TRUE`
70
IN Memory Databases. TRUE OR FALSE Data is not stored in the main memory.
FALSE *data is stored
71
IN Memory Databases. TRUE OR FALSE This is dramatically slower than disk-based databases.
FALSE * dramatically faster
72
IN Memory Databases. TRUE OR FALSE It is very essential to have good backup procedures.
TRUE
73
IN Memory Databases. TRUE OR FALSE These are used in high-end systems where performance is crucial and in small footprint embedded applications.
True
74
This is a combination of two or more database types or models.
Hybrid Database Models
75
This can store and retrieved both XML data and relational data
Hybrid XML / Relational Database
76
This is typically hosted on a cloud database provider's servers that is accessible to users via the web.
Cloud Databases
77
What are example of Cloud database in Use.
1. Information retrieval 2. Support and facilitate e-commerce 3. Cloud databases allow web pages to be dynamic web pages.
78
data to be accessed and displayed on a web page is often stored in a database (ex: search sites.)
information retrieval
79
Display product information, pricing, customer information, shopping cart contents, etc.
Support and facilitate e-commerce.
80
Collection of attribute values
Tuples

CE 165 : DATABASE MANAGEMENT SYSTEM (5 decks)

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