0
sandeep

Data Base Mgt. System Lab

A Database Management DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications

Key Aspects of a DBMS Lab

Theoretical Foundation

The lab builds upon the theoretical knowledge of database concepts, including data models (like relational), normalization, and SQL

Practical Application

Students gain practical skills by working with real-world database scenarios, designing database structures, and writing SQL queries

Database Design

Students learn to design database schemas, including tables, relationships, and constraints, ensuring data integrity and efficiency. 

SQL Proficiency

The lab focuses on SQL, the standard language for interacting with relational databases, covering data manipulation (DML), data definition (DDL), and data control (DCL)

Database Management

Students learn about database administration tasks, such as data backup, recovery, security, and performance optimization

Tools and Technologies

The lab typically utilizes popular DBMS software like MySQL, PostgreSQL, or Oracle, allowing students to work with industry-standard tools

Projects and Assignments

Students engage in practical projects and assignments that involve designing, implementing, and managing databases for specific applications

Problem-Solving

The lab encourages students to solve real-world database problems, fostering critical thinking and problem-solving skills

  • Key Concepts Covered
    • Relational Model: Understanding the structure of data in tables and relationships between them. 
    • Normalization: Learning to design databases that minimize redundancy and improve data integrity. 
    • SQL: Mastering the SQL language for querying, manipulating, and managing data. 
    • Database Design: Designing efficient and effective database schemas for various applications. 
    • Transaction Management: Understanding concepts like ACID properties and concurrency control. 
    • Data Integrity and Security: Implementing measures to ensure data accuracy and protect sensitive information. 

 

0
sandeep

Microsoft Campus Agreement Program

What is the Campus Agreement program
The Microsoft® Campus Agreement is a subscription licensing program for higher education institutions. Campus Agreement can meet your technology needs without breaking your budget. It is a simple and quick way to get quality licensed software product for your faculty, staff, and students.

How does the Campus Agreement program work
It’s easy. You just count the number of Full-Time Equivalent (FTE) employees you have—both faculty and
staff. Then choose the application, system and Client Access License (CAL) products you want your
FTEs to use. You can also individually license server products. Your institution can run the licensed
product during your 12-month or 36-month licensed period. You’re licensed for all product upgrades and
downgrades during the licensed period. If you have a one-year subscription, your institution can extend
the temporary licenses each year with an extension order. If you have a three-year subscription, your
institution submits an anniversary order at the end of year one and year two. At the end of year three, you
can start a new subscription with a new subscription enrollment. If you choose not to extend your
subscription, you can either convert your temporary licenses to perpetual licenses through the Buy-out
option or remove the licensed product from your desktop Pcs.

What products can I get through Campus Agreement
With Campus Agreement, you can license the most current versions of any available Microsoft products.
Please refer to the Microsoft Volume Licensing Product List to see these products. You can choose as
many products as you like. (Minimum order requirements apply.)

Can I add products during my licensed period
Yes. Under Campus Agreement 3.5, you can add products to your coverage during the licensed period by
ordering them from your reseller. The licensed period for your additional products expires when your
initial annual licensed product order expires. Also under Campus Agreement 3.5, when you order a new
product, you will be charged a pro-rated price based on the number of months left in your annual term,
with a minimum six-month rate. So if you add a licensed product at month three, you will pay for nine
months (.75 x the annual price). If you order the new product at month nine, you will pay for six months (.5
x the annual price).

What is the pricing for Campus Agreement
Pricing for some Campus Agreement application, system, and CAL products is tiered and depends on
how many FTEs you have. Server products are priced individually. For exact pricing, please contact an
Authorized Education Reseller (AER) or local reseller in your region.

Do Campus Agreement customers receive the benefits of Software Assurance
Yes. Software Assurance membership is included with your Campus Agreement coverage, which entitles
you to product upgrades during the subscription term, resources and tools such as Home Use Program,
TechNet, and E-Learning courses. For details, visit the Software Assurance Web site or consult the
Microsoft Volume Licensing Product List.

How does my institution get media for the products in the subscription
You are automatically shipped one complimentary Starter Kit containing CDs or DVDs for the Campus
Agreement licensed products you ordered. You are also then registered for one complimentary Update
Subscription. With this subscription, you automatically receive a CD or DVD when a product you are
licensed for releases an upgrade or update during your subscription’s term. Your complimentary Starter
Kit and Update Subscription include media for up to two languages. If you require media for more than two
languages, you may order additional Starter Kits and Update Subscriptions from your Reseller.

Can the faculty and staff licensed under Campus Agreement use the licensed product at home
Yes. For no additional license cost, you can take advantage of faculty and staff Work At Home (WAH)
rights for any of the application, system, and CAL products you order for institution use. With these rights,
the primary user of a campus desktop PC can use the licensed product on a home desktop PC for work.
Users are not licensed to use the WAH licensed product at home for personal use. The school may incur
some costs for obtaining and distributing the WAH media. Also, under Campus Agreement 3.5,
institutions can take advantage of the Home Use Program (HUP), a benefit of the Microsoft Software
Assurance coverage included with the agreement. With HUP, your faculty and staff members can get
Microsoft Office system software to use on their home desktop PCs for both work and personal use at a
nominal cost. Providing the HUP licensed product is easy for your institution. Once your Software
Assurance benefits administrator activates the benefit, individual faculty and staff members can order
and pay for shipping of their licensed product online. Please note that institutions are not permitted to
provide licensed product with the same title to any individual faculty or staff member using both HUP and
WAH. For personal use, faculty and staff are also eligible to acquire specially priced Academic Edition full
packaged products

When students graduate, can they legally keep the licensed product on their own desktop PCs
Yes. On graduation, students licensed under the Student Option are granted perpetual use rights for the
selected Campus Agreement products. Note that you are responsible for ensuring that graduating
students with perpetual use rights receive a Student License Conrmation when they leave school. Your
institution must have a Student Option agreement in place when the student graduates so that it can
distribute the Student License Conrmation. Example: A university enters into a Campus Agreement on
August 1, 2007. It signs up for the Student Option and orders Ofce CDs for students. In January 2008,
100 students graduate. These students are legally licensed to keep the licensed product on their personal
desktop PCs when they graduate. If the university decides not to renew its Campus Agreement Student
Option on August 1, 2008, all remaining students must remove the licensed product from their desktop
PCs. If the university has not renewed the agreement and students graduate after August 1, 2008, they do
not legally own the product license(s) and must remove it from their desktop PCs




0
sandeep

Programming Lab

Intel Academic Developer Program : The Intel Academic Developer program is a sustained commitment by intel to collaborate with academic institution to help today students and educators prepare their software for the demands of tomorrow’s hardware.
Intel brings simplified, end-to-end parallelism to Microsoft Visual Studio* C/C++ developers with intel parallel Studio. intel Parallel Studio intel parallel studio eases implementation at every stage in the evelopment cycle for designing, coding, debugging, and tuning applications.
Through specially discounted programs Intel is making all of its world class developer products available to
academic institutions ensuring that the next generation of computer scientists and software engineers has
access to the latest Intel software, technology, and tools for education and research. For degree-granting
institutions of higher learning whose primary purpose is to provide education to the general public, (colleges and universities), and to faculty members and faculty personnel, Intel offers substantially discounted pricing on all Intel® Software Development Products. Faculty may be eligible for additional member benefits through the Intel Academic Community.
Academic pricing includes individual user and concurrent user licenses. Users also get one year of support
and product updates, which includes major and minor relea

Compilers

  • Intel® C++ Compiler Professional Edition
  • Intel® Visual Fortran Compiler Professional Edition
  • Intel® Visual Fortran Compiler Professional Edition
  • Intel® Compiler Suite Professional Edition

Intel® Parallel Studio

  • Intel® Parallel Studio Academic version

Performance Libraries

  • Intel® Integrated Performance Primitives (Intel® IPP)
  • Intel® Integrated Performance Primitives (Intel® IPP)

Cluster Tools

  • Intel® Cluster Toolkit
  • Intel® Cluster Toolkit Compiler Edition
  • Intel® Cluster Toolkit Compiler Edition
  • Intel® MPI Library

VTune™ Analyzers

  • VTune™ Performance Analyzer with Intel® Thread Profiler

Threading Analysis Tools

  • Intel® Thread Checker
  • Intel® Threading Building Blocks
  • The C++ Compiler Professional Editions include Intel Integrated Performance Primitives, Intel Math Kernel Library, and Intel Threading Building Blocks.
  • The Fortran Compiler Professional Editions include Intel Math Kernel Library.
  • The Compiler Suite Professional Editions include the Intel C++ Compiler, Intel Fortran Compiler, Intel
  • Integrated Performance Primitives, Intel Math Kernel Library, and Intel Threading Building Blocks.

 

0
sandeep

Artificial Intelligence Lab

Visual Prolog Features 

Visual Prolog is a logical programming language that count PDC prolog and Tubro prolog as predecessors. The goal of visual prolog is to support industrial strength programming of complex knowledge emphasized problems. Today Visual Prolog is a very powerful and safe programming language combining the very best features of logical, functional and objectoriented programming paradigms in a consistent and elegant way. Visual Prolog 7.2 is the newest generation of the Visual Prolog logical programming language that might be used for creating industrial strength applications for the Microsoft Windows 32 platform (Windows XP/2000/NT). It is a strongly typed object oriented programming language based on the Prolog programming language

Graphical Integrated Development Environment (IDE)

  • Visual Prolog Integrated Development Environment (IDE) is designed to make it easy, convenient and fast
    to develop, test, and modify applications written in Visual Prolog.
  • It might be especially useful in developing of large projects.
  • Tree representation of modules, include files, and resources in the Project window helps to group project
    items into packages and thus gives an extra level of abstraction.
  • The Text Editor supports convenient text editing and browsing to declarations and implementations.
  • The Dialog Editor provides standard controls to design dialogs.
  • The Menu Editor allows to create both pull-down and pop-up menus.
  • The Toolbar Editor allows to create various kinds of toolbars.
  • The Graphics Editor is a convenient tool for creating, viewing and editing icons, cursors and small bitmaps.
  • The Build Facility supports inserting of necessary packages and include directives.
  • The Browse Facilities supports search for specific entities, “go to definition” and “go to declaration”

Compiler


The Visual Prolog compiler is a successor of the Turbo Prolog compiler created in 1980s that was the first Prolog compiler. Since that time the Prolog Development Center has been developing and improving its compiler. Currently Visual Prolog compiler is a powerful and efficient compiler that can: Create object files for creating standalone executables or dlls;

  •  Resolve cross references among declarations;
  • Validate predicate mode;
  • Perform powerful type checking;
  • Validate facts initialization in constructors; Perform predicate resolution

Linker


Visual Prolog contains a powerful linker that can: Create EXE and DLL files;

  • Use LIB files, generated by the latest Microsoft Visual C compilers.

Debugger


The Visual Prolog Development Environment contains a built-in graphical debugger that can:

  • Show usual debugger views: memory, stack, variables;
  • Show class and object facts with their values;
  • Perform step into, step over, etc;
  • Including extra stepping: step out, run to prolog code;
  • Visualize fail and exit.








0
sandeep

EstiNet 7.0  is a software tool for network planning, testing, education, protocol development, and application performance prediction. It is both a network simulator and emulator with worldwide customers and global impact EstiNet is an innovative network simulator and emulator with many academic honors

  •  Searching “network simulator” on Google, EstiNet is ranked at a very top
     position for its high and global impact.
  •  Uses a novel simulation methodology, which enables it to provide many   unique advantages that traditional
     network simulators and emulators cannot provide.
  •  Has been selected as a research demonstration by prestigious   international conferences.
  •  More than 20,000 people  from 140 countries have registered and used   it.
  •  Google Scholar shows that EstiNet has been used in 510 published   international research papers

Feature

  • Linux real-world protocol stacks are directly used to generate accurate simulation/emulation results.
  • Any Linux real-world application programs can be directly run up on a simulated network to provide two great advantages:
  • These applications can be used to generate realistic network traffic & thus generate high-fidelity simulation results.
  • The real-world functions and performance of these applications can be evaluated under various network conditions before they are released to the market..
  • Emulation can easily vary the network conditions on the Internet path between a real-life server and a
    client. This capability can easily test the functions and performance of a real-life device or application
    before it is released to the market.
  • Many types of networks are simulated including Ethernet-based fixed network, wireless LAN, mobile ad hoc network, WiMAX, LTE, DSRC wireless vehicular networks, satellite, optical, etc.
  • IP address setup and configurations for a network simulation/emulation case are very easy and exactly the same as those needed for setting up a real-world network.
  • Complete user and developer manuals and reliable technical supports are provided.
  • GUI environment is very user-friendly and intuitive. Setting up a simulation/emulation case just needs a few minutes.

Networks Simulation : The supported networks include Ethernet-based fixed Internet, IEEE 802.11(a/b) wireless LANs, Mobile ad hoc (sensor) Networks, GPRS Cellular Networks , Optical Networks (including both Circuit-Switching & Busrt-switching Networks), IEEE 802.11(d) Dual-radio Wireless mesh Networks, IEEE 802.11(e) QoS.
Wireless LANs, Tactical and active Mobile ad hoc Networks, 3dB beamwidth 60-degree and 90-degree
steerable and directional antennas, IEEE 802.16(d) WiMAX Wireless Networks (including the PMP and mesh modes), DVB-RCS Satellite Networks, Wireless Vehicular Networks (VANET) for Intelligent Transportation Systems (including V2V and V2I), Multi-interface Mobile nodes for Heterogeneous Wireless Networks, IEEE 802.16(e) Mobile WiMAX Networks, IEEE 802.11(p)/1609 WAVE Wireless Vehicular Networks, Various Realistic Wireless Channel Models, IEEE 802.16(j) Transparent Mode & Non-transparent Mode WiMAX Networks, LTE Networks, etc.

Protocols Simulation : For Example, IEEE 802.3 CSMA/CD MAC, IEEE 802.11 (a/b) CSMA/CA MAC, IEEE
802.11(e) QoS MAC, IEEE 802.11(b) Wireless Mesh Network Routing Protocol, IEEE 802.16(d)(e)( j) WiMAX Wireless MAC & PHY, DVB-RCS satellite MAC and PHY, LTE MAC and PHY, Learning Bridge Protocol, Spanning Tree Protocol, IP, Mobile IP, Diffserv (QoS), RIP, OSPF, UDP, TCP, RTP/RTCP/SDP, HTTP, FTP, Telnet, BitTorrent, etc.

EstiNet 7.0 Network Simulator and Emulator

  • Fixed network Library (Ethernet hub/switch/router, optical networks, RIP/OSPF routing protocols)
  • Wireless Library (IEEE 802.11 (a)(b) ad-hoc and infrastructure mode networks, mobile ad hoc networks, IEEE 802.11(b) wireless mesh networks, Mobile IP, GPRS networks, channel propagation models)
  • Media streaming and QoS Library (RTP/RTCP/SDP, QoS Diffserv, IEEE 802.11(e) QoS WLAN)
  • The ability to use any real-life network applications during a simulation/emulation.
  • The ability to use the real-life Linux TCP/IP protocol stacks during a simulation/emulation.

Optional Add-on Modules

  • IP real network emulation Library (can be used to test the functions and evaluate the performances
  • of any real-life devices)
  • WiMAX network Library (IEEE 802.16 (d)(e)(j) networks)
  • LTE network Library
  • Satellite Library (DVB-RCS satellite networks)
  • Tactic and Active Mobile Ad Hoc Network Library

0
sandeep
  1. MENET (IETFC 4278)
    A mobile ad hoc network (MANET), sometimes calls a mobile mesh network is a selfconfiguring network of mobile devices connected by wireless links. NetSim implementation features 802.11 MAC and PHY along with random way point mobility model which is user modifiable. A mobility animator is buil in for visualization for the MANET network. DSR (Dynamic source Routing) algorithm has been implemented in layer 3. DSR is an on demand protocol designed to restrict the band Width consumed by control packets in adhoc wireless network.
  2. MPLS (IETF RFCS 3031 and 3121)
    MPLS is an internet Engineering Task force (IETF) specified framework that provides efficient forwarding. Routing and switiching of traffic flow through a network LDP (Label Distribution protocol) and CR-LDP (Constraint Based Routing Label Distribution Protocol)
  3. Wi-MAX (IEEE802.16 2004)
    Wi-MAX model suite lets you analyze network performance in wireless metropolitan area networks UGS (Unsolicited Grant Service) –QoS services has been implemented in Wi-MAX UGS supports real time traffic (VOIP)and offers fixed size unsolicited data grants on a periodic basis The physical layer has been modeled on OFDM (orthogonal Frequency Division Multiplexing), in which a large number of closely spaced orthogonal sub carriers are used to carry data.
  4. BGP (IEE 802. 16 2004)
    The Most common Exterior Gateway Protocol in use on the internet is border gateway protocol (BGP). BGP isan inter – autonomous system routing protocol and is used to exchange routing information between two autonomous systems.BGP version 4 has been implemented with Path Vector Routing algorithm which BGP uses to form the routing table BGP can use either RIP OR OSPF as its intra-autonomous system routing protocol.Both internal (RIP/OSPF) and external (BGP) routing tables are shown.