Study Set Content:
21- Flashcard

database design process?

1 - define purpose of database(university)


2-find information required(student table and department table informations beside them like how many departments the uni have or faculty)


3-create field and tables and primary keys


4 = create relationships between tables


5-normalaize the design

Click To Flip the Card
22- Flashcard

normalazation rules:

1nf 2nf 3nf

first normal form // //

Click To Flip the Card
23- Flashcard

first rule of normalization?

make fields separately not such as

first and second name in one field

Click To Flip the Card
24- Flashcard

second rule of normalization ?

u have to make sure that every non primary key field depends on primary key field

Click To Flip the Card
25- Flashcard

normalization 3rd rule?

2 and 1should be done then

the non primary key fields should be independent on each other

Click To Flip the Card
26- Flashcard

how can we make relationship between two tables?

a head of primary key in one table will be a tail of foreign key in other table

Click To Flip the Card
27- Flashcard

three types of relationships :

one to one

one to many

many to many

Click To Flip the Card
28- Flashcard

one to one relatioship will be between which table and which table?

between one stuff which has one stuff

one student has one contact

 which contact contains house number

id also passport if needs

Click To Flip the Card
29- Flashcard

one to one example?

one car has a one id and license car and model

Click To Flip the Card
30- Flashcard

which relationship is most common?

one to many

Click To Flip the Card
31- Flashcard

why relationships are useful?

cus they free us from repeatin datas in tables

Click To Flip the Card
32- Flashcard

for one to one what is the condition to make relationship and also what is it for one to many ?

one to one both should be primary key

student id --> student id

one to many one of them needs to be primary key

costumer id --> position of student will be foreign key

Click To Flip the Card
33- Flashcard

what is diff between foreign key and primary key?

u can't update anything from foreign key but in primary , its ok

Click To Flip the Card
34- Flashcard

how does one to many works?

one costumer can order many things(which all of them have diff id)

costumer table is parent

and order table is child table

Click To Flip the Card
35- Flashcard

how does many to many works?

a book can be written by many writers

and a writer can write many books

so we need third table which contains

writer id

book id

and an id for book_and_writer table as primary key

Click To Flip the Card
36- Flashcard

sql and mysql can do what?

creating table removing table insetrt data retrieve data

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