Wednesday, April 2, 2014

Thursday, March 13, 2014

Monday, March 10, 2014

DBMS Lab Assignment 2 (JOIN)


Practical Lab Assignment based on Database Management System

BCA – II SEMESTER

Supplier-Parts-Projects Database
I.            Create the following  tables S, P, J and SPJ for the Supplier-Parts-Projects Database
with the following structures:


 S                       SUPPLIER  
Field name
Data type
Constraints

SNO
Varchar(5)
Primary key
SNAME
varchar(25)
NOT NULL
STATUS
int
NOT NULL
CITY
varchar(20)
NOT NULL
                                                                         






Saturday, February 22, 2014

SQL Queries


CREATE TABLE DEPT (DEPTNO NUMERIC(2) PRIMARY KEY, DNAME VARCHAR(20), LOC VARCHAR(10));

CREATE TABLE EMP (EMPNO NUMERIC(4) PRIMARY KEY, ENAME VARCHAR(20) NOT NULL, JOB CHAR(10), MGR NUMERIC(4), HIREDATE SMALLDATETIME, SAL NUMERIC(9,2), COMM NUMERIC(7,2) , DEPTNO NUMERIC(2) FOREIGN KEY REFERENCES DEPT(DEPTNO));