Unit-1- Database Management System - 8 Marks 1. What is Database and DBMS? List out the advantages and disadvantages of DBMS. 2. Explain the different models of DBMS with advantages and disadvantages. 3. Write differentiate between centralized and distributed database systems. 4. Who is DBA? What are the major responsibilities of DBA? 5. What is data integrity in DBMS? Explain its types. 6. What is normalization? Explain the normalization process with examples. 7. Define the following terms. a) Data Dictionary b) Primary Key c) Relationship d) DML e) SQL f) Data Integrity g) DDL h) Data Security i) Database System 8. What are the different types of SQL commands. Write with example. Unit-2- Data Communication and Networking - 9 Marks 1...
Program flowchart and system flowchart Programs are the collection of set of instruction which perform some certain activities. These interrelated programs are collectively called software or in general we call it information system. Information system is capable of processing raw data into information depending upon the users requirements. Thus, information system should process several types of data for several purpose or job which are done through programs. In short information system is a collection of programs. While developing a software, we design our software by using flowchart and other several designing tools. Flowchart is the diagrammatic or pictorial representation of steps involved while solving a problem. It illustrates the sequence of operations required to solve a problem. There are mainly two types of flowchart: Program flowchart and System flowchart. Program flowchart: It represents the steps involved in solving a particular problem. It illustrates the f...
Database 1. Differentiate the centralized and distributed database system. 2. What are the Purpose/Importance of Normalization? Describe with example of 1NF, 2NF, 3NF. 3. Explain ER Diagram in DBMS. 4. Describe the Normalization in DBMS. Advantages of it. 5. Explain the different types of data integrity in DBMS. 6. What is SQL? Describe the different types of Statements with example. 7. What is database model? Explain its types with advantages and disadvantages. 8. What is DBMS? Explain the advantages of DBMS. 9. Explain advantages of decentralized database. 10. What is Relational Database Management System? List advantages and disadvantages of ...
Comments
Post a Comment