Into

Question 1

manage data - history

Answer 1

paper system
file based systems
-> database

Question 2

database

Answer 2

shared data - meet needs
system catalog - data independence
logically related data - relationship

Question 3

database sys

Answer 3

hierarchical model
network
relational
OO
NoSQL

Question 4

hierachical

Answer 4

trees

parent-child : one - one, one - many

Question 5

network

Answer 5

hierachical extends

parent – child : allow many - many

Question 6

relational

Answer 6

table oriented
relation : table
tuple, record, row
attribute, column, field (a property of a entity)

Question 7

entity

Answer 7

a person, a thing, event

Question 8

relationship

Answer 8

association : entities

Question 9

OO model

Answer 9

used in OOP

Question 10

DBMS

Answer 10

software - database

Question 11

DBMS servers

Answer 11

an intermediary user- database

used directly or through another app

Question 12

database language

Answer 12

DDL - data definition language

DML - data manipulation language

Question 13

DDL

Answer 13

stuctures

create, alter, drop

Question 14

DML

Answer 14

manipulate data

select, update, insert, delete

Question 15

DBMS - advantages

Answer 15

control : data redundancy
data consistency
more info
sharing
data integrity, secure
standards
economy of scale
balance connflicts
data accessibility and responsiveness.....

Question 16

DBMS - disadvantages

Answer 16

complex
size
cost DBMS
hardwards
cost conversion
performance
impact of failure..