DatabasePractice.pptxVIP

Relational DatabasesTablesRowsFirst Row (attributes)The other rows (records)Columns (fields)Primary keys (one of the fields)Data typesTextDates timesNumbersObjectsCustomer TableCustomerID Name Address City 12345 Jones 123 Elm Chicago28764 Adamz 938 Main Phoenix29587 Smitz 523 Oak Seattle33352 Sanchez 999 Pine Denver44453 Kolke 909 West Denver87535 James 374 Main MiamiOrders TableOrderID CustomerID Date Salesperson Total_sale117 12345 3/3/06 887 57.92125 87535 4/4/06 663 123.54157 12345 4/9/06 554 297.89169 29587 5/6/6 255 89.93Database AdvantagesFocus on dataStable dataPrograms changeData i