Synopsis for MIS for IT Institution ‘MIS for IT Institution’ a web based Information System for Systems Domain Pvt. Ltd. that facilitates easy access of information for the user’s and helps them to seek expert guidance from the faculties through the Internet. The system is fine tuned to cater the varying demands of the user’s community seeking a career with Systems Domain courses and projects. The system is designed incorporating a wide array of choices to ensure maximum support and guidance for the user’s logging into the site. The highlights of the system include an en uiry system! to handle the ueries of the students! a registration and booking system that provides online booking and registration facilities for the user’s right from any part of the globe. The user can use this system to experience a user"friendly sojourn that understands his every impulse. The users are given a wide selection of choices and he can choose any of the options according to his needs. #lexibility $ the ultimate motto of the system $ is from the point of view of the Database %dministrator by using the &'asy
%dministrator’ module developed along with. The administrator can use the facilities provided in this module to handle the various operations related to updating the Database with ease. (anagement System manages the repository of )ourses! students! 'n uiries! #%*’s and other permanent information. The +roject ,ork has been carried out at Pacific IT Solutions, -angalore.
ORGANISATIONAL PROFILE Systems Domain Pvt. Ltd Systems Domain Pvt. Ltd. was started on 1998 as a Training Institution at Bangalore, India. It was set up with a single goal and dire tion, namely, ma!ing "uality #or! $or %ur &ustomers.
#e are availa'le on phone, $a(, email or you an write to us i$ you pre$er. #e would 'e delighted to give you more in$ormation or simply hear your thoughts on how we ould help you rea h your goal.
Objectives of Systems Domain Pvt. Ltd.:
? ? ? ?
To 'uild highly s!illed so$tware pro$essionals. To provide edu ation and servi es to mar!et needs. To run high )uality 'usiness servi e. To 'e a leader in te hnology and produ tivity relations to omputers.
Objective of t e P!oject The Pro*e t is the development o$ the #e' +odule titled ,+IS $or IT Institution- whi h supports e. ommer e through online registration, online payment. ,+IS $or IT Institution- $a ilitates easy a the world. The pro*e t allows the users or the students to e(er ise their uriosity on the various topi s 'eing dwelt with at any point o$ time. The wor!$a e will 'e at users disposal at all times. There$ore the site losely resem'les a virtual lassroom where the student has a ess to pro'a'ly everything. essi'ility o$ in$ormation and te hni al !now.how round the lo ! and around
The system mainly involves two parties / • St"dent • Administ!ation The user re$ers to the Internet users who have interest in pursuing various modules at this enter. The students are the users who have registered $or a parti ular ourse.
0dministration is an entity, whi h !eeps tra !s o$ the pro eedings o$ the enter. This so$tware onsists o$ these $un tionalities1 Dis#$ayin% &o"!se Detai$s: ' This module wor!s in lude the pro ess o$ displaying the various details to the e( ited users. The &ourse Details are maintained in a data'ase. This module des ri'es all the details o$ the Dis#$ayin% P!oject Detai$s: ' This module wor!s in lude the pro ess o$ displaying the various details to the e( ited users. The Pro*e t Details are maintained in a data'ase. This module des ri'es all the details o$ the pro*e ts in luding pro*e t odes, $ees, and prere)uisite in$ormation. Re%ist!ation: ' This module eyes on the pro ess o$ 2egistration. The main riterion o$ 2egistration is the de ision made 'y the user in sele ting the ourse. The ourse or pro*e t module relieves the users o$ even a little 'it o$ on$usion regarding ourse or pro*e t sele tion. 0 user 'e omes a student a$ter 2egistration. 3or registration $or a parti ular ourse or pro*e t there are ertain onstraints the student should have 'oo!ed $or a parti ular ourse i$ seats are not urrently availa'le. 0ll the onstraints are ta!en into a ount only there is seats remaining in the 'at h opted and the ommen e. #hen any o$ the a'ove onstraints ourse is yet to ourses in luding ourse odes, sylla'us, and prere)uisite in$ormation.
have 'een met the registration pro ess is allowed to ontinue. The
users will 'e re)uested to $ill the registration panel, whi h onsists o$ all details related to the user. The user is made to input data regarding the mode o$ payment and payment details immediately in the registration pro ess itsel$. 4e is given the option o$ paying 'y Demand Dra$t or &he)ue or &ash. 0ll the Ban! details are ta!en $rom the user. +oreover 'e$ore 'oo!ing or registration $or a ourse or pro*e t, the data'ase is he !ed with the )uali$i ation details entered 'y the user in the appropriate $orm. %n e the user is registered he is awarded a 2egistration num'er, whi h is om'ination o$ 'at h opted on a parti ular ourse and the total num'er o$ students in the 'at h. 0$ter registration the user is a student. (oo)in%: ' This module !eeps tra ! o$ the users who are not yet made their mind to register 'ut are very !een in pursuing the ourse or pro*e t. The 'oo!ing module levies some ondition, whi h must duly $ul$illed 'y the user 'e$ore 'oo!ing $or a parti ular ourse or pro*e t. The 'oo!ing module ta!es are o$ reserving a seat $or the 'oo!ed user provided the 'at h opted 'y the user has 'alan e seats. There$ore 'oo!ing an 'e termed as an intermediary 'etween user and student. 0s the user 'oo!s a seat, in a 'at h, he is provided with a 'oo!ing num'er, whi h an 'e made use in $uture during the registration.
En*"i!ies: ' This module omes in pi ture when the user wants to send )ueries or re)uests or suggestions to the entre. This module passes the message sent 'y the user dire tly to the Systems Domain Pvt. LTD. #e' server. The administration has the privilege to view the various )ueries and ma!e a de ision to in lude them in the 30" module.
FA+,s: ' This module has to ta!e are o$ the 30"s 'eing pu'lished on the net. The administrator goes through the various )ueries, whi h omes in the ,En*"i!ies- stage. The administrator duly appends these )ueries into 30" module using ,5asy 0dministrator- program. E-istin% system System St"dy The e(isting system is purely a manual one. The student is $or ed to ome to visit the institute. This mar!s the starting o$ a very tedious pro ess. The various ourses have 'een pro*e ted on a 'oard in the $ront o$$i e. The user glan es through the ourses or pro*e ts and the $ront o$$i er sta$$ handles en)uiries. The testing and interview
are handled manually. The registration pro ess $ollows through with lot o$ paper wor! involved in the pro ess. I$ a student wants to laim some dou'ts a'out the su'*e t he has to ome to the institute and approa h the on erned $a ulty. I$ in a situation the student or $a ulty is out o$ station the student annot even approa h the $a ulty. This leads dissatis$a tion to student. Pupil $rom di$$erent part o$ the world annot !now a'out the institute 'e ause there is no wide advertisement a'out the Institute. I$ the user wants to possess some )uery a'out the institute he is $or ed to ome to the institute and approa h the 3ront o$$i e sta$$s. This involves a tedious pro ess to the user. Be$ore a $ee payment has to 'e done manually lot o$ pro ess are re)uired to 'e ompleted. This leaves the user in $rustration. D!a. (ac)s • 0 time onsuming pro ess • The range o$ registration is limited due to distan e 'etween outlets. • Tedious leri al wor! or more usage o$ manpower undergone while entering details. • The entre $inds a di$$i ult to improve the networ! o$ its 'ran hes.
• The entre has 'een spending a huge amount in terms o$ pu'lishing and advertising. • The entre pays di$$i ulty to provide servi e to pupil $rom any part o$ the glo'e.
P!o#osed System P!ob$em Definition To design and develop a we' module titled ,+IS $or IT Institutionwhi h supports e. ommer e through online 'oo!ing, online registration and online test. To also $a ilitate easy a essi'ility o$ in$ormation right $rom any part o$ the glo'e . S/STE0 SPE&IFI&ATION ? 1a!d.a!e S#ecifications: Desc!i#tion 0inim"m P& #ith 1647 89:+B 89: ;B 8< 6B ;ey Board Printer, S anner Recommended P& #ith 1647 918 +B 918 ;B 18< 6B &ompati'le !ey'oard, mouse Printer >3or
System ty#e 20+ &a he Storage =ser Inter$a e %utput media
2eports? ? Soft.a!e S#ecifications:
OS
Soft.a!e
A##$ication Se!ve! +s IIS
Database Se!ve! +S S"L Server 8&LS? omplian e. The primary role o$ GS ript is development o$ #e' sites with 0SP.B5T and ustomi7ation o$ appli ations with S ript $or the .B5T 3ramewor!.
#e' 3orms
#e' 3orms are an 0SP.B5T te hnology that are use to reate programma'le #e' pages. #e' 3orms render themselves as 'rowser. ompati'le 4T+L and s ript, whi h allows any 'rowser on any plat$orm to view the pages. =sing #e' 3orms, we an reate #e' pages 'y dragging and dropping ontrols onto the designer and then adding ode, similar to the way that we reate @isual Basi $orms.
#indows 3orms
#indows 3orms is the new plat$orm $or +i roso$t #indows appli ation development, 'ased on the .B5T 3ramewor!. This $ramewor! provides a lear, o'*e t.oriented, e(tensi'le set o$ lasses that ena'les to develop ri h #indows appli ations.
C+L #e' Servi es
C+L #e' servi es are appli ations that an re eive re)uests and data using C+L over 4TTP. C+L #e' servi es are not tied to a parti ular omponent te hnology or o'*e t. alling onvention and an there$ore 'e a essed 'y any language, omponent model, or
operating system. In @isual Studio .B5T, we an )ui !ly reate and in lude C+L #e' servi es using @isual Basi , @isual &E, GS ript, +anaged 5(tensions $or &DD, or 0TL Server.
C+L Support
5(tensi'le +ar!up Language >C+L? provides a method $or des ri'ing stru tured data. C+L is a su'set o$ S6+L that is
optimi7ed $or delivery over the #e'. The #orld #ide #e' &onsortium >#A&? de$ines C+L standards so that stru tured data will 'e uni$orm and independent o$ appli ations. @isual Studio .B5T $ully supports C+L, providing the C+L Designer to ma!e it easier to edit C+L and reate C+L s hemas.
The .B5T 3ramewor!
The .B5T 3ramewor! is a multi.language environment $or 'uilding, deploying, and running C+L #e' servi es and appli ations. It onsists o$ three main parts1
4(
&55
&6
8Sc!i#t
9
&ommon Lan%"a%e S#ecification ASP.NET7 3eb Se!vices And 3eb Fo!ms ADO.NET: Data and :0L .NET F!ame.o!) (ase &$asses &ommon Lan%"a%e R"ntime 3indo.s Fo!ms
4is"a$
St"dio
.NET
&ommon Language 2untime
Despite its name, the runtime a tually has a role in 'oth a omponentHs runtime and development time e(perien es. #hile the omponent is running, the runtime is responsi'le $or managing memory allo ation, starting up and stopping threads and pro esses, and en$or ing se urity poli y, as well as satis$ying any dependen ies that the omponent might have on other omponents.
So"!ce So"!ce &ode &ode
&om#i$e &om#i$e !
&sc.e-e o! vbc.e-e
Assemb$y Assemb$y
)..! )/! for any.0'T language
D11 or '2'
&ommon Language 2untime &ompilation
=ni$ied programming lasses
The $ramewor! provides developers with a uni$ied, o'*e t. oriented, hierar hi al, and e(tensi'le set o$ lass li'raries >0PIs?.
&urrently, &DD developers use the +i roso$t 3oundation &lasses and Gava developers use the #indows 3oundation &lasses. The $ramewor! uni$ies these disparate models and gives @isual Basi and GS ript programmers a ess to lass li'raries as well.
0SP.B5T
0SP.B5T 'uilds on the programming lasses o$ the .B5T 3ramewor!, providing a #e' appli ation model with a set o$ ontrols and in$rastru ture that ma!e it simple to 'uild 0SP #e' appli ations. 0SP.B5T in ludes a set o$ ontrols that en apsulate ommon 4T+L user inter$a e elements, su h as te(t 'o(es and drop.down menus. These ontrols run on the #e' server, however, and push their user inter$a e as 4T+L to the 'rowser.
0D%.B5T
To move data 'etween a data store and the appli ation, we must $irst have a onne tion to the data store. In 0D%.B5T it is a'le
reate and manage a onne tion using one o$ two onne tion o'*e ts1 S)l&onne tion . an o'*e t that manages a onne tion to a S"L Server version I.< or later. %leD'&onne tion . an o'*e t that manages a onne tion to any data store a essi'le via %L5 DB.
The S)l&onne tion o'*e t is optimi7ed $or use with S"L Server I.< or later 'y >among other things? 'ypassing the %L5 DB layer. The %leD'&onne tion o'*e t intera ts with %L5 DB to e(pose a onsistent 0PI $or a variety o$ data sour es J everything $rom simple te(t $iles to spreadsheets and, o$ ourse, $ull.$eatured data'ases.
&onne tion Strings
Both types o$ onne tion o'*e ts e(pose roughly the same mem'ers. 4owever, the spe i$i mem'ers availa'le with a given %leD'&onne tion o'*e t depend on what data sour e it is onne ted toK not all data sour es support all mem'ers o$ the %leD'&onne tion lass. The primary property asso iated with a onne tion o'*e t is the &onne tion String property. 0 typi al &onne tion String property might loo! li!e the $ollowing1 Provider L S"L%L5DB.1K DataSour e L +yS"LServerK
Initial &atalog L B%2T4#IBDK Integrated Se urityLSSPI. The most ommon attri'uteMvalue pairs used 'y %L5 DB are also represented separately 'y an individual property, su h as DataSour e and Data'ase >and, optionally, =serId, and Password?. #hen wor!ing with a onne tion o'*e t, we an either set the &onne tionString property as a single string, or an set individual onne tion properties. >I$ the data sour e re)uires onne tion.string values that are not represented 'y individual properties, then we must set the &onne tionString property.? 0lternatively, we an also set the &onne tionString property to the path o$ a +i roso$t Data Lin! >.udl? $ile.
%pening and &losing &onne tions
The two primary methods $or onne tions are %pen and &lose. The %pen method uses the in$ormation in the &onne tionString property to onta t the data sour e and esta'lish an open onne tion. The &lose method shuts the onne tion down. &losing onne tions is essential, 'e ause most data sour es support only a limited num'er o$ open onne tions, and open onne tions ta!e up valua'le system resour es.
+ethods su h as 3ill only open and lose the onne tion automati ally i$ it is not already open. I$ the onne tion is open, the methods use it 'ut do not lose it. This gives the $le(i'ility to open and lose data ommands. In that ase, it is ine$$i ient to have ea h adapter open and lose the onne tion when we all its 3ill method. Instead o$ opening the onne tion, all the 3ill method o$ ea h adapter, and then lose the onne tion.
Pooling &onne tions
0ppli ations o$ten have di$$erent users per$orming the same type o$ data'ase a ess. 3or e(ample, in 0SP.B5T #e' appli ations
many users might 'e )uerying the same data'ase to get the same data. In those ases, the per$orman e o$ the appli ation an 'e enhan ed 'y having the appli ation share, or Npool,N onne tions to the data sour e. The overhead o$ having ea h user open and lose a separate onne tion an otherwise have an adverse e$$e t on appli ation per$orman e. #hile using the %leD'&onne tion lass, onne tion pooling is handled automati ally 'y the provider, so there is no need to manage it. #hile using the S)l&onne tion lass, onne tion pooling is
managed impli itly, 'ut also provides options that allow managing pooling. Transa tions &onne tion o'*e ts support transa tions with a BeginTransa tion method that reates a transa tion o'*e t >an %leD'Transa tion or S)lTransa tion o'*e t?. The transa tion o'*e t in turn supports methods that allow ommitting or rolling 'a ! the transa tions.
Tec no$o%ies "sed: .NET #hat Is .B5TO
.B5T is the +i roso$t #e' servi es strategy to onne t in$ormation, people, systems, and devi es through so$tware. Integrated a ross the +i roso$t plat$orm, .B5T te hnology provides the a'ility to )ui !ly 'uild, deploy, manage, and use onne ted,
se urity.enhan ed solutions with #e' servi es. .B5T. onne ted solutions ena'le 'usinesses to integrate their systems more rapidly and in a more agile manner and help them reali7e the promise o$ in$ormation anytime, anywhere, on any devi e. The +i roso$t plat$orm in ludes everything a 'usiness needs to develop and deploy a #e' servi e. onne ted IT ar hite ture1 servers to host #e' servi es, development tools to reate them, appli ations to use them, and a worldwide networ! o$ more than A9, 9> 9>
0ull > > >
0ame
Data type
Si5e 9> 6> 3> 6> 3> 6>
0ull 3 3 3 3 3 3
(achine@0ame nvarchar AserID 1ogin@Date 1ogin@Time 1ogout@Date 1ogout@Time
Table 6>4
nvarchar nvarchar nvarchar nvarchar nvarchar
0ame
=serID $name lname Phone *o'lo
Data type
nvar har nvar har nvar har nvar har nvar har
Si5e
9< 9< 9< 9< 9<
0ull
< < < 1 <
Table 634
0ame )ourse@)ode
Data type nvarchar
Si5e 9>
0ull 3
+rojects
Table 664
nvarchar
3>>
3
0ame
=serid te(p re(p s!ills 'e os t e t rhead $domain resume Table 674
Data type
nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nte(t
Si5e
9< 8 8 9< 9< 9< 1< 1< 9< 9< 1:
0ull
< < 1 < < < < < < 1 <
0ame
Sno 2ollTBo
Data type
numeri nvar har
Si5e
9 1<
0ull
< 1
StudentTBame &ourseT&ode Pro*e t TotalT3ee &entreT ode &ounsellor 5nrTDate 5nrTPear 5nrT+onth &ourseTStatus Table 684
nvar har nvar har nvar har int nvar har nvar har nvar har nvar har nvar har nvar har
A< 8< 1 9>
0ull > 3
0ame
testTtime Table 6:4
Data type
nvar har
Si5e
8<
0ull
1
0ame
Data type
Si5e
0ull
Su'*e tT&ode +ainTTopi Topi Duration re Tid Table 6;4
nvar har nvar har nvar har int numeri
8< 1
%dministrator’ module developed along with. The administrator can use the facilities provided in this module to handle the various operations related to updating the Database with ease. (anagement System manages the repository of )ourses! students! 'n uiries! #%*’s and other permanent information. The +roject ,ork has been carried out at Pacific IT Solutions, -angalore.
ORGANISATIONAL PROFILE Systems Domain Pvt. Ltd Systems Domain Pvt. Ltd. was started on 1998 as a Training Institution at Bangalore, India. It was set up with a single goal and dire tion, namely, ma!ing "uality #or! $or %ur &ustomers.
#e are availa'le on phone, $a(, email or you an write to us i$ you pre$er. #e would 'e delighted to give you more in$ormation or simply hear your thoughts on how we ould help you rea h your goal.
Objectives of Systems Domain Pvt. Ltd.:
? ? ? ?
To 'uild highly s!illed so$tware pro$essionals. To provide edu ation and servi es to mar!et needs. To run high )uality 'usiness servi e. To 'e a leader in te hnology and produ tivity relations to omputers.
Objective of t e P!oject The Pro*e t is the development o$ the #e' +odule titled ,+IS $or IT Institution- whi h supports e. ommer e through online registration, online payment. ,+IS $or IT Institution- $a ilitates easy a the world. The pro*e t allows the users or the students to e(er ise their uriosity on the various topi s 'eing dwelt with at any point o$ time. The wor!$a e will 'e at users disposal at all times. There$ore the site losely resem'les a virtual lassroom where the student has a ess to pro'a'ly everything. essi'ility o$ in$ormation and te hni al !now.how round the lo ! and around
The system mainly involves two parties / • St"dent • Administ!ation The user re$ers to the Internet users who have interest in pursuing various modules at this enter. The students are the users who have registered $or a parti ular ourse.
0dministration is an entity, whi h !eeps tra !s o$ the pro eedings o$ the enter. This so$tware onsists o$ these $un tionalities1 Dis#$ayin% &o"!se Detai$s: ' This module wor!s in lude the pro ess o$ displaying the various details to the e( ited users. The &ourse Details are maintained in a data'ase. This module des ri'es all the details o$ the Dis#$ayin% P!oject Detai$s: ' This module wor!s in lude the pro ess o$ displaying the various details to the e( ited users. The Pro*e t Details are maintained in a data'ase. This module des ri'es all the details o$ the pro*e ts in luding pro*e t odes, $ees, and prere)uisite in$ormation. Re%ist!ation: ' This module eyes on the pro ess o$ 2egistration. The main riterion o$ 2egistration is the de ision made 'y the user in sele ting the ourse. The ourse or pro*e t module relieves the users o$ even a little 'it o$ on$usion regarding ourse or pro*e t sele tion. 0 user 'e omes a student a$ter 2egistration. 3or registration $or a parti ular ourse or pro*e t there are ertain onstraints the student should have 'oo!ed $or a parti ular ourse i$ seats are not urrently availa'le. 0ll the onstraints are ta!en into a ount only there is seats remaining in the 'at h opted and the ommen e. #hen any o$ the a'ove onstraints ourse is yet to ourses in luding ourse odes, sylla'us, and prere)uisite in$ormation.
have 'een met the registration pro ess is allowed to ontinue. The
users will 'e re)uested to $ill the registration panel, whi h onsists o$ all details related to the user. The user is made to input data regarding the mode o$ payment and payment details immediately in the registration pro ess itsel$. 4e is given the option o$ paying 'y Demand Dra$t or &he)ue or &ash. 0ll the Ban! details are ta!en $rom the user. +oreover 'e$ore 'oo!ing or registration $or a ourse or pro*e t, the data'ase is he !ed with the )uali$i ation details entered 'y the user in the appropriate $orm. %n e the user is registered he is awarded a 2egistration num'er, whi h is om'ination o$ 'at h opted on a parti ular ourse and the total num'er o$ students in the 'at h. 0$ter registration the user is a student. (oo)in%: ' This module !eeps tra ! o$ the users who are not yet made their mind to register 'ut are very !een in pursuing the ourse or pro*e t. The 'oo!ing module levies some ondition, whi h must duly $ul$illed 'y the user 'e$ore 'oo!ing $or a parti ular ourse or pro*e t. The 'oo!ing module ta!es are o$ reserving a seat $or the 'oo!ed user provided the 'at h opted 'y the user has 'alan e seats. There$ore 'oo!ing an 'e termed as an intermediary 'etween user and student. 0s the user 'oo!s a seat, in a 'at h, he is provided with a 'oo!ing num'er, whi h an 'e made use in $uture during the registration.
En*"i!ies: ' This module omes in pi ture when the user wants to send )ueries or re)uests or suggestions to the entre. This module passes the message sent 'y the user dire tly to the Systems Domain Pvt. LTD. #e' server. The administration has the privilege to view the various )ueries and ma!e a de ision to in lude them in the 30" module.
FA+,s: ' This module has to ta!e are o$ the 30"s 'eing pu'lished on the net. The administrator goes through the various )ueries, whi h omes in the ,En*"i!ies- stage. The administrator duly appends these )ueries into 30" module using ,5asy 0dministrator- program. E-istin% system System St"dy The e(isting system is purely a manual one. The student is $or ed to ome to visit the institute. This mar!s the starting o$ a very tedious pro ess. The various ourses have 'een pro*e ted on a 'oard in the $ront o$$i e. The user glan es through the ourses or pro*e ts and the $ront o$$i er sta$$ handles en)uiries. The testing and interview
are handled manually. The registration pro ess $ollows through with lot o$ paper wor! involved in the pro ess. I$ a student wants to laim some dou'ts a'out the su'*e t he has to ome to the institute and approa h the on erned $a ulty. I$ in a situation the student or $a ulty is out o$ station the student annot even approa h the $a ulty. This leads dissatis$a tion to student. Pupil $rom di$$erent part o$ the world annot !now a'out the institute 'e ause there is no wide advertisement a'out the Institute. I$ the user wants to possess some )uery a'out the institute he is $or ed to ome to the institute and approa h the 3ront o$$i e sta$$s. This involves a tedious pro ess to the user. Be$ore a $ee payment has to 'e done manually lot o$ pro ess are re)uired to 'e ompleted. This leaves the user in $rustration. D!a. (ac)s • 0 time onsuming pro ess • The range o$ registration is limited due to distan e 'etween outlets. • Tedious leri al wor! or more usage o$ manpower undergone while entering details. • The entre $inds a di$$i ult to improve the networ! o$ its 'ran hes.
• The entre has 'een spending a huge amount in terms o$ pu'lishing and advertising. • The entre pays di$$i ulty to provide servi e to pupil $rom any part o$ the glo'e.
P!o#osed System P!ob$em Definition To design and develop a we' module titled ,+IS $or IT Institutionwhi h supports e. ommer e through online 'oo!ing, online registration and online test. To also $a ilitate easy a essi'ility o$ in$ormation right $rom any part o$ the glo'e . S/STE0 SPE&IFI&ATION ? 1a!d.a!e S#ecifications: Desc!i#tion 0inim"m P& #ith 1647 89:+B 89: ;B 8< 6B ;ey Board Printer, S anner Recommended P& #ith 1647 918 +B 918 ;B 18< 6B &ompati'le !ey'oard, mouse Printer >3or
System ty#e 20+ &a he Storage =ser Inter$a e %utput media
2eports? ? Soft.a!e S#ecifications:
OS
Soft.a!e
A##$ication Se!ve! +s IIS
Database Se!ve! +S S"L Server 8&LS? omplian e. The primary role o$ GS ript is development o$ #e' sites with 0SP.B5T and ustomi7ation o$ appli ations with S ript $or the .B5T 3ramewor!.
#e' 3orms
#e' 3orms are an 0SP.B5T te hnology that are use to reate programma'le #e' pages. #e' 3orms render themselves as 'rowser. ompati'le 4T+L and s ript, whi h allows any 'rowser on any plat$orm to view the pages. =sing #e' 3orms, we an reate #e' pages 'y dragging and dropping ontrols onto the designer and then adding ode, similar to the way that we reate @isual Basi $orms.
#indows 3orms
#indows 3orms is the new plat$orm $or +i roso$t #indows appli ation development, 'ased on the .B5T 3ramewor!. This $ramewor! provides a lear, o'*e t.oriented, e(tensi'le set o$ lasses that ena'les to develop ri h #indows appli ations.
C+L #e' Servi es
C+L #e' servi es are appli ations that an re eive re)uests and data using C+L over 4TTP. C+L #e' servi es are not tied to a parti ular omponent te hnology or o'*e t. alling onvention and an there$ore 'e a essed 'y any language, omponent model, or
operating system. In @isual Studio .B5T, we an )ui !ly reate and in lude C+L #e' servi es using @isual Basi , @isual &E, GS ript, +anaged 5(tensions $or &DD, or 0TL Server.
C+L Support
5(tensi'le +ar!up Language >C+L? provides a method $or des ri'ing stru tured data. C+L is a su'set o$ S6+L that is
optimi7ed $or delivery over the #e'. The #orld #ide #e' &onsortium >#A&? de$ines C+L standards so that stru tured data will 'e uni$orm and independent o$ appli ations. @isual Studio .B5T $ully supports C+L, providing the C+L Designer to ma!e it easier to edit C+L and reate C+L s hemas.
The .B5T 3ramewor!
The .B5T 3ramewor! is a multi.language environment $or 'uilding, deploying, and running C+L #e' servi es and appli ations. It onsists o$ three main parts1
4(
&55
&6
8Sc!i#t
9
&ommon Lan%"a%e S#ecification ASP.NET7 3eb Se!vices And 3eb Fo!ms ADO.NET: Data and :0L .NET F!ame.o!) (ase &$asses &ommon Lan%"a%e R"ntime 3indo.s Fo!ms
4is"a$
St"dio
.NET
&ommon Language 2untime
Despite its name, the runtime a tually has a role in 'oth a omponentHs runtime and development time e(perien es. #hile the omponent is running, the runtime is responsi'le $or managing memory allo ation, starting up and stopping threads and pro esses, and en$or ing se urity poli y, as well as satis$ying any dependen ies that the omponent might have on other omponents.
So"!ce So"!ce &ode &ode
&om#i$e &om#i$e !
&sc.e-e o! vbc.e-e
Assemb$y Assemb$y
)..! )/! for any.0'T language
D11 or '2'
&ommon Language 2untime &ompilation
=ni$ied programming lasses
The $ramewor! provides developers with a uni$ied, o'*e t. oriented, hierar hi al, and e(tensi'le set o$ lass li'raries >0PIs?.
&urrently, &DD developers use the +i roso$t 3oundation &lasses and Gava developers use the #indows 3oundation &lasses. The $ramewor! uni$ies these disparate models and gives @isual Basi and GS ript programmers a ess to lass li'raries as well.
0SP.B5T
0SP.B5T 'uilds on the programming lasses o$ the .B5T 3ramewor!, providing a #e' appli ation model with a set o$ ontrols and in$rastru ture that ma!e it simple to 'uild 0SP #e' appli ations. 0SP.B5T in ludes a set o$ ontrols that en apsulate ommon 4T+L user inter$a e elements, su h as te(t 'o(es and drop.down menus. These ontrols run on the #e' server, however, and push their user inter$a e as 4T+L to the 'rowser.
0D%.B5T
To move data 'etween a data store and the appli ation, we must $irst have a onne tion to the data store. In 0D%.B5T it is a'le
reate and manage a onne tion using one o$ two onne tion o'*e ts1 S)l&onne tion . an o'*e t that manages a onne tion to a S"L Server version I.< or later. %leD'&onne tion . an o'*e t that manages a onne tion to any data store a essi'le via %L5 DB.
The S)l&onne tion o'*e t is optimi7ed $or use with S"L Server I.< or later 'y >among other things? 'ypassing the %L5 DB layer. The %leD'&onne tion o'*e t intera ts with %L5 DB to e(pose a onsistent 0PI $or a variety o$ data sour es J everything $rom simple te(t $iles to spreadsheets and, o$ ourse, $ull.$eatured data'ases.
&onne tion Strings
Both types o$ onne tion o'*e ts e(pose roughly the same mem'ers. 4owever, the spe i$i mem'ers availa'le with a given %leD'&onne tion o'*e t depend on what data sour e it is onne ted toK not all data sour es support all mem'ers o$ the %leD'&onne tion lass. The primary property asso iated with a onne tion o'*e t is the &onne tion String property. 0 typi al &onne tion String property might loo! li!e the $ollowing1 Provider L S"L%L5DB.1K DataSour e L +yS"LServerK
Initial &atalog L B%2T4#IBDK Integrated Se urityLSSPI. The most ommon attri'uteMvalue pairs used 'y %L5 DB are also represented separately 'y an individual property, su h as DataSour e and Data'ase >and, optionally, =serId, and Password?. #hen wor!ing with a onne tion o'*e t, we an either set the &onne tionString property as a single string, or an set individual onne tion properties. >I$ the data sour e re)uires onne tion.string values that are not represented 'y individual properties, then we must set the &onne tionString property.? 0lternatively, we an also set the &onne tionString property to the path o$ a +i roso$t Data Lin! >.udl? $ile.
%pening and &losing &onne tions
The two primary methods $or onne tions are %pen and &lose. The %pen method uses the in$ormation in the &onne tionString property to onta t the data sour e and esta'lish an open onne tion. The &lose method shuts the onne tion down. &losing onne tions is essential, 'e ause most data sour es support only a limited num'er o$ open onne tions, and open onne tions ta!e up valua'le system resour es.
+ethods su h as 3ill only open and lose the onne tion automati ally i$ it is not already open. I$ the onne tion is open, the methods use it 'ut do not lose it. This gives the $le(i'ility to open and lose data ommands. In that ase, it is ine$$i ient to have ea h adapter open and lose the onne tion when we all its 3ill method. Instead o$ opening the onne tion, all the 3ill method o$ ea h adapter, and then lose the onne tion.
Pooling &onne tions
0ppli ations o$ten have di$$erent users per$orming the same type o$ data'ase a ess. 3or e(ample, in 0SP.B5T #e' appli ations
many users might 'e )uerying the same data'ase to get the same data. In those ases, the per$orman e o$ the appli ation an 'e enhan ed 'y having the appli ation share, or Npool,N onne tions to the data sour e. The overhead o$ having ea h user open and lose a separate onne tion an otherwise have an adverse e$$e t on appli ation per$orman e. #hile using the %leD'&onne tion lass, onne tion pooling is handled automati ally 'y the provider, so there is no need to manage it. #hile using the S)l&onne tion lass, onne tion pooling is
managed impli itly, 'ut also provides options that allow managing pooling. Transa tions &onne tion o'*e ts support transa tions with a BeginTransa tion method that reates a transa tion o'*e t >an %leD'Transa tion or S)lTransa tion o'*e t?. The transa tion o'*e t in turn supports methods that allow ommitting or rolling 'a ! the transa tions.
Tec no$o%ies "sed: .NET #hat Is .B5TO
.B5T is the +i roso$t #e' servi es strategy to onne t in$ormation, people, systems, and devi es through so$tware. Integrated a ross the +i roso$t plat$orm, .B5T te hnology provides the a'ility to )ui !ly 'uild, deploy, manage, and use onne ted,
se urity.enhan ed solutions with #e' servi es. .B5T. onne ted solutions ena'le 'usinesses to integrate their systems more rapidly and in a more agile manner and help them reali7e the promise o$ in$ormation anytime, anywhere, on any devi e. The +i roso$t plat$orm in ludes everything a 'usiness needs to develop and deploy a #e' servi e. onne ted IT ar hite ture1 servers to host #e' servi es, development tools to reate them, appli ations to use them, and a worldwide networ! o$ more than A9, 9> 9>
0ull > > >
0ame
Data type
Si5e 9> 6> 3> 6> 3> 6>
0ull 3 3 3 3 3 3
(achine@0ame nvarchar AserID 1ogin@Date 1ogin@Time 1ogout@Date 1ogout@Time
Table 6>4
nvarchar nvarchar nvarchar nvarchar nvarchar
0ame
=serID $name lname Phone *o'lo
Data type
nvar har nvar har nvar har nvar har nvar har
Si5e
9< 9< 9< 9< 9<
0ull
< < < 1 <
Table 634
0ame )ourse@)ode
Data type nvarchar
Si5e 9>
0ull 3
+rojects
Table 664
nvarchar
3>>
3
0ame
=serid te(p re(p s!ills 'e os t e t rhead $domain resume Table 674
Data type
nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nvar har nte(t
Si5e
9< 8 8 9< 9< 9< 1< 1< 9< 9< 1:
0ull
< < 1 < < < < < < 1 <
0ame
Sno 2ollTBo
Data type
numeri nvar har
Si5e
9 1<
0ull
< 1
StudentTBame &ourseT&ode Pro*e t TotalT3ee &entreT ode &ounsellor 5nrTDate 5nrTPear 5nrT+onth &ourseTStatus Table 684
nvar har nvar har nvar har int nvar har nvar har nvar har nvar har nvar har nvar har
A< 8< 1 9>
0ull > 3
0ame
testTtime Table 6:4
Data type
nvar har
Si5e
8<
0ull
1
0ame
Data type
Si5e
0ull
Su'*e tT&ode +ainTTopi Topi Duration re Tid Table 6;4
nvar har nvar har nvar har int numeri
8< 1