Specified during the database design process
Anonymous Quiz
16%
Database instance (extension)
84%
Database schema (intension)
Not expected to change frequently
Anonymous Quiz
76%
Database schema (intension)
24%
Database instance (extension)
data model :a collection of concepts that can be used to describe the structure of a database
Anonymous Quiz
33%
F
67%
T
The structure of a database mean the data types, relationships, and constraints
Anonymous Quiz
92%
T
8%
F
was developed by IBM and North American Rockwell known as Information Management System.
Anonymous Quiz
7%
Network Database Model
8%
Relational Model
10%
Entity Relationship Model
72%
Hierarchical Model
3%
Object Model
This model is the first DBMS model
Anonymous Quiz
6%
Object Model
84%
Hierarchical Model
5%
Entity Relationship Model
4%
Relational Model
It represents data as relations or tables
Anonymous Quiz
81%
Relational model.
6%
Object Model
4%
Hierarchical Model
9%
Entity Relationship Model
It uses pointer to navigate between the stored data.
Anonymous Quiz
29%
Network Database
10%
Relational model.
21%
Object Model
40%
Hierarchical Model
It represents the data as record types and one-to-many relationship
Anonymous Quiz
19%
Relational model.
7%
Object Model
7%
Hierarchical Model
67%
Network Database model
It is used in File Management System.
Anonymous Quiz
13%
Network Database
9%
Relational model.
68%
Object Model
9%
Hierarchical Model
It is easy to maintain and modify the existing code.
Anonymous Quiz
66%
Object Model
22%
Relational Model
9%
Network Database Model
4%
Hierarchical Model
It is used by people who don't know how database is implemented.
Anonymous Quiz
86%
ER Model
14%
Relational Model
It consists of components like domain, attributes, tuples.
Anonymous Quiz
30%
ER Model
70%
Relational Model
Some of the popular Language and Notations used:
• Chen
• UML • Crow's foot • Bachman and others.
• Chen
• UML • Crow's foot • Bachman and others.
Anonymous Quiz
18%
Relational Model
82%
ER Model
Database management systems can be classified based on several criteria,such as the data model, user numbers and database distribution.
Anonymous Quiz
97%
T
3%
F
Centralized, Distributed
Anonymous Quiz
14%
Classification Based on Data Model
3%
Classification Based on User Numbers
83%
Classification Based on Database Distribution
It can be a single-user database system, which supports one user at a time, or a multiuser
database system,
database system,
Anonymous Quiz
8%
Classification Based on Data Model
87%
Classification Based on User Numbers
4%
Classification Based on Database Distribution