Database System

Question no :- Write at leust five advantages of dataase approach over comventional file bused :

Question no wz Reliability and security with respect to relation DBMS

Question no > what is key ?Primary key and foreign key

Question no: Write a note on components of DBMS.

Question no) Define attributes and its types.

Question no Differentiate file processing system and database processing systems. And

discus disadvantages of file processing system over database processing systems.

Question no Define briefly relationship, Degree of relationship, cardinality of relationsh

database schema and attribute domain.

Question no :- Write a detailed note on different ty pes of dala dependencies, also give examples

Qucstion no : Discuss in detal the reliahility and sourity with respet to nelation databae sysl

Question no :> Discus the major responsibility of DBA in data base environment.

Qustion no : Explain the functionalty of DBMS as major components of data base envis

Question no > Explain the five main disadvantages of file processing system.

Question no s-Write a brief note on history of database processing-

Question no :- Define entity, attribute and relationship with examples.

Question no > Define Functional Dependency and its types with examples.

Question noc- List the major compononts of a databuse systems, and briefly explain the function

Qustion no Define referential integrity constraint and explain with exanple.

Question no Explain the difference between an entity class and entity instance with example.

Question no

3.

a) What is attribute? And discuss different types of attributes.

1. Entity Integrity constraint and Referential constraint

11. Hierarchical database and network database

III. File Systems and Database system

IV.SQL-Groups By Clause and SQL- Order By Clause

Question no

(a) What is a DBMS? And also discuss its components?