Attention all coders at RMCET! AICTE Smart India Hacathon 2017! Try to attend the facebook live

Dear coding passionates, here is a good opportunity to showcase your coding abilities and contribute towards nation building by participating in AICTE Smart India Hacathon 2017,  a Programing competition, digital product/service competition.

We invite you to join the Facebook live on 30th December by Mr. Adesh Gokhale, Executive Director, IBM, on how to tackle problem statements and be a part of the world's biggest digital movement.

Join the live at www.facebook.com/InclusiveInnovations/videos on 30/12/2016 at 11:00 AM.

You may come to college campus to utilize the free WIFI.

Spread this to all RMCET students good at coding (from any branch/year).

Detailed attendance now available for OS and NTAT here!

See them on respective subject page at bottom.

For Alumni - Positions @ Facebook in Mumbai with Dr. Ramesh Raskar (6 to 12 months, and not related to MIT)

Dr. Ramesh Raskar profile

See here the news about his research

Looking for great people with passion, skills and ideas for impact. These are well-paid positions at FB office in BKC @Mumbai for 6 to 12 months.

New grads, Post-docs, Designers, Medical students/residents/doctors, Agriculture experts, Women's issues, MBAs, Social scientists, Startup-enthusiasts, Faculty, Thought leaders or surprise us.

 All areas welcome: tech (hw, sw, machine learning, crowdsourcing, UX etc), health, bio, agriculture, energy, maps, and more

 We are also looking for TEAMS or STARTUPS that can solve amazing problems. Apply as a team.

 These are highly competitive positions with opportunity to make a serious impact on major problems. Please answer the questions below in detail.

 These projects are NOT affiliated with MIT-efforts in innovation centers in Mumbai, Nasik or Hyderabad.

Apply at http://tiny.cc/raskfbmumbai

SRTF code updated!

SRTF code updated!

See on OS page. You will need to get access first by logging in your Google account!

NTAT - New Page Created

Now onwards, students can see all the data related to NTAT on this page!

OS - New Page Created

Now onwards, students can see all the data related to OS on this page!

राष्ट्र्रध्वजाचा मान राखा!

See / download the viedo here.

New Project Ideas

1. Hospital Management/Medical record maintenance - Web portal for hospital. Users - Doctors of the hospital, patients; Patient data - all medical history, prev prescriptions - can be seen by any doctor; appointment; online bill payments; ....
2. Engineering College Management (Partly done)
3. Residential Complex Management (Taken)
4. Digital Signature using fingerprint (Not clear)
5. Hotel / Lodge Management - online registration of customers; DB accessible to police (Taken)

NTAT - ARPWATCH

Help

TE COMP - System Call

See

How to Use Wireshark to Capture, Filter and Inspect Packets (Howtogeek Tutorial)

See

How to Install Wireshark 2.0 in Ubuntu 15.10 Wily

View

Help on Wireshark

View

NTAT Expt Plan and Titles

View

NTAT

Syllabus

Reconnaissance:

• Short intro
• Details

तीन शब्दात पत्ता: एक अफलातून फंडा!

तीन शब्दात पत्ता: एक अफलातून फंडा!

Sign The Logical Indian's petition asking TRAI and the Telecom Ministry for proper regulations to guarantee consistent internet speeds

Sign The Logical Indian's petition asking TRAI and the Telecom Ministry for proper regulations to guarantee consistent internet speeds

Exciting! Students having me as their mentor should subscribe here

Dear Mentees (Students having me as their mentor), you should positively subscribe to push notifications from me.

Subscribe here.

NPL Expt. List with dates for T4

View

DBMS Expt list with dates

List

How To Configure BIND as a Private Network DNS Server on Ubuntu 14.04

See below

Procedure for C class

How to configure DNS server in ubuntu 14.04

Thorough Procedure for B class

How To Configure BIND as a Private Network DNS Server on Ubuntu 14.04

Trigger Example

We illustrate Oracle's syntax for creating a trigger through an example based on the following two tables:

CREATE TABLE T4 (a INTEGER, b CHAR(10));

CREATE TABLE T5 (c CHAR(10), d INTEGER);

We create a trigger that may insert a tuple into T5 when a tuple is inserted into T4. Specifically, the trigger checks whether the new tuple has a first component 10 or less, and if so inserts the reverse tuple into T5:

CREATE TRIGGER trig1
    AFTER INSERT ON T4
    REFERENCING NEW AS newRow
    FOR EACH ROW
    WHEN (newRow.a <= 10)
    BEGIN
        INSERT INTO T5 VALUES(:newRow.b, :newRow.a);
    END trig1;
.
run;

Notice that we end the CREATE TRIGGER statement with a dot and run, as for all PL/SQL statements in general. Running the CREATE TRIGGER statement only creates the trigger; it does not execute the trigger. Only a triggering event, such as an insertion into T4 in this example, causes the trigger to execute.

DBMS Important Questions

View

DBMS Presentaions

Download from Here

Courtacy: McGraw Hill Education

Dear T. E. Students, pl fill the academic mentoring form

Dear T. E. Students, the academic mentoring form is to be filled. The form is sent to your emails given by you in your registration.

Do fill it and also inform your friends about the same.

Best of luck for this semester!

Registration link for students of T. E. Computer Sem VI

Note: This registration is to be done ONLY after registration at CC!

Register Here