ºÝºÝߣ

murugan rdbms alagappa university keys madan deleting a package oracle packages definition of a cursor creating a cursor declaring the cursor opening the cursor attributes of an explicit curs attributes of an implicit curs accessing the cursor rows closing a cursor steps for executing a cursor example program transaction executing a packages syntax for package creation package body section package specification section definition of packages sample program using function syntax for creating function deifference: function and proc definition of function drop procedure sample pgms using procedure data structure and querying semi structured data model object based data model normalization the entity relationship model database design for banking en design process database design relational databases data definition language data manipulation language database languages data model instance and schema data abstraction view of data purpose of database system database system applications introduction to database manag example queries transaction control declaratio pl/sql transaction autonomous transaction transaction declaration and c discreationary transaction transaction management example for transaction definition of transaction if then command control structures how pl/sql works exception execution section constant variable declaration section structure of pl/sql block deleting synonym removing synonym dropping synonym renaming synonym creating synonym for table create synonym command definition synonym deleting a role view the roles of a user granting privileges and roles creation of role system privileges and object p revoke object privileges viewing a users privileges deleting a user grant command user creation commands definition of user procedure with argument procedure with no argument syntax for procedure creation procedures trigger-difference definition of stored procedure replicating trigger with delet obtaining information about a replicating with trigger - ins validating data entry reference to column inside deleting a trigger modifying a trigger syntax for creating a trigger user event trigger system event trigger instead of trigger row level or statement level table trigger types of trigger components of a trigger advantages and disadvantages o difference between trigger and definition of trigger integrating sql in pl/sql pgm. while command for loop command loop with when loop with if loop command homogeneous and heterogeneous distributed databases alagappa government arts colle intra-query parallelism inter-query parallelism handlings of skew partitioning techniques io parallelism introduction parallel databases interconnection network speedup and scaleup transaction server process server system architecture distributed database processin parallel database system client server database system database system architectures cursor handling trigger creation search address using function voters information rdbms lab group b computer science alagappa government arts clg delete updation tcp/ip reference model osi reference model interface and protocol service primitives connection-less connection-oriented design issues protocol hierarchies network software personal area network internetwork metropolitan area network wide area network local area network pont-to-point broadcast uses of computer network distributed system internet and world wide web introdutction to computer network alagappa govt. college query transformation distributed query processing distributed transactions data fragmentation data replication distributed data storage insertion third normal form bcnf dependency preservation boyce-codd normal form trivial functional dependency functional dependencies decomposition first normal atomic domains design alternative features of good relational da relational database design specializations specialization generalization extended e-r features weak entity sets entity-relationship design lss entity-relationship diagrams participation constraints constraints mapping cardinalit constraints attributes relationship sets entity sets the entity-relationship model database design and er model procedure without arguments procedure with arguments procedure book magazine employee table creation student table creation sql karaikudi alagappa government arts clg. rdbms practical group a rdbms practical count avg min max programming select drop table alter table create table e-r model and normalization database-design process fourth normal form multivalued dependencies lossless decomposition closure of a set higher normal forms storage manager