例题

例题 - 1 SQL 1...

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

View Full Document Right Arrow Icon
习习习 1. . SQL ....... 1. .... Student..... Sno... SN... SA. 2. .... Course...... Cno.... CN..... CT. 3. ......... Sno.Cno ... G. ................................ 2. .. 1 ......... SQL ..... 1. ......... Student ......... 2. .... 3 ......... 3. ........... 1.. 3. ... 1 ............ SQL ....................................................... 4. .... SQL ........................ .6 .. 5. .................. .......... ........... ............... 1. .. E/R .............. 2. ................... 6. .............. .. S.... SNo.... SN... A. .. B... BNo... BN... P. ... L... LNo... LN... C. .... LBS.LNo.BNo.SNo.... Q. ........ SQL ......... ... L4..................... 7. .. 3 .......... 1. . 1NF... 2NF. 2. . 2NF... 3NF. 3. . 3NF... BCNF. ............................... 1.1. CREATE TABLE Student( 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Sno INT PRIMARY KEY, SN CHAR(30), SA INT ); 2) CREATE TABEL Course( Cno INT PRIMARY KEY, CN CHAR(30), CT CHAR(30) ); 3) CREATE TABEL SC( Sno INT, Cno INT, G INT, PRIMAYR KEY(Sno,Cno), FOREIGN KEY(Sno) REFERENCES Student(Sno), FOREIGN KEY(Cno) REFERENCES Course(Cno) ); 2.
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 01/09/2012 for the course CS CS273 taught by Professor Xifengyan during the Spring '11 term at UCSB.

Page1 / 8

例题 - 1 SQL 1...

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