SP09-LecNotes-Jan29

SP09-LecNotes-Jan29 - MIS310-DUTTA-SPRING2009 Classnotes,...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MIS310-DUTTA-SPRING2009 Classnotes, Lecture 02, Jan29-2009 Lecture01 Summary o Relational model. What makes a table a relation o Primary, candidate, foreign keys o Entity Integrity Rule, referential Integrity, why you need them o Enforcing integrity rules using Access o SQL CREATE TABLE commands o Enforcing entity/referential integrity using SQL. Self Referencing Tables CREATE TABLE Faculty (FacSSN Char(11), FacLastname Char(15), FacFirstname Char(15), FacSupervisor Char(11), Primary Key (FacSSN),
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Foreign Key (FacSupervisor) References (Faculty));List the First and Last Names of All Students List the First and Last Names of All Employees SELECT EmpFirstname, Emplastname FROM Employee; List the records of all Seniors List the records of all Products costing more than $100 SELECT * FROM Product WHERE ProdPrice>100; List the First and Last Names of All Seniors List the Names of Products costing more than $100 SELECT ProdName FROM Product WHERE ProdPrice>100; List the Details of all assistant Professors
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/21/2011 for the course MIS 310 taught by Professor Staff during the Spring '08 term at George Mason.

Page1 / 4

SP09-LecNotes-Jan29 - MIS310-DUTTA-SPRING2009 Classnotes,...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online