SQL> set linesize 200

SQL> set pagesize 200

SQL> cle scr

SQL>
SQL>
SQL> -- Horizental Fregmentation
SQL>
SQL> select distinct department_id from employees;

DEPARTMENT_ID

-------------

50

40

110

90

30

70

10

20

60

100

80

12 rows selected.

SQL> select distinct job_id from employees;

JOB_ID

----------

AC_ACCOUNT

AC_MGR

AD_ASST

AD_PRES

AD_VP

FI_ACCOUNT
FI_MGR

HR_REP

IT_PROG

MK_MAN

MK_REP

PR_REP

PU_CLERK

PU_MAN

SA_MAN

SA_REP

SH_CLERK

ST_CLERK

ST_MAN

19 rows selected.

SQL> select employee_id from employees;

EMPLOYEE_ID

-----------

100

101

102

103

104

105

106

107

108

109

110

111
112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141
142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170
171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200
 201

202

203

204

205

206

301

302

501

110 rows selected.

SQL> cle scr

SQL> create table emp1

2 as
3 select * from employees
4 where employee_id between 100 and 150;

Table created.

SQL> create table emp2

2 as
3 select * from employees
4 where employee_id between 151 and 200;

Table created.

SQL> create table emp3

2 as
3 select * from employees
4 where employee_id > 200;

Table created.

SQL> -- horizental fregmentation

SQL> -- completeness constraint
SQL> -- disjoin constraint
SQL> select count(*) from employees;

COUNT(*)

----------

110

SQL> select * from emp1

2 union
 3 select * from emp2
4 union
5 select * from emp3;

EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL

PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID
DEPARTMENT_ID
----------- -------------------- -------------------------
------------------------- -------------------- --------- ---------- ----------
-------------- ---------- -------------
100 Steven King SKING
515.123.4567 17-JUN-03 AD_PRES 24000
90
101 Neena Kochhar NKOCHHAR
515.123.4568 21-SEP-05 AD_VP 17000 100
90
102 Lex De Haan LDEHAAN
515.123.4569 13-JAN-01 AD_VP 17000 100
90
103 Alexander Hunold AHUNOLD
590.423.4567 03-JAN-06 IT_PROG 9000 102
60
104 Bruce Ernst BERNST
590.423.4568 21-MAY-07 IT_PROG 6000 103
60
105 David Austin DAUSTIN
590.423.4569 25-JUN-05 IT_PROG 4800 103
60
106 Valli Pataballa VPATABAL
590.423.4560 05-FEB-06 IT_PROG 4800 103
60
107 Diana Lorentz DLORENTZ
590.423.5567 07-FEB-07 IT_PROG 4200 103
60
108 Nancy Greenberg NGREENBE
515.124.4569 17-AUG-02 FI_MGR 12008 101
100
109 Daniel Faviet DFAVIET
515.124.4169 16-AUG-02 FI_ACCOUNT 9000 108
100
110 John Chen JCHEN
515.124.4269 28-SEP-05 FI_ACCOUNT 8200 108
100
111 Ismael Sciarra ISCIARRA
515.124.4369 30-SEP-05 FI_ACCOUNT 7700 108
100
112 Jose Manuel Urman JMURMAN
515.124.4469 07-MAR-06 FI_ACCOUNT 7800 108
100
113 Luis Popp LPOPP
515.124.4567 07-DEC-07 FI_ACCOUNT 6900 108
100
114 Den Raphaely DRAPHEAL
515.127.4561 07-DEC-02 PU_MAN 11000 100
30
115 Alexander Khoo AKHOO
515.127.4562 18-MAY-03 PU_CLERK 3100 114
30
116 Shelli Baida SBAIDA
515.127.4563 24-DEC-05 PU_CLERK 2900 114
30
117 Sigal Tobias STOBIAS
515.127.4564 24-JUL-05 PU_CLERK 2800 114
30
118 Guy Himuro GHIMURO
515.127.4565 15-NOV-06 PU_CLERK 2600 114
30
119 Karen Colmenares KCOLMENA
515.127.4566 10-AUG-07 PU_CLERK 2500 114
30
120 Matthew Weiss MWEISS
650.123.1234 18-JUL-04 ST_MAN 8000 100
50
121 Adam Fripp AFRIPP
650.123.2234 10-APR-05 ST_MAN 8200 100
50
122 Payam Kaufling PKAUFLIN
650.123.3234 01-MAY-03 ST_MAN 7900 100
50
123 Shanta Vollman SVOLLMAN
650.123.4234 10-OCT-05 ST_MAN 6500 100
50
124 Kevin Mourgos KMOURGOS
650.123.5234 16-NOV-07 ST_MAN 5800 100
50
125 Julia Nayer JNAYER
650.124.1214 16-JUL-05 ST_CLERK 3200 120
50
126 Irene Mikkilineni IMIKKILI
650.124.1224 28-SEP-06 ST_CLERK 2700 120
50
127 James Landry JLANDRY
650.124.1334 14-JAN-07 ST_CLERK 2400 120
50
128 Steven Markle SMARKLE
650.124.1434 08-MAR-08 ST_CLERK 2200 120
50
129 Laura Bissot LBISSOT
650.124.5234 20-AUG-05 ST_CLERK 3300 121
50
130 Mozhe Atkinson MATKINSO
650.124.6234 30-OCT-05 ST_CLERK 2800 121
50
131 James Marlow JAMRLOW
650.124.7234 16-FEB-05 ST_CLERK 2500 121
50
132 TJ Olson TJOLSON
650.124.8234 10-APR-07 ST_CLERK 2100 121
50
133 Jason Mallin JMALLIN
650.127.1934 14-JUN-04 ST_CLERK 3300 122
50
134 Michael Rogers MROGERS
650.127.1834 26-AUG-06 ST_CLERK 2900 122
50
135 Ki Gee KGEE
650.127.1734 12-DEC-07 ST_CLERK 2400 122
50
 136 Hazel Philtanker HPHILTAN
650.127.1634 06-FEB-08 ST_CLERK 2200 122
50
137 Renske Ladwig RLADWIG
650.121.1234 14-JUL-03 ST_CLERK 3600 123
50
138 Stephen Stiles SSTILES
650.121.2034 26-OCT-05 ST_CLERK 3200 123
50
139 John Seo JSEO
650.121.2019 12-FEB-06 ST_CLERK 2700 123
50
140 Joshua Patel JPATEL
650.121.1834 06-APR-06 ST_CLERK 2500 123
50
141 Trenna Rajs TRAJS
650.121.8009 17-OCT-03 ST_CLERK 3500 124
50
142 Curtis Davies CDAVIES
650.121.2994 29-JAN-05 ST_CLERK 3100 124
50
143 Randall Matos RMATOS
650.121.2874 15-MAR-06 ST_CLERK 2600 124
50
144 Peter Vargas PVARGAS
650.121.2004 09-JUL-06 ST_CLERK 2500 124
50
145 John Russell JRUSSEL
011.44.1344.429268 01-OCT-04 SA_MAN 14000 .4 100
80
146 Karen Partners KPARTNER
011.44.1344.467268 05-JAN-05 SA_MAN 13500 .3 100
80
147 Alberto Errazuriz AERRAZUR
011.44.1344.429278 10-MAR-05 SA_MAN 12000 .3 100
80
148 Gerald Cambrault GCAMBRAU
011.44.1344.619268 15-OCT-07 SA_MAN 11000 .3 100
80
149 Eleni Zlotkey EZLOTKEY
011.44.1344.429018 29-JAN-08 SA_MAN 10500 .2 100
80
150 Peter Tucker PTUCKER
011.44.1344.129268 30-JAN-05 SA_REP 10000 .3 145
80
151 David Bernstein DBERNSTE
011.44.1344.345268 24-MAR-05 SA_REP 9500 .25 145
80
152 Peter Hall PHALL
011.44.1344.478968 20-AUG-05 SA_REP 9000 .25 145
80
153 Christopher Olsen COLSEN
011.44.1344.498718 30-MAR-06 SA_REP 8000 .2 145
80
154 Nanette Cambrault NCAMBRAU
011.44.1344.987668 09-DEC-06 SA_REP 7500 .2 145
80
155 Oliver Tuvault OTUVAULT
011.44.1344.486508 23-NOV-07 SA_REP 7000 .15 145
80
156 Janette King JKING
011.44.1345.429268 30-JAN-04 SA_REP 10000 .35 146
80
157 Patrick Sully PSULLY
011.44.1345.929268 04-MAR-04 SA_REP 9500 .35 146
80
158 Allan McEwen AMCEWEN
011.44.1345.829268 01-AUG-04 SA_REP 9000 .35 146
80
159 Lindsey Smith LSMITH
011.44.1345.729268 10-MAR-05 SA_REP 8000 .3 146
80
160 Louise Doran LDORAN
011.44.1345.629268 15-DEC-05 SA_REP 7500 .3 146
80
161 Sarath Sewall SSEWALL
011.44.1345.529268 03-NOV-06 SA_REP 7000 .25 146
80
162 Clara Vishney CVISHNEY
011.44.1346.129268 11-NOV-05 SA_REP 10500 .25 147
80
163 Danielle Greene DGREENE
011.44.1346.229268 19-MAR-07 SA_REP 9500 .15 147
80
164 Mattea Marvins MMARVINS
011.44.1346.329268 24-JAN-08 SA_REP 7200 .1 147
80
165 David Lee DLEE
011.44.1346.529268 23-FEB-08 SA_REP 6800 .1 147
80
166 Sundar Ande SANDE
011.44.1346.629268 24-MAR-08 SA_REP 6400 .1 147
80
167 Amit Banda ABANDA
011.44.1346.729268 21-APR-08 SA_REP 6200 .1 147
80
168 Lisa Ozer LOZER
011.44.1343.929268 11-MAR-05 SA_REP 11500 .25 148
80
169 Harrison Bloom HBLOOM
011.44.1343.829268 23-MAR-06 SA_REP 10000 .2 148
80
170 Tayler Fox TFOX
011.44.1343.729268 24-JAN-06 SA_REP 9600 .2 148
80
171 William Smith WSMITH
011.44.1343.629268 23-FEB-07 SA_REP 7400 .15 148
80
172 Elizabeth Bates EBATES
011.44.1343.529268 24-MAR-07 SA_REP 7300 .15 148
80
173 Sundita Kumar SKUMAR
011.44.1343.329268 21-APR-08 SA_REP 6100 .1 148
80
174 Ellen Abel EABEL
011.44.1644.429267 11-MAY-04 SA_REP 11000 .3 149
80
175 Alyssa Hutton AHUTTON
011.44.1644.429266 19-MAR-05 SA_REP 8800 .25 149
80
176 Jonathon Taylor JTAYLOR
011.44.1644.429265 24-MAR-06 SA_REP 8600 .2 149
80
177 Jack Livingston JLIVINGS
011.44.1644.429264 23-APR-06 SA_REP 8400 .2 149
80
178 Kimberely Grant KGRANT
011.44.1644.429263 24-MAY-07 SA_REP 7000 .15 149

179 Charles Johnson CJOHNSON

011.44.1644.429262 04-JAN-08 SA_REP 6200 .1 149
80
180 Winston Taylor WTAYLOR
650.507.9876 24-JAN-06 SH_CLERK 3200 120
50
181 Jean Fleaur JFLEAUR
650.507.9877 23-FEB-06 SH_CLERK 3100 120
50
182 Martha Sullivan MSULLIVA
650.507.9878 21-JUN-07 SH_CLERK 2500 120
50
183 Girard Geoni GGEONI
650.507.9879 03-FEB-08 SH_CLERK 2800 120
50
184 Nandita Sarchand NSARCHAN
650.509.1876 27-JAN-04 SH_CLERK 4200 121
50
185 Alexis Bull ABULL
650.509.2876 20-FEB-05 SH_CLERK 4100 121
50
186 Julia Dellinger JDELLING
650.509.3876 24-JUN-06 SH_CLERK 3400 121
50
187 Anthony Cabrio ACABRIO
650.509.4876 07-FEB-07 SH_CLERK 3000 121
50
188 Kelly Chung KCHUNG
650.505.1876 14-JUN-05 SH_CLERK 3800 122
50
189 Jennifer Dilly JDILLY
650.505.2876 13-AUG-05 SH_CLERK 3600 122
50
190 Timothy Gates TGATES
650.505.3876 11-JUL-06 SH_CLERK 2900 122
50
191 Randall Perkins RPERKINS
650.505.4876 19-DEC-07 SH_CLERK 2500 122
50
192 Sarah Bell SBELL
650.501.1876 04-FEB-04 SH_CLERK 4000 123
50
193 Britney Everett BEVERETT
650.501.2876 03-MAR-05 SH_CLERK 3900 123
50
194 Samuel McCain SMCCAIN
650.501.3876 01-JUL-06 SH_CLERK 3200 123
50
 195 Vance Jones VJONES
650.501.4876 17-MAR-07 SH_CLERK 2800 123
50
196 Alana Walsh AWALSH
650.507.9811 24-APR-06 SH_CLERK 3100 124
50
197 Kevin Feeney KFEENEY
650.507.9822 23-MAY-06 SH_CLERK 3000 124
50
198 Donald OConnell DOCONNEL
650.507.9833 21-JUN-07 SH_CLERK 2600 124
50
199 Altaf Grant DGRANT
650.507.9844 13-JAN-08 SH_CLERK 2600 124
50
200 Jennifer Whalen JWHALEN
515.123.4444 17-SEP-03 AD_ASST 4400 101
10
201 Sami Hartstein MHARTSTE
515.123.5555 17-FEB-04 MK_MAN 13000 100
20
202 Pat Fay PFAY
603.123.6666 17-AUG-05 MK_REP 6000 201
20
203 Susan Mavris SMAVRIS
515.123.7777 07-JUN-02 HR_REP 6500 101
40
204 Hermann Baer HBAER
515.123.8888 07-JUN-02 PR_REP 10000 101
70
205 Shelley Higgins SHIGGINS
515.123.8080 07-JUN-02 AC_MGR 12008 101
110
206 William Gietz WGIETZ
515.123.8181 07-JUN-02 AC_ACCOUNT 8300 205
110
301 Asad abccdd
01-SEP-18 IT_PROG 20

302 jAMIL DFDFD

01-SEP-18 IT_PROG 20

501 Saad Khan adfdecddf

01-SEP-08 IT_PROG 19500 20

110 rows selected.

SQL> cle scr

SQL> select * from emp1

2 intersect
3 select * from emp2
4 intersect
5 select * from emp3;

no rows selected

SQL> spool off;

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"[Link]
<html xmlns="[Link]
<head>
<!-- Showing Alert Message On Page load For feed Back-->

<script type="text/javascript">
function alertUser(msg) {
alert(msg);
}
</script>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Student Console</title>
<!-- CSS -->
<!-- Reset Stylesheet -->
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<!-- Main Stylesheet -->
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<!--[if lte IE 7]>
<link rel="stylesheet" href="BOT_Theme/resources/css/style-
[Link]" type="text/css" media="screen" />
<![endif]-->
<!-- Invalid Stylesheet. This makes stuff look pretty. Remove it if you want
the CSS completely valid -->
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<!-- Colour Schemes

Default colour scheme is green. Uncomment prefered stylesheet to use

it.-->
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<link rel="stylesheet" href='/BOT_Theme/resources/css/[Link]'
type="text/css" media="screen" />
<!--<link rel="stylesheet" href="~/resources/css/[Link]" type="text/css"
media="screen" />

-->
<!-- Global site tag ([Link]) - Google Analytics
<script async src="[Link]
1"></script>
<script>
[Link] = [Link] || [];
function gtag(){[Link](arguments);}
gtag('js', new Date());

gtag('config', 'UA-102182566-1');
</script>
-->
<!-- Internet Explorer Fixes Stylesheet -->
 <!--[if lte IE 7]>
<link rel="stylesheet"
href="~/BOT_Theme/resources/css/[Link]" type="text/css" media="screen" />
<![endif]-->
<!-- Javascripts -->
<!-- jQuery -->

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/[Link]"></script>

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/[Link]"></script>

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/window_ext.js"></script>

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/[Link]"></script>

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/[Link]"></script>

<script type="text/javascript"
src="~/BOT_Theme/resources/scripts/extended_debug.js"></script>

<script type="text/javascript" src='/BOT_Theme/resources/scripts/jquery-

[Link]'></script>

<!-- jQuery Configuration -->

<script type="text/javascript"
src='/BOT_Theme/resources/scripts/[Link]'></script>

<!-- Facebox jQuery Plugin -->

<script type="text/javascript"
src='/BOT_Theme/resources/scripts/[Link]'></script>

<!-- jQuery WYSIWYG Plugin -->

<script type="text/javascript"
src='/BOT_Theme/resources/scripts/[Link]'></script>

<!-- Internet Explorer .png-fix -->

<!--[if IE 6]>
<script type="text/javascript"
src="~/resources/scripts/DD_belatedPNG_0.[Link]"></script>
<script type="text/javascript">
DD_belatedPNG.fix('.png_bg, img, li');
</script>
<![endif]-->

<script type="text/javascript" language="javascript">

function ShowResultCard() {
var win = new Window({ className: "spread", title: "Ruby on Rails",
top: 70, left: 100, width: 300, height: 200, url: "[Link]
showEffectOptions: { duration: 1.5} }); [Link]();
}
 </script>

<script type="text/javascript" language="javascript">

function CloseNotification() {
var main = [Link]("ctl00_main"); [Link] =
1;
} </script>

<style type="text/css">
#progressBackgroundFilter
{
position: fixed;
top: 0px;
bottom: 0px;
left: 0px;
right: 0px;
overflow: hidden;
padding: 0;
margin: 0;
background-color: #000;
filter: alpha(opacity=50);
opacity: 0.5;
z-index: 1000;
height: 100%;
}
#processMessage
{
position: fixed;
top: 200px;
left: 43%;
padding: 10px;
width: 14%;
z-index: 1001;
background-color: #fff;
text-align: center;
}
.ddlClass
{
font-size: 18px;
height: 30px;
line-height: 30px;
width: 100px; /*
scrollbar-face-color: #FFCCCC;
scrollbar-highlight-color: #4B4B4B;
scrollbar-3dlight-color: #646464;
scrollbar-darkshadow-color: #969696;
scrollbar-shadow-color: #C0C0C0;
scrollbar-arrow-color: #090925;
scrollbar-track-color: #051011;*/
}
.pgr
{
background: #424242 url(grd_pgr.png) repeat-x top;
}
.pgr table
{
margin: 5px 0;
}
 .pgr td
{
border-width: 0;
padding: 0 6px;
border-left: solid 1px #666;
font-weight: bold;
color: #fff;
line-height: 12px;
}
.pgr a
{
color: #666;
text-decoration: none;
}
.pgr a:hover
{
color: #000;
text-decoration: none;
}
/*by adil Start*/.Initial
{
display: block;
padding: 2px 10px 4px 12px;
float: left;
background: url("../images/[Link]") no-repeat right top;
color: Black;
font-weight: bold;
}
.Initial:hover
{
color: White;
background: url("../images/[Link]") no-repeat right top;
}
.Clicked
{
float: left;
display: block;
background: url("../images/[Link]") no-repeat right top;
padding: 2px 10px 4px 12px;
color: Black;
font-weight: bold;
color: White;
}
/*by adil End*/</style>
</head>
<body>
<form name="aspnetForm" method="post" action="[Link]?
ocid=41462&amp;fileID=328088&amp;fileType=q" id="aspnetForm">
<div>
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"
value="/wEPDwUKMTY1NDU2MTA1Mg9kFgJmD2QWAmYPZBYEAgEPZBYCAgMPZBYCAgEPPCsADQBkAgsPZBYa
AgcPDxYCHgRUZXh0BQdTYWRhcWF0ZGQCEQ8PZBYCHgVTdHlsZQUNZGlzcGxheTpub25lO2QCJQ8WAh4Fc3R
5bGUFDWRpc3BsYXk6bm9uZTtkAicPFgIfAgUNZGlzcGxheTpub25lO2QCKQ8WAh8CBQ1kaXNwbGF5Om5vbm
U7ZAIrDxYCHwIFDWRpc3BsYXk6bm9uZTtkAnMPFgIeB1Zpc2libGVoZAJ3DxYCHwIFDERpc3BsYXk6bm9uZ
RYIZg8WAh8CBQxEaXNwbGF5Om5vbmVkAgIPD2QWAh8CBQxEaXNwbGF5Om5vbmVkAgQPD2QWAh8CBQxEaXNw
bGF5Om5vbmVkAgYPD2QWAh8CBQxEaXNwbGF5Om5vbmVkAnkPZBYEAgIPD2QWAh8CBQ1kaXNwbGF5Om5vbmU
7ZAIEDw9kFgIfAgUNZGlzcGxheTpub25lO2QCew9kFgRmDxYCHwIFDWRpc3BsYXk6bm9uZTtkAgIPD2QWAh
8CBQ1kaXNwbGF5Om5vbmU7ZAJ/Dw8WAh4LUG9zdEJhY2tVcmwFASMWAh8CBQxEaXNwbGF5Om5vbmVkAosBD
2QWFgIBDxYCHgNzcmMFD05vSW1hZ2VNYWxlLmpwZ2QCAw8PFgIfAAUHU2FkYXFhdGRkAgUPDxYCHwAFFUNJ
SVQvRkExNy1CU0UtMTU1L0FURGRkAgcPDxYCHwAFDkhhamkgQWhtZWQgSmFuZGQCCQ8PFgIfAAUBNmRkAg0
PDxYCHwAFAjQ0ZGQCEQ8PFgIfAAUDQlNFZGQCEw8PFgIfAAUCQyBkZAIVDw8WAh8ABRBTYXJkYXIgQWxhbS
AoUkEpZGQCFw8PFgIfAAUMU2VwIDA4LCAxOTk2ZGQCGQ8PFgIfAAUNQ04xMDEzNTg2MDAxMWRkApEBDw8WA
h8ABQlBYm90dGFiYWRkZBgBBRhjdGwwMCRndk1pc3NpbmdEb2N1bWVudHMPZ2SjTHvhZc+cnPdEOum+p4mg
dRTX5g==" />
</div>

<script type="text/javascript">
//<![CDATA[
var theForm = [Link]['aspnetForm'];
if (!theForm) {
theForm = [Link];
}
function __doPostBack(eventTarget, eventArgument) {
if (![Link] || ([Link]() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
[Link]();
}
}
//]]>
</script>

<script src="/[Link]?d=kd6hY6V9gpJ-2Up1AbQrg5JuX66f86JcmnTsdlpqBYbq5RCrjH-
2uRETyVsU72i0EHlADn3x-uaOmamiGRUzIK30cHU1&amp;t=637291115760000000"
type="text/javascript"></script>

<script src="/[Link]?d=03G0pNWJPHL6DWVd7M9NwABs5OGaeIEZiKjhqb-
47gKw1AGVLQc_P19EyZjuKh82jsQVGH3tjJijj3tVn_WtRXLH9Pq-
AdqiEXLPk6XdaF86imzP_YvefAdzkprlw7LZeqHarTon1QSTUM_qzATN6yPB8ic1&amp;t=3554ad18"
type="text/javascript"></script>
<script src="/[Link]?
d=f_NN64aGGRrwElJIoEbmd6_CnCpk7txZdrkmcvPWxMN7bNncMuDDGhRZrGVeprh_rjyo3TCAQfaUByBtB
KxUwcTVcS0n8hNecTdqjNZfQRtT418ArjFq3JWDKiUH3jwK4_ZWoR1LpmS8HmND-
ACPqXFUsVGuToWosJUDN8ImgNy-v7_R0&amp;t=3554ad18" type="text/javascript"></script>
<div>

<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR"

value="6A2B5FB0" />
<input type="hidden" name="__PREVIOUSPAGE" id="__PREVIOUSPAGE"
value="IEDtlRxXg1h9EULoII4jZrX9Pl23PLJXbEW7tKGQH6SOCcq94LMcSQJQEd6o4BJJ01bPg6P5BV4W
-tWdtU8e7HJHN7c1" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION"
value="/wEWGwLU19SVCQKuzNzyAQKIq62dBwLtnd/oBgLrjPKUAQL52+m3CwKnq9a6BgK42/GbDAK6iJ29
AwLNsu1dAti9uPABAu29kPYBAobNoZkMAtWko5cDApnA/poLAu3Rpe8LAvXMk6UOAqmzif8JAoOP3IgOAo7
4nLsKArfA4M0BAtWDzs8IAvb3icYOAu/X56IDArKPsbsOAuC8+dIIAt70nrALbJsTFH6FKHPr+N2o5d036K
gvE0U=" />
</div>

<div id="ctl00_main">
<script type="text/javascript">
//<![CDATA[
[Link]._initialize('ctl00$Manager',
[Link]('aspnetForm'));
[Link]()._updateControls([], [], [], 90);
//]]>
</script>

<div id="body-wrapper">
<!-- Wrapper for the radial gradient background -->
<div id="sidebar">
<div id="sidebar-wrapper">
<!-- Sidebar with logo and menu -->
<h1 id="sidebar-title">
<a href="#">Student COnsole</a></h1>
<!-- Logo (221px wide) -->
<center>
<a href="#">
<img id="ctl00_logo"
src="resources/images/CIITLogo_Plain.png" alt="COMSATS" style="border-
width:0px;" />
</a>
</center>
<!-- Sidebar Profile links -->
<div id="profile-links" style="text-align: center;">
<span id="ctl00_Label1" style="font-
size:10pt;">Welcome,</span>
<a href="#" title="Edit your profile">
<span id="ctl00_lbl_StudentName" style="font-
size:10pt;">Sadaqat</span></a><br />
<br />
<a id="ctl00_lnk_Notifications" title="Notifications"
href="javascript:__doPostBack('ctl00$lnk_Notifications','')" style="font-size:
10pt">Notifications</a>
|
<a id="ctl00_lnk_Signout"
href="javascript:__doPostBack('ctl00$lnk_Signout','')" style="font-size: 10pt">Sign

Out</a>
<br />

<a href="[Link]" style="font-size: 9pt;

color: Yellow">User Manual</a>
|
|
|
</div>
<ul id="main-nav">
<!-- Accordion Menu -->
<li>
<a id="ctl00_lnk_Dashboard" class="nav-top-item no-
submenu" href="javascript:__doPostBack('ctl00$lnk_Dashboard','')">Dashboard</a>
</li>
<li id="ctl00_lst_MSteam"><a id="ctl00_lnkMSteamMain"
class="nav-top-item">
<!-- Add the class "current" to current menu item -->
Microsoft Office 365 / Teams </a>
<ul>
<li>
 <a id="ctl00_lnkMSTeam"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkMSTeam&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;StudentsDetails/[Link]&quot;, false, true))">
Account Details</a>
</li>
</ul>
</li>
<li id="ctl00_lstRegistration">

<ul>
<li>

</li>
<li>
</li>
</ul>
</li>
<li id="ctl00_lstCourses"><a id="ctl00_lnk_Courses"
class="nav-top-item">
<!-- Add the class "current" to current menu item -->
Courses </a>
<ul>
<li>
<a id="ctl00_lnk_Summary"
href="javascript:__doPostBack('ctl00$lnk_Summary','')">Summary</a></li>
<li>
<a id="ctl00_lnk_ClassProceedings"
href="javascript:__doPostBack('ctl00$lnk_ClassProceedings','')">Class
Proceedings</a></li>
<li>
<a id="ctl00_lnk_QAMarks"
href="javascript:__doPostBack('ctl00$lnk_QAMarks','')">Q.A/Sess/Final
Marks</a></li>
<!-- Add class "current" to sub menu items also -->
</ul>
</li>
<li id="ctl00_lstCoursePortal"><a
id="ctl00_lnk_CoursePortal" class="nav-top-item">
Course Portal </a>
<ul>
<li><a href="CTS/[Link]"
id="ctl00_lnkOnlineTest">MCQ Test</a></li>
<li><a href="[Link]?isTest=1"
id="ctl00_lnkSubjectiveTests">Subjective Test</a></li>
<li><a href="[Link]"
id="ctl00_lnkCourseContents">
Course Contents</a></li>
<li><a href="[Link]"
id="ctl00_lnkPortalSummary">Assignments Summary</a></li>
<li><a href="[Link]"
id="ctl00_lnkPendingAssignments">
Pending Assignments</a></li>
</ul>
</li>

<li><a href="#" id="ctl00_lnkStudentApp" class="nav-top-

item">Student Mobile App Activation</a>
 <ul>
<li><a href="[Link]"
id="ctl00_lnkStudentAppActivation">Student App Activation</a></li>
</ul>
</li>

<li><a href="#" id="ctl00_lnkHybridDateSheet" class="nav-

top-item">Hybrid Date
Sheet</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkHybDatesheet">Hybrid Course
Date Sheet</a></li>
</ul>
</li>
<li><a href="#" id="ctl00_lnkPositionHolders" class="nav-
top-item" style="display:none;">Position
Holders Registration</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkPositionHoldersReg" style="display:none;">
Position Holders Registration</a></li>
</ul>
</li>
<li><a href="#" id="ctl00_lnkFunkadaRegistration"
class="nav-top-item" style="display:none;">Funkada
Registration</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkFunkadaRegister" style="display:none;">Funkada Registration</a></li>
</ul>
</li>
<li><a href="#" id="ctl00_lnkBoarding" class="nav-top-
item">Boarding</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkRequestBoarding">Request Boarding</a></li>
</ul>
</li>
<li><a href="#" id="ctl00_lnk_Sibling" class="nav-top-
item">Sibling Info</a>
<ul>
<li>
<a id="ctl00_lnk_SiblingInfo"
href="javascript:__doPostBack('ctl00$lnk_SiblingInfo','')">Add Sibling Info</a>
</li>

</ul>
</li>
<li><a href="#" id="ctl00_lnk_Result" class="nav-top-
item">Result</a>
<ul>
<li>
<a id="ctl00_lnk_ResultCard"
href="javascript:__doPostBack('ctl00$lnk_ResultCard','')">Result
Card</a>
</li>
</ul>
</li>
 <li><a href="#" id="ctl00_lnkOBE" class="nav-top-
item">OBE</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkPLOSummary">Program PLO Details</a></li>
<li><a href="[Link]"
id="ctl00_lnkCurrentCLO">Current Semester
CLO</a></li>
<li><a href="[Link]"
id="ctl00_lnkSemesterwiseCLO">Semester wise
CLO </a></li>
<li><a href="[Link]"
id="ctl00_lnkOverAllPLO">PLO Achievement</a></li>
</ul>
</li>
<li id="ctl00_lstProject"><a href="#"
id="ctl00_lnkProjectMain" class="nav-top-item">Projects </a>
<ul>
<li><a href="FinalProject/[Link]"
id="ctl00_lnkApprovedProjects">
Approved Projects</a></li>
<li><a href="FinalProject/[Link]"
id="ctl00_lnkTemplates">
Document Templates</a></li>
<li><a href="FinalProject/[Link]"
id="ctl00_lnkProjectTasks">
Project Tasks</a></li>
</ul>
</li>
<li id="ctl00_lstTimetable"><a href="#"
id="ctl00_lnkTimeTableMain" class="nav-top-item">Time Table </a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkTimeTable">TimeTable</a></li>
</ul>
</li>
<li visible="false"><a href="#" id="ctl00_lnk_FeeChallan"
class="nav-top-item">
Fee </a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkFee">Challan</a></li>
<li><a href="[Link]"
id="ctl00_lnkFeeHistory">History</a></li>
<li><a href="[Link]"
id="ctl00_lnkFeeInstallment">Fee Installment</a></li>
</ul>
</li>

<li><a id="ctl00_lnkLibraryMain" class="nav-top-

item">Library</a>
<ul>
<li><a href="[Link]"
id="ctl00_lnkReserveBook">Book Reservation</a></li>
<li><a href="[Link]"
id="ctl00_lnkBookBorrowHistory">Book Borrow
History</a></li>
</ul>
</li>
 <li style="display: none"><a id="ctl00_lnkGRASSPMain"
class="nav-top-item">
GRASSP</a>
<ul>
<li><a href="GraSPP/[Link]"
id="ctl00_stuinfo">Student Info</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_stuinfo1">BasicInfo
</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A2">ComposeCommittee</a></li>
<li><a href="GraSPP/GraSPP_Print.aspx"
id="ctl00_A3">GraSPP_Print </a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A4">Student Info</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A5">BasicInfo
</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A6">GraSPPCompletion</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A7">GraSPPComprehensieExam
</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A8">GraSPPRemarks</a></li>
<li><a
href="GraSPP/[Link]" id="ctl00_A9">
ResearchActivityProblem </a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A10">GraSPPShowResultCard</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A11">GraSPPSubmitForm
</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A12">GraSPPSynopsisSeminars</a></li>
<li><a href="GraSPP/[Link]"
id="ctl00_A13">GraSPPThesisMeeting
</a></li>
</ul>
</li>
<li>
<ul>
<li>
<a id="ctl00_lnk_FeedbackSummary"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnk_FeedbackSummary&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;[Link]&quot;, false,
true))">Summary</a></li>
</ul>
</li>
<li id="ctl00_lstConvocation" style="Display:none"><a
href="#" id="ctl00_lnkConvocationRegistration" class="nav-top-item"
style="Display:none">Convocation Registration </a>
<ul>
<li>
<a id="ctl00_lnkRegister"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkRegister&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;[Link]&quot;, false, true))"
style="Display:none">Register</a></li>
<li>
<a id="ctl00_lnkConvPrint"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkConvPrint&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;[Link]&quot;, false, true))"
style="Display:none">Print Convocation Letter</a></li>
<li>
<a id="ctl00_lnkConvPicture"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkConvPicture&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;[Link]&quot;, false, true))"
style="Display:none">Convocation Picture</a></li>
</ul>
</li>
<li id="ctl00_lstScholarShip"><a href="#"
id="ctl00_lnkScholarships" class="nav-top-item">Scholarship</a>
<ul>
<li>
<a id="ctl00_LinkRegform"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$LinkRegform&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;scholarship/[Link]&quot;, false, true))"
style="display:none;">Apply</a></li>
<li>
<a id="ctl00_LinkScholarshipform"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$LinkScholarshipform&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;scholarship/[Link]&quot;, false,
true))" style="display:none;">View Form</a></li>
<li>
<a id="ctl00_LinkViewScholarshipStatus"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$LinkViewScholarshipStatus&quot;, &quot;&quot;,
false, &quot;&quot;, &quot;scholarship/[Link]&quot;, false,
true))">View Scholarship Status</a></li>
</ul>
</li>

<script type="text/javascript">
function openWin() {

[Link]("SurveyFeedback/[Link]")
}
</script>

<li id="ctl00_lstSurveyFeedback"><a href="#"

id="ctl00_lnkSurveyFeedback" class="nav-top-item" style="display:none;">Survey
Feedback</a>
<ul>
<li>
<a onclick="openWin();"
id="ctl00_LinkSurveyFeedback"
href="javascript:__doPostBack('ctl00$LinkSurveyFeedback','')"
style="display:none;">Start Survey Feedback</a>

</li>
</ul>
</li>
 <li id="ctl00_lstClearanceMain"><a href="#"
id="ctl00_lnkClearanceMain" class="nav-top-item">University Clearance</a>
<ul>
<li>
<a id="ctl00_lnkApplyForClearance"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkApplyForClearance&quot;, &quot;&quot;,
false, &quot;&quot;, &quot;Clearance/[Link]&quot;, false,
true))">Apply</a></li>
<li>
<a id="ctl00_lnkClearanceStatus"
href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkClearanceStatus&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;Clearance/[Link]&quot;, false, true))">View
Status</a></li>
</ul>
</li>
<li>
<a id="ctl00_lnkGraduateProfile" class="nav-top-item
no-submenu" href="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$lnkGraduateProfile&quot;, &quot;&quot;, false,
&quot;&quot;, &quot;#&quot;, false, true))" style="Display:none">Graduate Progress
Profile</a>
</li>
<li id="ctl00_lstAPS"><a href="#" id="ctl00_lnkapsmain"
class="nav-top-item">
Application Processing System</a>
<ul>
<li>
<a id="ctl00_lnkapsprocess"
href="javascript:__doPostBack('ctl00$lnkapsprocess','')">Apply</a>
</li>
<li>
<a id="ctl00_lnkapsstatus"
href="javascript:__doPostBack('ctl00$lnkapsstatus','')">Application Status</a></li>
<li>
<a id="ctl00_lnkcheckcoursestatus"
href="javascript:__doPostBack('ctl00$lnkcheckcoursestatus','')">Course Application
Status</a></li>
</ul>
</li>
<li><a href="#" id="ctl00_lnk_Settings" class="nav-top-
item">Settings</a>
<ul>
<li>
<a id="ctl00_lnk_Profile"
href="javascript:__doPostBack('ctl00$lnk_Profile','')">Profile</a>
</li>
<li>
<a id="ctl00_lnk_ChangePassword"
href="javascript:__doPostBack('ctl00$lnk_ChangePassword','')">Change
Password</a></li>
<li>
<a id="ctl00_lnk_LoginHistory"
href="javascript:__doPostBack('ctl00$lnk_LoginHistory','')">Login
History</a></li>
</ul>
</li>
</ul>
 <!-- End #main-nav -->
<div id="messages" style="display: none">
<!-- Messages are shown when a link with these attributes
are clicked: href="#messages" rel="modal" -->
<h3>
3 Messages</h3>
<p>
<strong>17th May 2009</strong> by Admin<br />
Lorem ipsum dolor sit amet, consectetur adipiscing
elit. Vivamus magna. Cras in
mi at felis aliquet congue. <small><a href="#"
class="remove-link" title="Remove message">
Remove</a></small>
</p>
<p>
<strong>2nd May 2009</strong> by Jane Doe<br />
Ut a est eget ligula molestie gravida. Curabitur massa.
Donec eleifend, libero at
sagittis mollis, tellus est malesuada tellus, at luctus
turpis elit sit amet quam.
Vivamus pretium ornare est. <small><a href="#"
class="remove-link" title="Remove message">
Remove</a></small>
</p>
<p>
<strong>25th April 2009</strong> by Admin<br />
Lorem ipsum dolor sit amet, consectetur adipiscing
elit. Vivamus magna. Cras in
mi at felis aliquet congue. <small><a href="#"
class="remove-link" title="Remove message">
Remove</a></small>
</p>
</div>
<!-- End #messages -->
</div>
</div>
<!-- End #sidebar -->
<div id="main-content">
<!-- Main Content Section with everything -->
<noscript>
<!-- Show a notification if the user has disabled javascript
-->
<div class="notification error png_bg">
<div>
Javascript is disabled or is not supported by your
browser. Please <a href="" title="Upgrade to a better browser">
upgrade</a> your browser or <a href=""
title="Enable Javascript in your browser">enable</a>
Javascript to navigate the interface properly.
</div>
</div>
</noscript>
<!-- Page Head -->
<div id="ctl00_divStudentDetails">
<ul class="shortcut-buttons-set">
<li><a class="shortcut-button" href="#">

<img src="[Link]" id="ctl00_stImg" alt="icon"

style="width: 100px; height: 100px" />
</a></li>
<li style="width: 82%;">
<div class="studentdetails">
<table cellpadding="0" cellspacing="0"
class="Grid">
<tr>
<td style="width: 25%;" class="GridColumn">
<b>Name :</b>
</td>
<td style="width: 30%;" class="GridColumn">
<span
id="ctl00_lbl_Name">Sadaqat</span>
</td>
<td style="width: 20%;" class="GridColumn">
<b>Roll No :</b>
</td>
<td style="width: 25%;">
<span id="ctl00_lbl_RollNo">CIIT/FA17-
BSE-155/ATD</span>
</td>
</tr>

<tr>
<td class="GridColumn">
<b>Father Name :</b>
</td>
<td class="GridColumn">
&nbsp;<span
id="ctl00_lbl_FatherName">Haji Ahmed Jan</span>
</td>
<td>
<b>Registered Courses :</b>
</td>
<td class="GridColumn">
<span
id="ctl00_lbl_RegisteredCourses">6</span>

</td>
</tr>
<tr>
<td class="GridColumn">
<b>Total Registered Courses :</b>
<br />
</td>
<td class="GridColumn">
<span
id="ctl00_lbl_TotalRegisteredCourses">44</span>
<span
id="ctl00_lbl_CurrentSelectedCourse"></span>
</td>
<td class="GridColumn">
<b>Program :</b>
<br />
</td>
<td class="GridColumn">
<span
id="ctl00_lbl_ProgramName">BSE</span>
</td>
 </tr>
<tr>
<td class="GridColumn">
<b>Current Section :</b>
<br />
</td>
<td class="GridColumn">
<span id="ctl00_lbl_CurrentSection">C
</span>
</td>
<td class="GridColumn">
<b>Current Advisor :</b>
</td>
<td class="GridColumn">
<span id="ctl00_lblStuAdv">Sardar Alam
(RA)</span>
</td>

</tr>
<tr>
<td class="GridColumn">
<b>Date of Birth :</b>
</td>
<td class="GridColumn">

<span id="ctl00_lblDoB">Sep 08,

1996</span>
</td>

<td class="GridColumn">
<b>CNIC :</b>
</td>
<td class="GridColumn">
<span
id="ctl00_lblNID">CN10135860011</span>
</td>
</tr>
</table>
</div>
</li>
</ul>
</div>
<div class="clear">
</div>
<div class="content-box" align="center">
<!-- Start Content Box -->
<div class="content-box-header">

<div class="clear">
</div>
</div>

<!-- End .content-box-header -->

<!-- End .content-box-content -->

</div>
<!-- End .content-box -->
 <div class="clear">
</div>
<!-- Start Notifications -->

<!-- End Notifications -->

<div id="footer">
<small>Copyright © 2009 COMSATS CIIT <span lang="en-us">
<span id="ctl00_LblCampusName" style="font-
size:Small;">Abottabad</span></span>
|

<a href="#">Top</a></small>
</div>
<!-- End #footer -->
</div>
<!-- End #main-content -->
</div>

</div>

<script type="text/javascript">
//<![CDATA[
[Link]();
//]]>
</script>
</form>
</body>
</html>