Inside Relational Databases with Examples in Access

Inside Relational Databases with Examples in Access


Yazar Mark Whitehorn
Yayınevi Springer London
ISBN 9781846283949
Baskı yılı 2010
Sayfa sayısı 388
Ağırlık 0.75 kg
Edisyon 1
Stok durumu Var    Stok detayları
Kargoya teslim Aynı gün kargo

Contents Should we tell you the whole story? Of course, there is an inevitable tension in trying to work like this. For example, in Chapter 16 we talk about referential integrity. There are - sentially six different flavors of referential integrity but Access only s- ports four of them (they are the most important ones however, so you arent missing out on too much). The problem is this. Should we tell you about the other two? If we do, as an Access user you have every right to be annoyed that we are telling you about a feature you cant use. On the other hand, the six different types that we describe are part of the re- tional world and this book is about that world - we are not trying to teach you how to use Access, we are simply using Access to illustrate the relational model. Ultimately we decided to risk your ire and to describe all of the features of the relational model as we see it, even if Access doesnt support all of them. One advantage of this approach is that if you need to use a different database engine you will almost certainly find the extra information useful. Incidentally, this is not meant to imply that Access is somehow lacking as a relational database engine. The reason we chose it for the first book is that it is such a good example of a relational database tool.
Ch. 1 Introduction 1
Ch. 2 Introduction to part 1 13
Ch. 3 Tables 17
Ch. 4 Queries/views 36
Ch. 5 Forms 45
Ch. 6 Reports 54
Ch. 7 Summary of part 1 56
Ch. 8 Introduction to part 2 61
Ch. 9 Serious problems with single tables 62
Ch. 10 Multiple tables cure serious problems 67
Ch. 11 Making multiple tables work together 73
Ch. 12 Getting the data into the correct tables 75
Ch. 13 Relationships in the real world 81
Ch. 14 How are relationships modeled? 84
Ch. 15 Revisiting the big four - the synergy begins 112
Ch. 16 Integrity 127
Ch. 17 Summary of part 2 146
Ch. 18 Database design 149
Ch. 19 The seven layers of wisdom 165
Ch. 20 Database architecture 168
Ch. 21 What exactly is a relational database? 181
Ch. 22 Triggers and stored procedures 183
Ch. 23 Transactions, longs, backup, locking and concurrency 190
Ch. 24 Codds rules 201
Ch. 25 Normalization 215
Ch. 26 More about normalization 233
Ch. 27 The system tables 244
More...

Axess
Axess

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

cardFinans
cardFinans

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

Bonus
Bonus

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

World
World

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

Maximum
Maximum

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

Paraf
Paraf

Taksit Taksit Tutarı Toplam Tutar
Tek çekim - 247.50 TL
2 ay 130.56 TL 261.11 TL
3 ay 87.86 TL 263.59 TL
6 ay 45.58 TL 273.49 TL
9 ay 31.49 TL 283.39 TL
12 ay 24.44 TL 293.29 TL

Kredi Kartı (Tek Çekim)
Kredi Kartı (Tek Çekim)

Taksit Taksit Tutar ı Toplam Tutar
Peşin - 247.50 TL

Bonus, Maximum, Paraf, Cardfinans, Axess ve World özelliği olan tüm kartlar ile ödeme yapılabilir.