Study Set Content:
1- Flashcard

what is database?

storing large amount of data as a structure

Click To Flip the Card
2- Flashcard

we can save data into?

pc(using memories) and server(for large amount of data)

Click To Flip the Card
3- Flashcard

what is dbms?

dbms is a software like sql it does create and manage database to the server or serveres in the pc

Click To Flip the Card
4- Flashcard

file system drawbacks?

  • Data redundancy => waste of memory
  • Data Inconsistency => saving files and forgetting which one is the last update one
  • Difficulty in accessing data => writing new program to do task like a login page u need other program for user and password but database just ask u entering in one page
  • Limited Data Sharing : using files of type psd or others will be problem cus u need a program for each of them
  • integrity problems : logic problems and u cant edit exist ones
  • update problems: u cant edit or change old data to update but database does
  • mutiple user cant use a program at same time
  • secuirty problem
Click To Flip the Card
5- Flashcard

abstraction means?

data hiding from user by logical level

Click To Flip the Card
6- Flashcard

absraction levels are?

physical levels --> can see data on the drive physic part

logical levels ---> can see data s a software like a table

view levels -- > only can see the data which leted from logical level to see

means user levels students for example

Click To Flip the Card
7- Flashcard

abstrction views - like physical can see what?

physcal can see both users and logicals data and may can changes

logical can see users data and can change it

view leevel only can see herself or himself data and can change some of them and cant change most of them which logical can do all

Click To Flip the Card
8- Flashcard

how to show data systems by using dbms?

accessed

stored

update

connected

Click To Flip the Card
9- Flashcard

popular data model?

relational model = links between table model

Click To Flip the Card
10- Flashcard

relational database made by who?

when?

edgar f codd 1970 (in case he asked just better to kno everything)

Click To Flip the Card
11- Flashcard

how does relational model works?

it uses tabluar form to store data as field and columns

Click To Flip the Card
12- Flashcard

relatiosnship means?

links between each tables = foreign key and primary key stuff

Click To Flip the Card
13- Flashcard

relation means?

tables

Click To Flip the Card
14- Flashcard

relationship between relations means what?

links between tables

Click To Flip the Card
15- Flashcard

colum --> f..

row --> re..

colume = field

row = records or data

Click To Flip the Card
16- Flashcard

what is relational dbms??

dbms is a softwar managain or retrieve and store data to database 

--

relational dbms is a specefic type of software that only works on relational databases means u can manage relational database with this spsecefic softwares which is sql

Click To Flip the Card
17- Flashcard

3 types dbms of relational database?

mysql

oracle

microsoft sql server

Click To Flip the Card
18- Flashcard

how can u show ur database daiagram?

name of table or relation

then name of fields and notice primary key too

Click To Flip the Card
19- Flashcard

what is primary key in database?

a unique data or identifier in every table we have to have one primary key no more no less , like id and passport etc

Click To Flip the Card
20- Flashcard

what is foreign key?

its actually primary key but in another table

to be clear : a table that give primary key is the parent

and a table that retrieve primary key it's the child table and the name of column will be foreign key

Click To Flip the Card
thumb_up_alt Subscribers
layers 36 Items
folder Engineering Category
0.00
0 Reviews
Share It Now!