Practicals to be implemented

[Ankit Jaiswal]

Write queries and implement them for the attached document and write/implement query for following questions:

1.  Creation and querying of database tables for following cases. . a. Write SQL queries using logical operations (=,<,>,etc) b. Write SQL queries using SQL operators c. Write SQL query using character, number, date and group functions d. Write SQL queries for relational algebra e. Write SQL queries for extracting data from more than one table f. Write SQL queries for sub queries, nested queries g. Write programme by the use of PL/SQL h. Concepts for ROLL BACK, COMMIT & CHECK POINTS

i. Create VIEWS, CURSORS and TRIGGERS & write ASSERTIONS. j. Create FORMS and REPORTS 

4. The design of tables by normalization and dependency analysis. 5. Writing application software with host language interface 

5.Applications involving vendor development systems, stores management system, finance management etc. 

[Ankit Jaiswal]