Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Database systems: Structured Query Language (SQL) – Nguyễn Ngọc Thiên An

In this chapter includes content as: SQL development: an overview; DDL: create, alter, drop; DML: select, insert, update, delete; DCL: commit, rollback, grant, revoke; assertions; triggers; views. Inviting you to refer lecture for more information. | DATABASE SYSTEMS . í 7 J t . kE - kl L_y_._____A __ _iJk _________ 5 STRUCTURED QUERY LANGUAGE Spring 2014 Nguyen Ngoc Thien An EMPLOYEE Fname Minit Lname SSN Bdate Address Sex Salary Super_SSN Dno DEPARTMENT Dname Dnumber Mgr_SSN Mgr_start_date 4 4 4 DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS_ON Essn Pno Hours 2 DEPENDENT Essn Dependent_name Sex Bdate Relationship One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super ssn Ono John B Smith 123456789 1 965-01 -09 731 Fondren Houston TX M 30000 333445555 5 Franklin T Wong 333445555 1 955-1 2-08 638 Voss Houston TX M 40000 888665555 5 Alicia J Zelaya 999887777 1 968-01 -19 3321 Castle Spring TX F 25000 987654321 4 Jennifer s Wallace 987654321 1 941 -06-20 291 Berry Bellaire TX F 43000 888665555 4 Ramesh K Narayan 666884444 1 962-09-1 5 975 Fire Oak Humble TX M 38000 333445555 5 Joyce A English 453453453 1 972-07-31 5631 Rico Houston TX F 25000 333445555 5 Ahmad V Jabbar 987987987 1 969-03-29 980 Dallas Houston TX M 25000 987654321 4 James E Borg 888665555 1 937-1 1-10 450 Stone Houston TX M 55000 N u LL 1 DEPARTMENT Dname Dnumber Mgr ssn Mgr start date Research 5 333445555 1 988-05-22 Administration 4 987654321 1 995-01 -O1 Headquarters 1 888665555 1 981 -06-1 9 DEPT LOCATIONS Dn umber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston WORKS ON Essn Pno Hours 123456789 1 32.5 123456789 2 7.5 666884444 3 40.0 453453453 1 20.0 453453453 2 20.0 333445555 2 1 0.0 333445555 3 1 0.0 333445555 1 o 1 0.0 333445555 20 1 0.0 999887777 30 30.0 999887777 1 o 1 0.0 987987987 1 o 35.0 987987987 30 5.0 987654321 30 20.0 987654321 20 1 5.0 888665555 20 NULL PROJ ECT Rname Rnumber Rlocation Dnum RroductX 1 Bellaire 5 Product Y 2 Sugarland 5 Rroductz 3 Houston 5 Computerization 1 o Stafford 4 Reorganization 20 Houston 1 Newbenefits 30 Stafford 4 DEPENDENT Essn Dependent name Sex Bdate Relationship 333445555 Alice