BCA 5th Sem DBMS ASSIGNMENT QUESTIONS

IMPORTANT QUESTIONS FROM 5th UNIT

* Explain ORDER BY, GROUP BY and HAVING clause with example.

* Explain different DBMS languages such as DDL(create,alter,drop),                    
   DML(insert,update,delete),DRL(select), DCL(commit,rollback),TCS(grant,revoke) 
   commands with example.

* Explain datatypes in SQL.

* Explain SQL constraints with example.

* Explain aggregate functions in SQL.

* Define transaction. Explain transaction processing system and its ACID properties.

* Explain views in SQL.

Important note : Digital copies are also accepted. Create word or pdf copy of the assignment and mail at assignbca@gmail.com with subject of mail as "Name-Regno-DBMS" (This decision taken based on unavailability of assignment books)
OR
Write and submit the assignment before 10/10/2018.
Content may be web based.

Read More

BCA 5TH SEM - DBMS LAB MANUAL 2018 (NEW)

TAKE PRINTOUT OF THE BELOW GIVEN FILE, BIND IT AND CONSIDER IT AS JOURNAL WHICH CONTAINS 10 LAB EXERCISES.


CLICK TO DOWNLOAD ALL IN ONE FILE

Read More

BCA I Sem - CF - ASSIGNMENT

             
ASSIGNMENT

* Explain stored programming concept(minimum 1 page).

* Explain different types of computers(minimum 2 pages).

* Describe history and evolution of computers(minimum 2 pages).

* Describe multiprogramming, multitasking, multithreading, time sharing, real time, single user and multi user operating systems(minimum 4 pages).

* Explain any 5 input and 5 output devices with diagrams(minimum 4 pages).

* Describe any 2 secondary storage devices(minimum 2 pages).

File format : MS Word (.docx) or .pdf

Font size - Headings : 14

Font size - Text : 12

Font style - Times New Roman

Submission mail : assignbca@gmail.com

Last date for submission : 5/10/2018

First page of your document should have your name, rollno and subject name. 

Every student should have a mail id and the document should be sent by their own mail id.

Subject while sending mail should be "CF - Name with Rollno" ( Ex : CF - Santoshumadi19 ) 

if name is santoshumadi and rollno is 19.

Tip : Use google to search best notes from the internet. You can copy the details from the internet.

Warning : If found duplicate copies, both copies will be rejected.

Read More

BOOK DEALER DATABASE - TABLE DATA

Read More

STUDENT ENROLLMENT AND BOOK ADOPTION DATABASE - TABLE DATA

Read More