尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
CREATE TABLE “ADMIN"
( "USERID" VARCHAR2(15),
"NAME" VARCHAR2(25) NOT NULL ENABLE,
"PASSWORD" VARCHAR2(10) NOT NULL ENABLE,
PRIMARY KEY ("USERID") ENABLE
)
/
CREATE TABLE "BRANCH"
( "BRANCH_ID" VARCHAR2(3),
"BRANCH_NAME" VARCHAR2(3) NOT NULL ENABLE,
"DEPT_ID" VARCHAR2(3) NOT NULL ENABLE,
PRIMARY KEY ("BRANCH_ID") ENABLE,
FOREIGN KEY ("DEPT_ID")
REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE
)
/
CREATE TABLE "COURSE"
( "COURSE_ID" VARCHAR2(3),
"COURSE_NAME" VARCHAR2(3) NOT NULL ENABLE,
"BRANCH_ID" VARCHAR2(3) NOT NULL ENABLE,
PRIMARY KEY ("COURSE_ID") ENABLE,
FOREIGN KEY ("BRANCH_ID")
REFERENCES "BRANCH" ("BRANCH_ID") ENABLE
)
/
CREATE TABLE "DEPARTMENT"
( "DEPT_ID" VARCHAR2(3),
"DEPT_NAME" VARCHAR2(40) NOT NULL ENABLE,
PRIMARY KEY ("DEPT_ID") ENABLE
)
/
CREATE TABLE "FACULTY"
( "FACULTY_ID" VARCHAR2(15),
"FACULTY_NAME" VARCHAR2(20) NOT NULL ENABLE,
"PASSWORD" VARCHAR2(10) NOT NULL ENABLE,
"EMAIL" VARCHAR2(30) NOT NULL ENABLE,
"DESIGNATION" VARCHAR2(20) NOT NULL ENABLE,
"DEPT_ID" VARCHAR2(3) NOT NULL ENABLE,
PRIMARY KEY ("FACULTY_ID") ENABLE,
FOREIGN KEY ("DEPT_ID")
REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE
)
/
CREATE TABLE "FACULTY_FEEDBACK"
( "FEEDBACK_ID" NUMBER(5,0) NOT NULL ENABLE,
"FDATE" VARCHAR2(10) NOT NULL ENABLE,
"BRANCH" VARCHAR2(3) NOT NULL ENABLE,
"SEMESTER" VARCHAR2(3) NOT NULL ENABLE,
"FACULTY_NAME1" VARCHAR2(30) NOT NULL ENABLE,
"FACULTY_NAME2" VARCHAR2(30) NOT NULL ENABLE,
"FACULTY_NAME3" VARCHAR2(30) NOT NULL ENABLE,
"FACULTY_NAME4" VARCHAR2(30) NOT NULL ENABLE,
"FACULTY_NAME5" VARCHAR2(30) NOT NULL ENABLE,
"PLANNING1" NUMBER(5,0) NOT NULL ENABLE,
"PLANNING2" NUMBER(5,0) NOT NULL ENABLE,
"PLANNING3" NUMBER(5,0) NOT NULL ENABLE,
"PLANNING4" NUMBER(5,0) NOT NULL ENABLE,
"PLANNING5" NUMBER(5,0) NOT NULL ENABLE,
"EVALUTION1" NUMBER(5,0) NOT NULL ENABLE,
"EVALUTION2" NUMBER(5,0) NOT NULL ENABLE,
"EVALUTION3" NUMBER(5,0) NOT NULL ENABLE,
"EVALUTION4" NUMBER(5,0) NOT NULL ENABLE,
"EVALUTION5" NUMBER(5,0) NOT NULL ENABLE,
"EXECUTION1" NUMBER(5,0) NOT NULL ENABLE,
"EXECUTION2" NUMBER(5,0) NOT NULL ENABLE,
"EXECUTION3" NUMBER(5,0) NOT NULL ENABLE,
"EXECUTION4" NUMBER(5,0) NOT NULL ENABLE,
"EXECUTION5" NUMBER(5,0) NOT NULL ENABLE,
"QUALITY1" NUMBER(5,0) NOT NULL ENABLE,
"QUALITY2" NUMBER(5,0) NOT NULL ENABLE,
"QUALITY3" NUMBER(5,0) NOT NULL ENABLE,
"QUALITY4" NUMBER(5,0) NOT NULL ENABLE,
"QUALITY5" NUMBER(5,0) NOT NULL ENABLE,
"SUGGESTION" VARCHAR2(60),
PRIMARY KEY ("FEEDBACK_ID") ENABLE
)
/
CREATE OR REPLACE TRIGGER "DEPT_BIR2"
BEFORE INSERT ON faculty_feedback
FOR EACH ROW
WHEN (new.feedback_id IS NULL) BEGIN
SELECT faculty_seq.NEXTVAL
INTO :new.feedback_id
FROM dual;
END;
/
CREATE TABLE "LAB"
( "LAB_ID" VARCHAR2(3),
"LAB_NAME" VARCHAR2(20) NOT NULL ENABLE,
"DEPT_ID" VARCHAR2(3) NOT NULL ENABLE,
PRIMARY KEY ("LAB_ID") ENABLE,
FOREIGN KEY ("DEPT_ID")
REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE
)
/
CREATE TABLE "LAB_FEEDBACK"
( "COMPLAIN_ID" NUMBER(5,0),
"ENO" VARCHAR2(15),
"FACULTY_ID" VARCHAR2(15),
"DATE1" VARCHAR2(10) NOT NULL ENABLE,
"LAB" VARCHAR2(15) NOT NULL ENABLE,
"PC_NO" NUMBER(2,0) NOT NULL ENABLE,
"COMPLAIN_DETAIL" VARCHAR2(15) NOT NULL ENABLE,
"ORGANIZATION" VARCHAR2(10) NOT NULL ENABLE,
"MAINTENANCE" VARCHAR2(15) NOT NULL ENABLE,
"SUGGESTION" VARCHAR2(60),
PRIMARY KEY ("COMPLAIN_ID") ENABLE,
CONSTRAINT "LAB_FEEDBACK_CON2" UNIQUE ("ENO", "FACULTY_ID") ENABLE,
CONSTRAINT "LAB_FEEDBACK_CON" FOREIGN KEY ("ENO")
REFERENCES "STUDENT" ("ENO") ENABLE,
CONSTRAINT "LAB_FEEDBACK_CON1" FOREIGN KEY ("FACULTY_ID")
REFERENCES "FACULTY" ("FACULTY_ID") ENABLE
)
/
CREATE OR REPLACE TRIGGER "DEPT_BIR"
BEFORE INSERT ON lab_feedback
FOR EACH ROW
WHEN (new.complain_id IS NULL) BEGIN
SELECT lab_seq.NEXTVAL
INTO :new.complain_id
FROM dual;
END;
/
CREATE TABLE "LIBRARY_FEEDBACK"
( "FEEDBACK_ID" NUMBER(5,0),
"ENO" VARCHAR2(15),
"FACULTY_ID" VARCHAR2(15),
"DATE1" VARCHAR2(10) NOT NULL ENABLE,
"DEPARTMENT" VARCHAR2(15) NOT NULL ENABLE,
"BEHAVIOR" VARCHAR2(15) NOT NULL ENABLE,
"ORGANIZATION" VARCHAR2(15) NOT NULL ENABLE,
"BOOK_NOT_AVAIL" VARCHAR2(60) NOT NULL ENABLE,
"SUGGESTION" VARCHAR2(60),
PRIMARY KEY ("FEEDBACK_ID") ENABLE,
CONSTRAINT "LIBRARY_FEEDBACK_CON" UNIQUE ("ENO", "FACULTY_ID") ENABLE,
FOREIGN KEY ("ENO")
REFERENCES "STUDENT" ("ENO") ENABLE,
FOREIGN KEY ("FACULTY_ID")
REFERENCES "FACULTY" ("FACULTY_ID") ENABLE
)
/
CREATE OR REPLACE TRIGGER "DEPT_BIR1"
BEFORE INSERT ON library_feedback
FOR EACH ROW
WHEN (new.feedback_id IS NULL) BEGIN
SELECT lib_seq.NEXTVAL
INTO :new.feedback_id
FROM dual;
END;
/
CREATE TABLE "STUDENT"
( "ENO" VARCHAR2(15),
"S_NAME" VARCHAR2(25) NOT NULL ENABLE,
"PASSWORD" VARCHAR2(10) NOT NULL ENABLE,
"BRANCH_ID" VARCHAR2(3) NOT NULL ENABLE,
"SEMESTER" VARCHAR2(3) NOT NULL ENABLE,
"BATCH" VARCHAR2(9) NOT NULL ENABLE,
"COURSE_ID" VARCHAR2(3) NOT NULL ENABLE,
"ATTENDANCE" NUMBER NOT NULL ENABLE,
"SESION" NUMBER NOT NULL ENABLE,
PRIMARY KEY ("ENO") ENABLE,
FOREIGN KEY ("BRANCH_ID")
REFERENCES "BRANCH" ("BRANCH_ID") ENABLE,
FOREIGN KEY ("COURSE_ID")
REFERENCES "COURSE" ("COURSE_ID") ENABLE
)
/
CREATE TABLE "SUBJECT"
( "SUBJECT_CODE" VARCHAR2(6),
"SUBJECT_NAME" VARCHAR2(40) NOT NULL ENABLE,
"SEMESTER" VARCHAR2(3) NOT NULL ENABLE,
"FACULTY_ID" VARCHAR2(15) NOT NULL ENABLE,
PRIMARY KEY ("SUBJECT_CODE") ENABLE,
FOREIGN KEY ("FACULTY_ID")
REFERENCES "FACULTY" ("FACULTY_ID") ENABLE
)
/
Tables:
Admin
Branch
Course
Department
Faculty
Faculty_feedback
Lab
Lab_feedback
Library_Feedback
Student
Subject

More Related Content

What's hot

e computer notes - Including constraints
e computer notes - Including constraintse computer notes - Including constraints
e computer notes - Including constraints
ecomputernotes
 
Solr Anti - patterns
Solr Anti - patternsSolr Anti - patterns
Solr Anti - patterns
Rafał Kuć
 
The Human Linter
The Human LinterThe Human Linter
The Human Linter
Ilya Gelman
 
Exemple de création de base
Exemple de création de baseExemple de création de base
Exemple de création de base
Saber LAJILI
 
Web development today
Web development todayWeb development today
Web development today
Hesham Amin
 
Keeping It Simple
Keeping It SimpleKeeping It Simple
Keeping It Simple
Stephanie Leary
 
Migrare da symfony 1 a Symfony2
 Migrare da symfony 1 a Symfony2  Migrare da symfony 1 a Symfony2
Migrare da symfony 1 a Symfony2
Massimiliano Arione
 
e computer notes - Advanced subqueries
e computer notes - Advanced subqueriese computer notes - Advanced subqueries
e computer notes - Advanced subqueries
ecomputernotes
 
Criando tabelas
Criando tabelasCriando tabelas
Criando tabelas
renatofelixribeiro
 
00. instalasi dan penggunaan mysql
00. instalasi dan penggunaan mysql00. instalasi dan penggunaan mysql
00. instalasi dan penggunaan mysql
Fakhrian Fadlia Adiwijaya
 

What's hot (10)

e computer notes - Including constraints
e computer notes - Including constraintse computer notes - Including constraints
e computer notes - Including constraints
 
Solr Anti - patterns
Solr Anti - patternsSolr Anti - patterns
Solr Anti - patterns
 
The Human Linter
The Human LinterThe Human Linter
The Human Linter
 
Exemple de création de base
Exemple de création de baseExemple de création de base
Exemple de création de base
 
Web development today
Web development todayWeb development today
Web development today
 
Keeping It Simple
Keeping It SimpleKeeping It Simple
Keeping It Simple
 
Migrare da symfony 1 a Symfony2
 Migrare da symfony 1 a Symfony2  Migrare da symfony 1 a Symfony2
Migrare da symfony 1 a Symfony2
 
e computer notes - Advanced subqueries
e computer notes - Advanced subqueriese computer notes - Advanced subqueries
e computer notes - Advanced subqueries
 
Criando tabelas
Criando tabelasCriando tabelas
Criando tabelas
 
00. instalasi dan penggunaan mysql
00. instalasi dan penggunaan mysql00. instalasi dan penggunaan mysql
00. instalasi dan penggunaan mysql
 

Viewers also liked

School fee management
School fee managementSchool fee management
School fee management
JAI MCA-STUDENT
 
Fee collection system
Fee collection systemFee collection system
Fee collection system
harryz18
 
Synopsis of Fee Management System
Synopsis of Fee Management SystemSynopsis of Fee Management System
Synopsis of Fee Management System
Divya_Gupta19
 
Assumptions underlying accounting measurement
Assumptions underlying accounting measurementAssumptions underlying accounting measurement
Assumptions underlying accounting measurement
praveensureshpai
 
Online Fee Management - A Change in Traditional Fee Collection System
Online Fee Management - A Change in Traditional Fee Collection SystemOnline Fee Management - A Change in Traditional Fee Collection System
Online Fee Management - A Change in Traditional Fee Collection System
Smart Schooling
 
Fee managment system
Fee managment systemFee managment system
Fee managment system
fairy9912
 
Floods
FloodsFloods
Introduction and objectives of the project
Introduction and objectives of the projectIntroduction and objectives of the project
Introduction and objectives of the project
rihan696
 
School management system
School management systemSchool management system
School management system
asd143
 

Viewers also liked (9)

School fee management
School fee managementSchool fee management
School fee management
 
Fee collection system
Fee collection systemFee collection system
Fee collection system
 
Synopsis of Fee Management System
Synopsis of Fee Management SystemSynopsis of Fee Management System
Synopsis of Fee Management System
 
Assumptions underlying accounting measurement
Assumptions underlying accounting measurementAssumptions underlying accounting measurement
Assumptions underlying accounting measurement
 
Online Fee Management - A Change in Traditional Fee Collection System
Online Fee Management - A Change in Traditional Fee Collection SystemOnline Fee Management - A Change in Traditional Fee Collection System
Online Fee Management - A Change in Traditional Fee Collection System
 
Fee managment system
Fee managment systemFee managment system
Fee managment system
 
Floods
FloodsFloods
Floods
 
Introduction and objectives of the project
Introduction and objectives of the projectIntroduction and objectives of the project
Introduction and objectives of the project
 
School management system
School management systemSchool management system
School management system
 

Similar to Database

Oracle helpdesk database shema
Oracle helpdesk database shemaOracle helpdesk database shema
Oracle helpdesk database shema
Murat Gülci
 
Taller 3 camilo uribe2308542
Taller 3  camilo uribe2308542Taller 3  camilo uribe2308542
Taller 3 camilo uribe2308542
Kmilo U
 
Taller4
Taller4Taller4
Taller4
Johan Ospina
 
Taller4
Taller4Taller4
Taller4
Johan Ospina
 
DOODB_LAB.pptx
DOODB_LAB.pptxDOODB_LAB.pptx
DOODB_LAB.pptx
FilestreamFilestream
 
CreacióN Tablas En Oracle
CreacióN Tablas En OracleCreacióN Tablas En Oracle
CreacióN Tablas En Oracle
esacre
 
Les09
Les09Les09
SQL & PLSQL
SQL & PLSQLSQL & PLSQL
SQL & PLSQL
Prakash Poudel
 
Les09 (using ddl statements to create and manage tables)
Les09 (using ddl statements to create and manage tables)Les09 (using ddl statements to create and manage tables)
Les09 (using ddl statements to create and manage tables)
Achmad Solichin
 
SQL -PHP Tutorial
SQL -PHP TutorialSQL -PHP Tutorial
SQL -PHP Tutorial
Information Technology
 
Sql commands
Sql commandsSql commands
Sql commands
Christalin Nelson
 
vFabric SQLFire Introduction
vFabric SQLFire IntroductionvFabric SQLFire Introduction
vFabric SQLFire Introduction
Jags Ramnarayan
 
Unidad 4 actividad 1
Unidad 4 actividad 1Unidad 4 actividad 1
Unidad 4 actividad 1
KARY
 
Oracle trigger
Oracle triggerOracle trigger
Oracle trigger
nasrul28
 
Database
Database Database
SQLAlchemy Seminar
SQLAlchemy SeminarSQLAlchemy Seminar
SQLAlchemy Seminar
Yury Yurevich
 
Creating database using sql commands
Creating database using sql commandsCreating database using sql commands
Creating database using sql commands
Belle Wx
 
SQL Injection: Amplifying Data Leakeage
SQL Injection: Amplifying Data LeakeageSQL Injection: Amplifying Data Leakeage
SQL Injection: Amplifying Data Leakeage
Ulisses Castro
 
Less08 Schema
Less08 SchemaLess08 Schema
Less08 Schema
vivaankumar
 

Similar to Database (19)

Oracle helpdesk database shema
Oracle helpdesk database shemaOracle helpdesk database shema
Oracle helpdesk database shema
 
Taller 3 camilo uribe2308542
Taller 3  camilo uribe2308542Taller 3  camilo uribe2308542
Taller 3 camilo uribe2308542
 
Taller4
Taller4Taller4
Taller4
 
Taller4
Taller4Taller4
Taller4
 
DOODB_LAB.pptx
DOODB_LAB.pptxDOODB_LAB.pptx
DOODB_LAB.pptx
 
CreacióN Tablas En Oracle
CreacióN Tablas En OracleCreacióN Tablas En Oracle
CreacióN Tablas En Oracle
 
Les09
Les09Les09
Les09
 
SQL & PLSQL
SQL & PLSQLSQL & PLSQL
SQL & PLSQL
 
Les09 (using ddl statements to create and manage tables)
Les09 (using ddl statements to create and manage tables)Les09 (using ddl statements to create and manage tables)
Les09 (using ddl statements to create and manage tables)
 
SQL -PHP Tutorial
SQL -PHP TutorialSQL -PHP Tutorial
SQL -PHP Tutorial
 
Sql commands
Sql commandsSql commands
Sql commands
 
vFabric SQLFire Introduction
vFabric SQLFire IntroductionvFabric SQLFire Introduction
vFabric SQLFire Introduction
 
Unidad 4 actividad 1
Unidad 4 actividad 1Unidad 4 actividad 1
Unidad 4 actividad 1
 
Oracle trigger
Oracle triggerOracle trigger
Oracle trigger
 
Database
Database Database
Database
 
SQLAlchemy Seminar
SQLAlchemy SeminarSQLAlchemy Seminar
SQLAlchemy Seminar
 
Creating database using sql commands
Creating database using sql commandsCreating database using sql commands
Creating database using sql commands
 
SQL Injection: Amplifying Data Leakeage
SQL Injection: Amplifying Data LeakeageSQL Injection: Amplifying Data Leakeage
SQL Injection: Amplifying Data Leakeage
 
Less08 Schema
Less08 SchemaLess08 Schema
Less08 Schema
 

Recently uploaded

Keynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse CityKeynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse City
PJ Caposey
 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
chaudharyreet2244
 
(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"
MJDuyan
 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
Celine George
 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
Derek Wenmoth
 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
MattVassar1
 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
ShwetaGawande8
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
Infosec
 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
yarusun
 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
TechSoup
 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
khabri85
 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
Kalna College
 
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptxCapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
CapitolTechU
 
Opportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive themOpportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive them
EducationNC
 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
shabeluno
 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Quiz Club IIT Kanpur
 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
Celine George
 
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
220711130100 udita Chakraborty  Aims and objectives of national policy on inf...220711130100 udita Chakraborty  Aims and objectives of national policy on inf...
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
Kalna College
 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
nabaegha
 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
BiplabHalder13
 

Recently uploaded (20)

Keynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse CityKeynote given on June 24 for MASSP at Grand Traverse City
Keynote given on June 24 for MASSP at Grand Traverse City
 
nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...nutrition in plants chapter 1 class 7...
nutrition in plants chapter 1 class 7...
 
(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"
 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
 
Talking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual AidsTalking Tech through Compelling Visual Aids
Talking Tech through Compelling Visual Aids
 
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
INTRODUCTION TO HOSPITALS & AND ITS ORGANIZATION
 
How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...How to stay relevant as a cyber professional: Skills, trends and career paths...
How to stay relevant as a cyber professional: Skills, trends and career paths...
 
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
Get Success with the Latest UiPath UIPATH-ADPV1 Exam Dumps (V11.02) 2024
 
Accounting for Restricted Grants When and How To Record Properly
Accounting for Restricted Grants  When and How To Record ProperlyAccounting for Restricted Grants  When and How To Record Properly
Accounting for Restricted Grants When and How To Record Properly
 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
 
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptxCapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
CapTechTalks Webinar Slides June 2024 Donovan Wright.pptx
 
Opportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive themOpportunity scholarships and the schools that receive them
Opportunity scholarships and the schools that receive them
 
Slides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptxSlides Peluncuran Amalan Pemakanan Sihat.pptx
Slides Peluncuran Amalan Pemakanan Sihat.pptx
 
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT KanpurDiversity Quiz Prelims by Quiz Club, IIT Kanpur
Diversity Quiz Prelims by Quiz Club, IIT Kanpur
 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
 
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
220711130100 udita Chakraborty  Aims and objectives of national policy on inf...220711130100 udita Chakraborty  Aims and objectives of national policy on inf...
220711130100 udita Chakraborty Aims and objectives of national policy on inf...
 
managing Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptxmanaging Behaviour in early childhood education.pptx
managing Behaviour in early childhood education.pptx
 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
 

Database

  • 1. CREATE TABLE “ADMIN" ( "USERID" VARCHAR2(15), "NAME" VARCHAR2(25) NOT NULL ENABLE, "PASSWORD" VARCHAR2(10) NOT NULL ENABLE, PRIMARY KEY ("USERID") ENABLE ) / CREATE TABLE "BRANCH" ( "BRANCH_ID" VARCHAR2(3), "BRANCH_NAME" VARCHAR2(3) NOT NULL ENABLE, "DEPT_ID" VARCHAR2(3) NOT NULL ENABLE, PRIMARY KEY ("BRANCH_ID") ENABLE, FOREIGN KEY ("DEPT_ID") REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE ) / CREATE TABLE "COURSE" ( "COURSE_ID" VARCHAR2(3), "COURSE_NAME" VARCHAR2(3) NOT NULL ENABLE, "BRANCH_ID" VARCHAR2(3) NOT NULL ENABLE, PRIMARY KEY ("COURSE_ID") ENABLE, FOREIGN KEY ("BRANCH_ID") REFERENCES "BRANCH" ("BRANCH_ID") ENABLE ) / CREATE TABLE "DEPARTMENT" ( "DEPT_ID" VARCHAR2(3), "DEPT_NAME" VARCHAR2(40) NOT NULL ENABLE, PRIMARY KEY ("DEPT_ID") ENABLE ) / CREATE TABLE "FACULTY" ( "FACULTY_ID" VARCHAR2(15), "FACULTY_NAME" VARCHAR2(20) NOT NULL ENABLE, "PASSWORD" VARCHAR2(10) NOT NULL ENABLE, "EMAIL" VARCHAR2(30) NOT NULL ENABLE, "DESIGNATION" VARCHAR2(20) NOT NULL ENABLE, "DEPT_ID" VARCHAR2(3) NOT NULL ENABLE, PRIMARY KEY ("FACULTY_ID") ENABLE, FOREIGN KEY ("DEPT_ID") REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE ) / CREATE TABLE "FACULTY_FEEDBACK" ( "FEEDBACK_ID" NUMBER(5,0) NOT NULL ENABLE,
  • 2. "FDATE" VARCHAR2(10) NOT NULL ENABLE, "BRANCH" VARCHAR2(3) NOT NULL ENABLE, "SEMESTER" VARCHAR2(3) NOT NULL ENABLE, "FACULTY_NAME1" VARCHAR2(30) NOT NULL ENABLE, "FACULTY_NAME2" VARCHAR2(30) NOT NULL ENABLE, "FACULTY_NAME3" VARCHAR2(30) NOT NULL ENABLE, "FACULTY_NAME4" VARCHAR2(30) NOT NULL ENABLE, "FACULTY_NAME5" VARCHAR2(30) NOT NULL ENABLE, "PLANNING1" NUMBER(5,0) NOT NULL ENABLE, "PLANNING2" NUMBER(5,0) NOT NULL ENABLE, "PLANNING3" NUMBER(5,0) NOT NULL ENABLE, "PLANNING4" NUMBER(5,0) NOT NULL ENABLE, "PLANNING5" NUMBER(5,0) NOT NULL ENABLE, "EVALUTION1" NUMBER(5,0) NOT NULL ENABLE, "EVALUTION2" NUMBER(5,0) NOT NULL ENABLE, "EVALUTION3" NUMBER(5,0) NOT NULL ENABLE, "EVALUTION4" NUMBER(5,0) NOT NULL ENABLE, "EVALUTION5" NUMBER(5,0) NOT NULL ENABLE, "EXECUTION1" NUMBER(5,0) NOT NULL ENABLE, "EXECUTION2" NUMBER(5,0) NOT NULL ENABLE, "EXECUTION3" NUMBER(5,0) NOT NULL ENABLE, "EXECUTION4" NUMBER(5,0) NOT NULL ENABLE, "EXECUTION5" NUMBER(5,0) NOT NULL ENABLE, "QUALITY1" NUMBER(5,0) NOT NULL ENABLE, "QUALITY2" NUMBER(5,0) NOT NULL ENABLE, "QUALITY3" NUMBER(5,0) NOT NULL ENABLE, "QUALITY4" NUMBER(5,0) NOT NULL ENABLE, "QUALITY5" NUMBER(5,0) NOT NULL ENABLE, "SUGGESTION" VARCHAR2(60), PRIMARY KEY ("FEEDBACK_ID") ENABLE ) / CREATE OR REPLACE TRIGGER "DEPT_BIR2" BEFORE INSERT ON faculty_feedback FOR EACH ROW WHEN (new.feedback_id IS NULL) BEGIN SELECT faculty_seq.NEXTVAL INTO :new.feedback_id FROM dual; END; / CREATE TABLE "LAB" ( "LAB_ID" VARCHAR2(3), "LAB_NAME" VARCHAR2(20) NOT NULL ENABLE, "DEPT_ID" VARCHAR2(3) NOT NULL ENABLE, PRIMARY KEY ("LAB_ID") ENABLE, FOREIGN KEY ("DEPT_ID") REFERENCES "DEPARTMENT" ("DEPT_ID") ENABLE ) /
  • 3. CREATE TABLE "LAB_FEEDBACK" ( "COMPLAIN_ID" NUMBER(5,0), "ENO" VARCHAR2(15), "FACULTY_ID" VARCHAR2(15), "DATE1" VARCHAR2(10) NOT NULL ENABLE, "LAB" VARCHAR2(15) NOT NULL ENABLE, "PC_NO" NUMBER(2,0) NOT NULL ENABLE, "COMPLAIN_DETAIL" VARCHAR2(15) NOT NULL ENABLE, "ORGANIZATION" VARCHAR2(10) NOT NULL ENABLE, "MAINTENANCE" VARCHAR2(15) NOT NULL ENABLE, "SUGGESTION" VARCHAR2(60), PRIMARY KEY ("COMPLAIN_ID") ENABLE, CONSTRAINT "LAB_FEEDBACK_CON2" UNIQUE ("ENO", "FACULTY_ID") ENABLE, CONSTRAINT "LAB_FEEDBACK_CON" FOREIGN KEY ("ENO") REFERENCES "STUDENT" ("ENO") ENABLE, CONSTRAINT "LAB_FEEDBACK_CON1" FOREIGN KEY ("FACULTY_ID") REFERENCES "FACULTY" ("FACULTY_ID") ENABLE ) / CREATE OR REPLACE TRIGGER "DEPT_BIR" BEFORE INSERT ON lab_feedback FOR EACH ROW WHEN (new.complain_id IS NULL) BEGIN SELECT lab_seq.NEXTVAL INTO :new.complain_id FROM dual; END; / CREATE TABLE "LIBRARY_FEEDBACK" ( "FEEDBACK_ID" NUMBER(5,0), "ENO" VARCHAR2(15), "FACULTY_ID" VARCHAR2(15), "DATE1" VARCHAR2(10) NOT NULL ENABLE, "DEPARTMENT" VARCHAR2(15) NOT NULL ENABLE, "BEHAVIOR" VARCHAR2(15) NOT NULL ENABLE, "ORGANIZATION" VARCHAR2(15) NOT NULL ENABLE, "BOOK_NOT_AVAIL" VARCHAR2(60) NOT NULL ENABLE, "SUGGESTION" VARCHAR2(60), PRIMARY KEY ("FEEDBACK_ID") ENABLE, CONSTRAINT "LIBRARY_FEEDBACK_CON" UNIQUE ("ENO", "FACULTY_ID") ENABLE, FOREIGN KEY ("ENO") REFERENCES "STUDENT" ("ENO") ENABLE, FOREIGN KEY ("FACULTY_ID") REFERENCES "FACULTY" ("FACULTY_ID") ENABLE ) / CREATE OR REPLACE TRIGGER "DEPT_BIR1" BEFORE INSERT ON library_feedback FOR EACH ROW WHEN (new.feedback_id IS NULL) BEGIN SELECT lib_seq.NEXTVAL INTO :new.feedback_id
  • 4. FROM dual; END; / CREATE TABLE "STUDENT" ( "ENO" VARCHAR2(15), "S_NAME" VARCHAR2(25) NOT NULL ENABLE, "PASSWORD" VARCHAR2(10) NOT NULL ENABLE, "BRANCH_ID" VARCHAR2(3) NOT NULL ENABLE, "SEMESTER" VARCHAR2(3) NOT NULL ENABLE, "BATCH" VARCHAR2(9) NOT NULL ENABLE, "COURSE_ID" VARCHAR2(3) NOT NULL ENABLE, "ATTENDANCE" NUMBER NOT NULL ENABLE, "SESION" NUMBER NOT NULL ENABLE, PRIMARY KEY ("ENO") ENABLE, FOREIGN KEY ("BRANCH_ID") REFERENCES "BRANCH" ("BRANCH_ID") ENABLE, FOREIGN KEY ("COURSE_ID") REFERENCES "COURSE" ("COURSE_ID") ENABLE ) / CREATE TABLE "SUBJECT" ( "SUBJECT_CODE" VARCHAR2(6), "SUBJECT_NAME" VARCHAR2(40) NOT NULL ENABLE, "SEMESTER" VARCHAR2(3) NOT NULL ENABLE, "FACULTY_ID" VARCHAR2(15) NOT NULL ENABLE, PRIMARY KEY ("SUBJECT_CODE") ENABLE, FOREIGN KEY ("FACULTY_ID") REFERENCES "FACULTY" ("FACULTY_ID") ENABLE ) / Tables: Admin Branch
  翻译: