#1
| |||
| |||
PRSU BCA Notes |
#3
| |||
| |||
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 |
|