February 6th, 2018 02:55 PM | |
Vishal Kotkar | 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 |
February 6th, 2018 02:55 PM | |
Unregistered | 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 ? |
January 21st, 2016 09:42 AM | |
nilesh | 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. |