THIRD SEMESTER DIPLOMA COMPUTERSCIENCE DBMS
REVISION-06 SYLLABUS
UNIT-1
1.UNDERSTAND DATABASE
*Define Field,Record,Database
*Define Field,Record,Database
*Distinguish between physical record-and
Logical Record
*Explain Advantages of DBMS
*Understand Schemes,Subschema-Instances.Three schema architecture
*Understand Schemes,Subschema-Instances.Three schema architecture
*Define data independence
*Distinguish b/w Logical data independence
and physical data independence
2.EXPLAIN DATABASE SYSTEM
STRUCTURE(ARCHITECTURE)
*Explain Storage manager,Query processor,Disk
storage,Database Users
*Discuss Database Languages-DDL,DML,DCL
*Understand various Database system
application architecture like Centralized DBMS architecture,Basic client/server
architecture,Two tier client/server architectures,and three tier client/server
architectures
3.DATA MODELS
*Understand ER model
*Define Entity,Attribute,Keys,Relationship
types,Relationship set
*Define Primary key,Candidate key,Super key
*Explain ER diagram,Weak entity set
*Compare ER Model and Enhanced ER Model
*Understand EER Model:”Subclasses-Super
classes-Inheritance-Specialisation-Generalisation
*Untitles Modelling Language-Class diagram
UNIT-2
1.UNDERSTAND RELATIONAL MODEL CONCEPTS
*Define Domains,Attributes,Tuples
*Define Domains,Attributes,Tuples
*Study Mapping ER model to Relational model
*Explain Constraints:Domain constrains,Key
constrains,Entity integrity,Referential integrity,Foreign keys
2.UNDERSTAND RELATIONAL DATABASE DESIGN
*Explain design guidelines for relational
schema
*Explain Functional dependency
*Define Normalization
*Explain normal forms:1NF-2NF-3NF-Boyce
Codd Normal Form
*Explain Decomposition,Dependency
preservation,Multi-valued dependencies
*Explain 4NF with example
*Understand join dependencies and define
5NF
UNIT-3
1.UNDERSTAND SQL
*Explain features of SQL
*Explain Data types in SQL
*Understand Domains,attributes and tuples
*Explain CREATE TABLE command
*Explain
Constraints:NULL,DEFAULT,CHECK,PRIMARY KEY,UNIQUE,referential Integrity
*Understand DROP TABLE Command,ALTER TABLE
*Understand DROP TABLE Command,ALTER TABLE
*Understand commands for creating and roping indexes CREATE INDEX,CREATE UNIQUE INDEX,DROP INDEX
*Understand commands for creating and roping indexes CREATE INDEX,CREATE UNIQUE INDEX,DROP INDEX
*Explain SELECT statements with WHERE,ORDER
BY clause with example
*Explain UPDATE Statement,INSERT,DELETE
with example
*Explain Nested queries,tuples and multi
set comparison,Correlated nested queries
*Explain EXISTS and UNIQUE functions
*Explain explicit sets and renaming of
attributes
*Explain Joining tables-aggregate functions
*Explain grouping:GROUP BY,HAVING clauses
*Explain BEGIN TRANS,COMMITT,ROLL BACK,SAVE
POINT
*Explain Views:Advantages,Creation and
Updation
UNIT-4
*Understand advanced SQL
*Study triggers and cursors
*Study reports and forms
*Explain stored procedures and functions
*Discuss how procedures are invoked from
interface
1.UNDERSTAND EMBEDDED SQL
*Understand about Embedded SQL statements
and its application
*Explain retrieving single tuples with
embedded SQL
*Explain retrieving multiple tuples with embedded SQL using cursor
*Explain retrieving multiple tuples with embedded SQL using cursor
*Explain dynamic SQL by specifying queries
at run time
*Discuss embedding SQL commands in
JAVA
*Discuss database programming with SQL
using C as a host language
UNIT-5
1.UNDERSTAND FILE MANAGEMENT AND DATA
STORAGE
*Explain placing File Records
on Disk:Records,record types,Fixed length record,variable length record
*Explain Heap files,Sorted
files,Hashing,files of mixed records
*Explain RAID technology,Storage area
networks
2.EXPLAIN DISTRIBUTED DATABASE AND ITS
ARCHITECTURE
*Explain advantages of distributed database
over centralized database
*Explain data storage in distributed
database:Data fragmentation and Data replication
3.UNDERSTAND VARIOUS INDEXING
STRUCTURES:PRIMARY INDICES,CLUSTERING INDICES,SECONADARY INDICES,INDEX ON
MULTIPLE FIELDS
4.TRANSACTION MANAGEMENT
*Define Transaction
*Explain transaction concepts
*Understand Properties of
transactions,Transaction States
*Explain Concurrent Executions
*Explain Serializability
0 comments:
Post a Comment