Scribd
Upload
13 views2 pages

Adms Index

The document outlines a series of tasks related to database management and SQL implementation, including database design, DDL and DML command execution, and the use of constraints. It also covers advanced topics such as nested queries, triggers, and embedded SQL, as well as the roles and techniques of a database administrator. Each task is numbered and includes specific operations to be performed, emphasizing the practical application of database concepts.

Uploaded by

Anu Tiwari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

Adms Index

The document outlines a series of tasks related to database management and SQL implementation, including database design, DDL and DML command execution, and the use of constraints. It also covers advanced topics such as nested queries, triggers, and embedded SQL, as well as the roles and techniques of a database administrator. Each task is numbered and includes specific operations to be performed, emphasizing the practical application of database concepts.

Uploaded by

Anu Tiwari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

SR.NO. TASK PAGE NO.

REMARKS

1. . Database design using E-R model and Normalization


(Any 3 systems).

2. Implementation of DDL Commands to perform


creation of table, alter, modify and drop column
operations .

3. Implementation of Constraint

 Check Constraint

 Entity Integrity Constraint

 Referential Integrity Constraint

 Unique Constraint

 Null Value Constraint

4. Implementation of DML and DCL Commands.

5. implementation of Data and Built in Functions in SQL

6. Implementation of Nested Queries and Join Queries.

7. Implementation of Cursors.

8. . Implementation of Procedures and Functions.

9. Implementation of Triggers.

10. Implementation of Embedded SQL

11. Consider a Database applications, Design and


Develop Conceptual Data Model (E R Diagram) with
all the necessary entities, attributes, constraints and
relationships. Design and build Relational Data
Model for application specifying all possible
constraints

12. Implementation of various DBA roles/techniques

 Creation of user

 Granting of privileges to the users

 Creation of roles

 Loading of privileges into user defined roles.

 Import/Export data between various databases


and flat files

You might also like