Index A airline system, case study about 75 (Affordable web hosting)
Index A airline system, case study about 75 all persons on a flight, sample query 89, 90 boarding pass, sample query 88 code tables 81 composite-key tables 85 data elements 80 document gathering, results 75-77, 79 passenger list, sample query 88, 89 sample queries 87 sample values 80, 84, 85 tables 80, 84, 85 themed tables 82, 84, 85 C case study airline system 75 car dealer 11 final structure 63 case study, car dealership about 11 car dealer 11 data elements 22 general manager, data elements 23 sales contract, data elements 23 salesperson, data elements 23 store assistant, data elements 24 data model, building 11 example of data cleaning 27 goal 17 scope 17, 18 system goals 12 Codd s rules 10 composite key about 42 using 43 compound key 42 D data access policies 51 application level, security 53 as column name 30-32 as results 29, 30 as table name 30-32 data cleaning 27, 28 data design, with case study 11 data structure 10 data structure, changing 32 data structure, normalization 10 dependency 41 encoding 62 previleges 53 redundancy 41 security 53 data, collecting data elements, example 22 document, gathering 19 interviews 20, 22 system boundaries, identifying 17, 18 data access policies about 51 application level, security 53 data responsibility 51 previleges 53 security 53 views 53 data cleaning 27, 28