Go Back   2023 2024 Courses.Ind.In > Main Category > Main Forum

  #1  
Old January 21st, 2016, 09:42 AM
Super Moderator
 
Join Date: Apr 2013
Default PRSU BCA Notes

Discuss about prsu bca notes here. Welcome to Courses.ind.in and this page is for prsu bca notes discussion. If you are looking for information on prsu bca notes then ask your question is as much details as possible in the “Reply” box provided below. The more detailed your question will be, the more easy will it be for our experts to answers your query. And if you have any updated or latest information on prsu bca notes, then please share you knowledge with our experts in the “Reply” box below. Your reply will be published here and your knowledge can help many people. Thanks for stopping by at Courses.ind.in. Please visit again.
Reply With Quote Quick reply to this message
  #2  
Old February 6th, 2018, 02:55 PM
Unregistered
Guest
 
Default Re: prsu bca notes

Hii sir, I Wants to get the Syllabus of the DBMS (Oracle, SQL) of the BCA Course of the Pandit Ravishankar Shukla University ?
Reply With Quote Quick reply to this message
  #3  
Old February 6th, 2018, 02:55 PM
Super Moderator
 
Join Date: Aug 2012
Default Re: prsu bca notes

Pt. Ravishankar Shukla University is an institution of higher education located in Raipur, Chhattisgarh, India. It is one of the largest and oldest institution of higher education in Chhattisgarh.

The Syllabus of the DBMS (Oracle, SQL) of the BCA Course of the Pandit Ravishankar Shukla University is given below

DBMS (Oracle, SQL)


UNIT–I OVERVIEW OF DATABASE MANAGEMENT SYSTEM :
Database, Definition of DBMS, Purpose of Database System, Data abstraction, Instances and Schema, Data Independence, Data administration roles, Different kinds of DBMS users, Data Dictionary, Data base languages- DDL, DML, DCL Data ModelsThe Relational approach, The Network approach, The Hierarchical approach, DBMS storage structure and access method.

UNIT–II ENTITY-RELATIONSHIP MODEL:
Entity - Relationship model as a tool for conceptual design-entities attributes and relationships. ER diagrams; Concept of keys: candidate key, primary key, alternate key, foreign key; Strong and weak entities, Case studies of ER modeling Generalization; specialization and aggregation. Converting an ER model into relational Schema.

UNIT–III Structured Query Language Relational Algebra
: select, project, cross product different types of joins (inner join, outer joins, self join); set operations, Simple and complex queries using relational algebra. Integrity constraints: Not null, unique, check, primary key, foreign key. UNIT–IV Relational Database DesignNormalization concept in logical model; Pitfalls in database design, update anomalies: Functional dependencies, Join dependencies, Normal forms (1NF, 2NF, 3NF). Boyce Codd Normal form, Decomposition, Multi-Valued Dependencies, 4NF, 5NF.

UNIT–V INTRODUCTION TO ORACLE
: Introduction to Commercial database query language, SQL & its environment. SQL as a data definition language- creating tables, altering tables, drop tables. SQL as data manipulation language- Inserting, Deleting ,Retrieving and updating data in a table. SQL as query language. Introduction to SQL constructs (SELECT…FROM, WHERE… GROUP BY… HAVING… ORDERBY….), Temporary tables, Nested queries

Contact Details :
Pt. Ravishankar Shukla University
Address: G.E.Road, Amanaka, Raipur, Chhattisgarh 492010
Phone: 077122 62540
Reply With Quote Quick reply to this message
Reply
Similar Threads
Thread
Download PRSU Admit Card
PRSU BA Result
PRSU BSC Admit Card
PRSU Bhilai
Phd admission PRSU
PRSU Annual Exam Result
India Results Chhattisgarh PRSU
PRSU Mcom Time Table
PRSU Job
prsu supplementary results
prsu bsc final result
prsu bhms result
exam result prsu
b.ed result prsu
prsu university raipur
prsu raipur time table
prsu raipur vacancy
PRSU Exam Result
PRSU Time Table B.Com
PRSU Raipur results micsbpl.com


Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5.5. The time now is 07:22 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.1
vBulletin Optimisation provided by vB Optimise (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.