Database System BS 4 Semester/Term PU — University of the Punjab

6:41c⋯

| 82

google.com/search

+

②

Facebook

PUNJAB UNIVERSITY DATA BASE MANAGEMENT SYSTEM

Question no s Write at least five advantages of database approach over conventional file based approach.

Question no sz 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 also

discus disadvantages of file processing system over database processing systems.

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

database schema and attribute domain.

Question no > Write a detailed note on different types of data dependencies, also give examples.

Question no :- Discuss in detail the reliability and security with respect to relation database system

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

Question no: Explain the functionality of DBMS as major components of data base environment

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

Question no 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 nee- List the major components of a database systems, and briefly explain the function of each.

Question no Define referential integrity constraint and explain with example.

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 altributes.

1. Entity Integrity constraint and Referential constraint

II. 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?

(b) Define primary key, Foreign key and also discuss briefly role of keys in database integrity

http:/informationtechnology.pk

www.facebook.com/it4all.pk

Any one have past papers

of bs cs 4th semester...

Visit ›

< Share

• Save