image.png

Instruction

  1. name    sql
  2. countries    
  3. CREATE TABLE countries(
  4. country_id varchar(2) primary key  not null,
  5. country_name varchar(40) not null,
  6. region_id integer(2) not null)
  8. regions    
  9. CREATE TABLE regions(
  10. region_id integer(2) primary key not null,
  11. region_name varchar(25) not null)
  13. locations    
  14. CREATE TABLE locations(
  15. location_id integer(4) primary key not null,
  16. street_address varchar(25) not null,
  17. postal_code varchar(12),
  18. city varchar(30) not null,
  19. state_province varchar(12),
  20. country_id varchar(2))
  22. departments    
  23. CREATE TABLE departments(
  24. department_id integer(3) primary key not null,
  25. depart_name varchar(20) not null,
  26. manager_id integer(3) not null,
  27. location_id integer(4))
  29. jobs    
  30. CREATE TABLE jobs(
  31. job_id varchar(10) primary key not null,
  32. job_title varchar(25) not null,
  33. min_salary decimal,
  34. max_salary decimal)
  36. employees    
  37. CREATE TABLE employees(
  38. employee_id integer(3) primary key not null,
  39. first_name varchar(20),
  40. last_name varchar(25),
  41. email varchar(25),
  42. phone_number varchar(20),
  43. hire_date date,
  44. job_id varchar(10) not null,
  45. salary decimal,
  46. commission_pct number,
  47. manager_id integer(3),
  48. department_id integer(3), Avg_Salary NUMERIC)
  50. department    
  51. CREATE TABLE department(
  52.   "department_id" TEXT,
  53.   "department_name" TEXT,
  54.   "manager_id" TEXT,
  55.   "location_id" TEXT
  56. )
  58. job_history    
  59. CREATE TABLE job_history(
  60. employee_id integer(3) not null,
  61. start_date date not null,
  62. end_date date not null,
  63. job_id varchar(10) not null,
  64. department_id integer(3) not null)
  66. prod_mast    
  67. CREATE TABLE prod_mast(
  68. prod_id integer PRIMARY KEY,
  69. prod_name text(20),
  70. prod_rate integer,
  71. prod_qc text(20) DEFAULT 'OK')
  73. prod_backup    
  74. CREATE TABLE prod_backup(
  75. prod_id integer PRIMARY KEY,
  76. prod_name text(20),
  77. prod_rate integer,
  78. prod_qc text(10) DEFAULT 'OK')
  80. orders    
  81. CREATE TABLE orders(
  82. ord_no integer PRIMARY KEY,
  83. item_id integer ,
  84. item_name text(20),
  85. ord_qty integer,
  86. cost integer)
  88. tb1    
  89. CREATE TABLE tb1 (c1 INT, c2 CHAR(5), c3 FLOAT)
  91. ESERCICIO1    
  92. CREATE TABLE ESERCICIO1(C TEXT, D TEXT)
  94. users    
  95. CREATE TABLE users(name varchar(128), email varchar(128))
  97. tags    
  98. CREATE TABLE tags (
  99.     title TEXT,
  100.     description TEXT,
  101.     created TEXT
  102. )
  104. s    
  105. CREATE TABLE s( A int, D int, E int)
  107. r    
  108. CREATE TABLE r (A int, B int)
  110. Emor    
  111. CREATE TABLE Emor(
  112. ID INT PRIMARY KEY NOT NULL,
  113. NAME TEXT)
  115. MIN_SALARY    
  116. CREATE TABLE MIN_SALARY(job_id TEXT,MIN_SALARY)
  118. employee_data    
  119. CREATE TABLE employee_data (employee_name TEXT, item TEXT, rate REAL, quantity INTEGER, date TEXT, id INTEGER PRIMARY KEY)
  121. STUDENT    
  122. CREATE TABLE STUDENT(  
  123.    ID INT PRIMARY KEY     NOT NULL,  
  124.    NAME           TEXT    NOT NULL,  
  125.    AGE            INT     NOT NULL,  
  126.    ADDRESS        CHAR(50),  
  127.    FEES         REAL  
  128. )
  130. EMPLOYEE_INCOME    
  131. CREATE TABLE EMPLOYEE_INCOME 
  132. (EMPID NUMBER(10), 
  133. NAME VARCHAR2(20), 
  134. SALARY NUMBER(10))
  136. details    CREATE TABLE details
  137. (id      number(8,0),
  138. name     varchar2(50),
  139. weight   number(8,0),
  140. turn     number(8,0)
  141. )