UNIT-I


    Introduction : 
	
	Purpose of the data base system, 
	data abstraction, 
	data model, 
	data independence, 
	data definition language, 
	data manipulation language, 
	data base administrator, 
	data base users, 
	overall structure.


   ER Model : 
	
	entities, 
	mapping constrains, 
	keys, 
	E-R diagram, 
	reduction E-R diagrams to tables, 
	generatio, 
	aggregation, 
	design of an E-R database scheme.


  UNIT-II


    Relational Model : 
	
	The catalog, 
	base tables and views.  
	Relational Data Objects - Domains and Relations: 
	Domains, 
	relations, 
	kinds of relations, 
	relations and predicates, 
	relational databases.
	Relational Data Integrity - Candidate keys and related matters: 
	Candidate keys. 
	Primary and alternate keys. 
	Foreign keys, 
	foreign key rules, 
	nulls. 
	Candidate keys and nulls, 
	foreign key and nulls.


  UNIT-III


    The SQL Language: 
	
	Data definition, 
	retrieval and update operations. 
	Table expressionsconditional expressions, 
	embedded SQL.


    Views: 

	Introduction, 
	what are views for, 
	data definition, 
	data manipulation, 
	SQL support.


   UNIT-IV

 
     Network model : 
	
	basic concepts, 
	data structure diagrams, 
	DBTG CODASYL model, 
	DBTG data retrival facility, 
	DBTG update facility, 
	DBTG set processing facility, 
	mapping networks to file, 
	networks system.

    Hierarchical model : 

	basic concepts, 
	tree structure diagrams, 
	data retrieval facility, 
	update facility, 
	virtual records, 
	maping hierarchical to files, 
	hierarchical system.


  UNIT-V


    File and system structure : 

 
   	overall system structure, 
	file organisation, 
	logical and physical file organization, 
	sequential and random, 
	hierarchical, 
	inverted, 
	nullist,
	indexing and hashing, 
	B-tree index files. 
  


  Recommended Books:-
 
  
	1. Date C.J., Database Systems, Addision Wesley. 
	2. Korth, Database Systems Concepts, McGraw Hill. 

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Follow by Email

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Google+ Followers

Translate

Powered by Blogger.

- Copyright © All Notes on BCA - Metrominimalist - Powered by Blogger - Designed by Johanes Djogan -