VIPS BCA
Monday, September 22, 2014
Wednesday, April 2, 2014
Proposed DateSheet for BCA Externals
Proposed Date Sheet for Theory End Term Examinations
(May-June, 2014) for Programme: BCA — Regular & Reappear (Batch 2009 Onwards)
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
|
Thursday, March 6, 2014
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));
Subscribe to:
Posts (Atom)