Guest User

Untitled

a guest
Apr 25th, 2012
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. Creating Tables
  2. Person(ssn NUMERIC(9), name VARCHAR(40), gender CHAR(1)), ssn is primary key
  3.  
  4. Organization(org_code CHAR(4), budget INTEGER, org_name VARCHAR(60)), org_code is primary key
  5.  
  6. Person_Organization(ssn, org_code), both columns are the primary key.
  7.  
  8. CREATE TABLE person_organization(ssn NUMERIC(9), org_code VARCHAR(60));
  9.  
  10. create table person_organization
  11. ( ssn number(9)
  12. , org_code varchar2(60)
  13. , constraint person_organization_pk primary key (ssn, org_code)
  14. , constraint person_organization_ssn_fk foreign key ( ssn )
  15. references person ( ssn )
  16. , constraint person_organization_oc_fk foreign key ( org_code )
  17. references organization ( org_code )
  18. );
  19.  
  20. CREATE TABLE Persons (
  21. ssn int(9) NOT NULL PRIMARY KEY,
  22. name varchar(40),
  23. gender CHAR(1)
  24. )
  25.  
  26. CREATE TABLE Organization (
  27. org_code CHAR(4)NOT NULL PRIMARY KEY,
  28. budget INTEGER,
  29. org_name VARCHAR(60)
  30. )
  31.  
  32. CREATE TABLE Person_Organization (
  33. ssn int FOREIGN KEY REFERENCES Persons(ssn),
  34. org_code CHAR FOREIGN KEY REFERENCES Organization(org_code)
Advertisement
Add Comment
Please, Sign In to add comment