RELATIONAL DATA BASE MANAGEMENT SYSTEMS (RDBMS) Syllabus of Andhra University 2017 to 19

-
MSCS 2.2   RELATIONAL DATA BASE MANAGEMENT SYSTEMS
Instruction: 3 Periods + 1 Tut/week                                                    Credits:4
Internal: 30 Marks           University Exam: 70 Mark       Total: 100 Marks


 1.      Database Systems:
Introduction to the Database System, Introduction three layered Architecture, Data Modeling, Concepts of Relational Models and Relational Algebra.

 2.      SQL:
Introduction to SQL Queries, Integrity Constraints, Joins, Views, Intermediate and Advanced SQL features and Triggers.

 3.      Database Design:
Overviews of the Design process, E-R Models, Functional dependencies and other kinds of dependencies, Normal forms, Normalization Techniques and Schema Refinement.

 4.      Database Application Design and Development:
User Interfaces and Tools, Embedded SQL, Dynamic SQL, Cursors and Stored procedures, JDBC, Security and Authorization in SQL, Internet Applications.

 5.      Query Evaluation:
Overview, Query Processing, Query optimization, Performance Tuning.

 6.      Database System Architectures:
Centralized and Client- Server Architecture, Server system Architecture, Parallel and Distributed database, Object based databases and XML. Advanced data types in databases. Cloud based data storage Systems.

 7.      Transaction Management:
Overview of Transaction Management, Transactions, Concurrency control, Recovery systems, Advanced Transactions Processing.

 8.      Case Studies:
Postgre SQL, Oracle, IBM DB2 Universal Database, Microsoft SQL Server.
Text Books:

1.      Database System Concepts, Avi Silberschatz , Henry F. Korth , S. Sudarshan McGraw-Hill, Sixth Edition, ISBN 0-07-352332-1. 

References:

1.      Database Management Systems, Raghu Ramakrishnan, Johannes Gehrke,McGraw-Hill.

2.      Schneider, Robert D & J. R. Garbus Optimizing SQL.

Comments

Post a Comment

Popular posts from this blog

What is OSI model ? Explain the Layers of OSI model with diagram .

-
Image
What is OSI model ? Explain the Layers of OSI model with diagram . What is OSI model? The OSI model (Open System Interconnection) model defines a computer networking framework to implement protocols in seven layers. A protocol in the networking terms is a kind of negotiation and rule in between two networking entities. Layers of OSI model: Physical layer The Physical layer is also called as the Layer 1. Here are the basic functionalities of the Physical layer: ·        Responsible for electrical signals, light signal, radio signals etc. ·        Hardware layer of the OSI layer ·        Devices like repeater, hub, cables, ethernet work on this layer ·        Protocols like RS232, ATM, FDDI, Ethernet work on this layer Data Link layer The data link layer is also called as the Layer 2 of the OSI model. Here are the basic functionalities of the data link layer: ·        Responsible for encoding and decoding of the electrical signals into bits. ·
Read more

BUS AND MEMORY TRANSFERS

-
Image
BUS AND MEMORY TRANSFERS          A typical digital computer has many registers, and paths must be provided to transfer in formation form one register to another. The number of wires will be excessive if separate lines are used between each register and all other registers in the system. A more efficient scheme for transferring information between registers in a multiple-register configuration is a common bus system. A bus structure consists of a set of common lines, one for each bit of a register, through which binary information is transferred one at a time. Control signals determine which register is selected by the onus during each particular register transfer.           One way of constructing a common bus system is with multiplexers. The multiplexers select the source register whose binary information is then placed on the bus. The construction of a bus system for four registers is shown is Fig . Each register has four bits, numbered 0 through 3. The bus consists
Read more