Student Mark Analysis Database Information system Table creation

Create table per_rec, with attributes roll no, name ,age , sex, address, father name for student record, and create table mark list with reg no, mark1, mark2, mark3 up to mark6. Then create table col_recl.
Create Table Pl/Sql quries.
SQL> create table per_rec(rollno number(5) primary key,name varchar2(20),age number(2),sex char(1), address varchar2(20),father varchar2(20));
Table created.
SQL> create table marklist(reg_no number(10),mark1 number(3),mark2 number(3),mark3 number(3),mark4 number(3),mark5 number(3),mark6 number(3));
Table created.
SQL> create table col_rec1(rollno number(5),reg_no number(10),name varchar2(20),branch char(3) not null,year number(1),smester number(1));
Table created
SQL> create table result(reg_no number(10),percentage number(6,2),result varchar2(20),arrears number(2));
Table created.
Table Description for Student Mark Analysis Database Information with Desc
SQL> DESC PER_REC;
Name Null? Type
----------------- --------------- ------- ----
ROLLNO NOT NULL NUMBER(5)
NAME VARCHAR2(20)
AGE NUMBER(2)
SEX CHAR(1)
ADDRESS VARCHAR2(20)
FATHER VARCHAR2(20)

SQL> DESC COL_REC;
Name Null? Type
----------------- -------------- ------------
ROLLNO NUMBER(5)
REG_NO NUMBER(10)
NAME VARCHAR2(20)
BRANCH NOT NULL CHAR(3)
YEAR NUMBER(1)
SMESTER NUMBER(1)


SQL> DESC MARKLIST;
Name Null? Type
----------- -------- -----------------
REG_NO NUMBER(10)
MARK1 NUMBER(3)
MARK2 NUMBER(3)
MARK3 NUMBER(3)
MARK4 NUMBER(3)
MARK5 NUMBER(3)
MARK6 NUMBER(3)

SQL> DESC RESULT;
Name Null? Type
------------------- ------------ ------------
REG_NO NUMBER(10)
PERCENTAGE NUMBER(6,2)
RESULT VARCHAR2(20)
ARREARS NUMBER(2)
Source Code PL SQL Programming Student Mark Analysis Database Trigger Table crated successfully.

Related post