M

@Mo_10854

V_Employee

SQL
4 years ago
-- create a table CREATE TABLE EMPLOYEE ( EMPNO int NOT NULL, ENAME VARCHAR(10), JOB VARCHAR(9), MGR int, HIREDATE DATE, SAL int, COMM int, DEPTNO int );

Employees Table

SQL
4 years ago
-- create a table CREATE TABLE EMPLOYEE ( EMPNO int NOT NULL, ENAME VARCHAR(10), JOB VARCHAR(9), MGR int, HIREDATE DATE, SAL int, COMM int, DEPTNO int );

CTU_10854

SQL
4 years ago
-- create a table CREATE TABLE Course ( courseID INT IDENTITY (1, 1) PRIMARY KEY, courseName varcher (255) NOT NULL, courseDesc varchar (25) NOT NULL ); -- create a table CREATE TABLE Students (

Class Exercise

SQL
4 years ago
-- create a table CREATE TABLE branches ( Bcode INTEGER PRIMARY KEY, Bname varchar (40) NOT NULL, ); create table (Sname varchar(20), Sids int , Slocation varchar(50), primary key (Sids,Slocation)); insert INTO branches values(100, 'JHB')

Primary Key Class Exercise

SQL
4 years ago
create table Dept (Dno int primary key, Dname varchar(30), Dloc varchar(50)) insert dept values (10,'IT','JHB') insert dept values (20,'FIN','JHB') insert dept values (30,'SALES','JHB') select * from Dept create table Employee (Eid int primary ke

#3 Customers

SQL
4 years ago
CREATE TABLE customers ( customer_id int NOT NULL, last_name char(50) NOT NULL, first_name char(50) NOT NULL, favorite_website char(50), CONSTRAINT customers_pk PRIMARY KEY (customer_id) ); CREATE TABLE orders ( order_id int NOT NULL, customer_

#2 City

SQL
4 years ago
CREATE TABLE suppliers ( supplier_id int NOT NULL, supplier_name char(50) NOT NULL, city char(50), state char(25), CONSTRAINT suppliers_pk PRIMARY KEY (supplier_id) ); INSERT INTO suppliers (supplier_id, supplier_name, city, state) VALU

#1 Salary

SQL
4 years ago
CREATE TABLE employees ( employee_number int NOT NULL, last_name char(50) NOT NULL, first_name char(50) NOT NULL, salary int, dept_id int, CONSTRAINT employees_pk PRIMARY KEY (employee_number) ); INSERT INTO employees (employee_number,

Student_Roll

SQL
4 years ago
CREATE TABLE Student_Roll ( Roll_No PRIMARY KEY, Name INTEGER, Address Address, Phone Phone, Age Age ); -- insert some values INSERT INTO Student_Roll VALUES ('1', 'Harsh', 'Delhi', 'XXXXXXXXXX', '18');

Joining Exercise

SQL
4 years ago
CREATE TABLE Student_Roll ( Roll_No PRIMARY KEY, Name INTEGER, Address Address, Phone Phone, Age Age ); -- insert some values INSERT INTO Student_Roll VALUES ('1', 'Harsh', 'Delhi', 'XXXXXXXXXX', '18');

Student_Course

SQL
4 years ago
-- create a table CREATE TABLE Student_Course ( Course_ID INTEGER, Roll_No PRIMARY KEY ); -- insert some values INSERT INTO Student_Course VALUES ('1', '1'); INSERT INTO Student_Course VALUES ('2', '2'); INSERT INTO Student_Course VALU

Data Type

SQL
4 years ago
CREATE TABLE Time ( dataType VARCHAR (30) PRIMARY KEY, Format VARCHAR (30), Storage size bytes INTEGER ); -- insert some values INSERT INTO Time VALUES ('date', 'YYYY-MM-DD', '3'); INSERT INTO Time VALUES ('smalldatetime', 'YYYY-MM-DD hh:mm

OrderID

SQL
4 years ago
CREATE TABLE Orders ( orderID INTEGER PRIMARY KEY, CustomerID INTEGER, OrderDate INTEGER ); -- insert some values INSERT INTO Orders VALUES ('10308', '2', '1996-09-18'); INSERT INTO Orders VALUES ('10309', '37', '1996-09-19'); INSERT INTO O

CustomerID

SQL
4 years ago
CREATE TABLE Customers ( CustomerID INTEGER PRIMARY KEY, CustomerName VARCHAR (30), ContactName VARCHAR (30), Country VARCHAR (30) ); -- insert some values INSERT INTO Customers VALUES ('1', 'Alfreds Futterkiste', 'Maria Anders', 'Germany

Products

SQL
4 years ago
CREATE TABLE Products ( product_ID INTEGER PRIMARY KEY, product_name VARCHAR (30), category_ID INTEGER, model_year YEAR, list_price decimal (4,2) ); -- insert some values INSERT INTO Products VALUES ('280', 'Trek Superfly 24 - 2017

Projects

SQL
4 years ago
CREATE TABLE Projects ( ProjectID INTEGER, Title INTEGER, ClientID INTEGER, EmployeeID PRIMARY KEY, StartDate INTEGER, EndDate INTEGER ); -- insert some values

Employee

SQL
4 years ago
-- create a table CREATE TABLE employee (id int, name varchar (30), department varchar (30), Salary int, gender varchar (30), age int, city varchar(30)); -- insert some values INSERT INTO employee VALUES (1001, 'Jane Doe', 'IT', '35000', 'Male', '2

Orders Table

SQL
4 years ago
-- create a table CREATE TABLE orders (orderID int, orderNumber int, PersonID int); -- insert some values INSERT INTO orders VALUES (1, '77895', '3'); INSERT INTO orders VALUES (2, '44678', '3'); INSERT INTO orders VALUES (3, '22456', '2'); INSERT

PersonsID

SQL
4 years ago
-- create a table CREATE TABLE persons (personID int, Lname varchar(30), Fname varchar(30), Age int); -- insert some values INSERT INTO persons VALUES (1, 'Hansen', 'Ola','30'); INSERT INTO persons VALUES (2, 'Svendson', 'Tove', '23'); INSERT INTO