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, sage, salary) AS SELECT E.ename, E.age, E.salary FROM Emp E WHERE E.age>50. Explain it.	CO2
5.	Explain what the system will do to process the following query: SELECT S.sname FROM SeniorEmp S WHERE S.salary >100,000.	CO2

Assignment – 3

1.      Define 2NF & explain it with one example.

2.      What is the motivation for 3NF?

3.      In what way 3NF is different from BCNF.

4.      Explain Dependency Preservation property of Decomposition.

5.      Discuss insertion, deletion, and modification anomalies. Why are they considered bad? Illustrate with examples.