Thursday, July 25, 2013

SQL(LAB) Assignment 4 Queries's Answer


1. Create table Student with below given table structure and constraints. Datatype Constraints Remarks Roll_no Number(3) Primary Key  Unique identification number of student Name Varchar2(15) Unique Name of student Birth_Date Date Gender Varchar2(10) Not Null  Male or Female.

1. CREATE TABLE STUDENT
(ROLL_NO NUMBER(3) CONSTRAINT PK_RNO PRIMARY KEY,
NAME VARCHAR2(15) CONSTRAINT UN_NAME UNIQUE,