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 functions. Apply them on any table.	CO2
2.	Explain the structure of relational databases.	CO2
3.	Create a table with minimum 5 attributes and apply all DML statements.	CO2

Tutorial – 5

1.      What is meant by Functional Dependency? Explain it with an example.

2.      What is meant by Normal Form? What is the role the Normalization? Explain 1NF, 2NF and 3NF with an example.

3.      What is lossless join? Briefly describe problems caused by redundancy.

Tutorial – 6

1.      How does BCNF differ from 3 NF? Explain with an example.

2.      Summarize normal forms based on primary keys and the corresponding normalization process.

3.      What is fourth normal form? When is it violated? When is it typically applicable?