Database Management Systems

DBMS Assignments(1 - 5)

DBMS - Tutorials(1 - 10)

 DBMS ( Assignments - 1 to 3) Assignment – 1 1. Describe the database languages and commands. CO1 2. Draw ER Diagram for the Department. CO1 3. Advantages of DBMS over file system CO1 4. Explain the levels of abstraction of DBMS structure. CO1 5. Draw the architecture of DBMS? Classify users accessing DBMS CO1 Assignment – 2 1. What is integrity constraints? How do you explain this. CO2 2. What is the general syntax of SELECT statement? CO2 3. Create schema for: Emp(eid:integer, ename:string, age:integer, salary: real) Works(eid: integer, did: integer, pct_time: integer ) Dept(did: integer, budget: real, managerid: integer) CO2 4. Suppose you have a view SeniorEmp defined as follows: CREATE VIEW SeniorEmp(sname...

DBMS(Tutorials - 1 to 6) Tutorial – 1 1. Define Data, Database, DBMS, Information and Knowledge. CO1 2. Write the drawbacks of File System? CO1 3. Discuss applications of DBMS I with internal architecture. CO1 Tutorial – 2 1. Explain all keys with an example. CO1 2. What is meant by cardinality & degree of relationships? CO1 3. How to reduce an ER Diagram to a Table/Relation? CO1 Tutorial – 3 1. Explain Relational Algebra operations. CO2 2. Create 3 Tables(Like Department, Staff, Student....) with at least 5 attributes, by making one of them as Primary Key. CO2 3. What are the different database languages? Explain them. CO2 Tutorial – 4 1. List out aggregate ...