2 500000 4565 bus 38 0 8988 edu 21 0 3234 aces 31

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: l understood model 5 –  Shared access –  Controlled access Database Elements RelaBonal Model •  InformaBon stored in relaBons or tables –  Each row is a tuple of aMributes –  Manipulated by standard SQL language Name Alice Bob Carol Dave Ellen Alice 7 UID College GPA Financial Aid 1232 Eng 4 0 3234 Eng 1.2 $5,000.00 4565 Bus 3.8 0 8988 Edu 2.1 0 3234 ACES 3.1 $100.00 4534 LAS 2.9 $10,000.00 Combining tables •  Can use Join to create single set of tuples from mulBple tables. Name Alice Bob Carol Dave UID Major 1234 ECE 2345 NUC 3456 BA 4567 French UID 1234 2345 3456 4567 Name Dorm Major Alice LAR ECE Bob ISR NUC Carol FAR BA Dave PAR French 8 Dorm LAR ISR FAR PAR Making Queries •  Can select rows to create subtables –  Select Name, UID, Financial Aid from Students where College = 'Eng' Name Alice Bob Carol Dave Ellen Alice UID College GPA Financial Aid 1232 Eng 4 0 3234 Eng 1.2 $5,000.00 4565 Bus 3.8 0 8988 Edu 2.1 0 3234 ACES 3.1 $100.00 4534 LAS 2.9 $10,000.00 Name Alice Bob 9 UID Financial Aid 1232 0 3234 $5,000.00 Acce...
View Full Document

This note was uploaded on 02/03/2014 for the course ECE 422 taught by Professor Nicol during the Fall '08 term at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online