After going through this course, the students will understand: What is meaning of Data? What is meant by Information? What are various differences between Data and Information? What is meaning of database? What are some common types of databases? How do relational databases organize data? For which type of data, NoSQL databases are suitable? How do object oriented databases store data? How do graph databases differ from traditional relational databases? What are time-series databases? What are NewSQL databases? Where do In-memory databases store data? What do you know about the working of database?

What is meant by Data? What is the meaning of information? What are the various differences between data and information? Which is used in decision making: Data or Information?

Whether database is an essential component of information management? What is meant by database? How can we add new data to database, modify existing information or retrieve specific pieces of data based on our needs? Do you agree with the statement that since the 1960s, there have been significant advancements in the design, functionality and use of databases?

What are some common database types? How do relational databases organize data? Which language is most commonly used to interact with relational database? For which type of data, NoSQL databases are suitable? How do object oriented databases store data? How do graph databases differ from traditional relational databases? What are time-series databases? What is meant by time series data? What are NewSQL databases? What is meant by scaling a database? What is vertical scaling? What is horizontal scaling? Where do In-memory databases store data? Whether a Company sticks to one type of database? What are the various factors which a company may consider while choosing a database?

How the users can access the database from anywhere? Does the database keep the separate copies of a particular data file? What role does a DBMS play in the relationship between a user and a centralized database?

Do you agree with the statement that there is a suitable database type for every situation?

After going through this course, the students will understand: What is meaning of DBMS? How does a Database Management System (DBMS) manage the concurrent access to data? DBMS provides controlled access to data. What is meant by controlled access? What are the various applications of DBMS? What are the various functions performed by DBMS? What is meant by data manipulation? Where does DBMS usually store data? How DBMS is helpful to Database Administrators? What do you mean by database servers? Whether a database server can host only one type of database? What are various types of database servers?

What is the full form of DBMS? What is meant by Database management system? What is the benefit of DBMS to users? How DBMS manages the concurrent access to data? DBMS provides controlled access to the data. What is meant by controlled access? What are the various uses of DBMS for business activities or what are the applications of DBMS?

What are the various functions performed by DBMS? What is meant by data manipulation? What are those storage devices where DBMS usually stores data? Which are the common performance optimization techniques used by DBMS? How DBMS enables data sharing and collaboration? How DBMS is helpful to Database Administrators?

What is meant by database server? What is the function of database servers? Database servers operate on a client-server model. Comment. A database server consists of hardware alone. Comment. What the key hardware components usually found in a database server? Why proper cooling system is required in database servers? When more powerful hardware is required in the case of database servers? What are some common software components of database servers?

What are the various types of database servers? What is meant by centralized database servers? What is meant by Distributed database servers? If e-commerce company is having distributed database servers for its organization, what should be done as the data and workload grows? What is the after effect if one of the servers of the distributed database servers goes out of order or becomes unavailable? What are the possible steps which may have to be taken to resolve the issue? What is the function of operational database servers used? What is meant by cloud based servers? How a customer or organization can avail the services of cloud based server? If an organization needs to improve scalability, which type of server will be its likely choice? Which type of server is likely to be used by an organization that needs to share data across multiple departments? Name some of the factors which an organization may consider when choosing a database server?

Why there are so many types of database servers?

After going through this course, the students will understand: What are the various advantages of DBMS? What is meant by Data Independence? What is the meaning of Data Redundancy? What is meant by Data Integrity? What is the meaning of Data Integration? What is Data Consistency? What are the primary techniques employed by Database Management Systems (DBMS) to enable concurrent data access? What is meant by the term locking in DBMS? What is the meaning of isolation levels? Why use of DBMS is now preferred over traditional file system? What are the various disadvantages of DBMS?

What are the various advantages of DBMS? What is meant by Data Independence? What is the meaning of Data Redundancy? What is meant by Data Integrity? What is the meaning of Data Integration? What is Data Consistency? What is the need of data backup? What are the various security measures used by DBMS to ensure data security? What is the meaning of scalability? What is meant by vertical scaling and horizontal scaling? What is meaning of scaling down?

Which are the key methods used by DBMS to achieve concurrent access to data? What is meant by locking? What is the meaning of Read Lock and Write Lock? What is the benefit of locks used by DBMS? What is the meaning of Isolation levels? Which are the four isolation levels defined in the SQL standard? Which is the lowest Isolation Level? What is Read Committed Isolation level? What is the function of Repeatable Read Isolation level? Which is the highest isolation level? Write one difference between Highest Isolation levels and Lower Isolation levels?

What are the various benefits of using a DBMS over traditonal file-based systems? DBMS or traditional file system provides for regular automated backups? DBMS supports point-in-time recovery. What is the meaning of point-in-time recovery? Which system is better for data analysis - DBMS or File system?

What are the various disadvantages of DBMS? Whether DBMS puts financial burden on the organization? DBMS represents a single point of failure for the entire system. What it means? Scaling a DBMS can be difficult. Why? What is meant by Vendor Lock-in? When we should not use DBMS system?

Why DBMS is essential for an organization?

After going through this course, the students will understand: What is the full form of ACID in Database Management System? What is meant by Atomicity? What is the meaning of Consistency? What is meant by Isolation? What is the meaning of Durability? Why ACID properties are essential in DBMS? What are the various components of DBMS? What is meant by the DBMS hardware? Which are the three kinds of people who interact with the DBMS? What is meant by Database Access Language? Who introduced Relational Database Model? On which idea, the Relational model is based? What are the key concepts or components of the Relational Model? What is meant by Primary Key, Foreign Key and Composite Key? Whether a primary key can allow null values? Whether a table can have multiple foreign keys? Whether a primary key from one table can be used as foreign key in more than one another table?

What is the full form of ACID? Which are the fundamental principles of a Database Management System? What is meant by Atomicity? What is the meaning of Consistency? What is meant by Isolation? What is the meaning of Durability? Why ACID properties are essential in DBMS?

What are the various components of DBMS? What is meant by the DBMS hardware? Which are the three kinds of people who interact with the DBMS? What is meant by Database Access Language?

Who introduced Relational Database Model? On which idea, the Relational model is based? What are the key concepts or components of the Relational Model? What are the various advantages of the relational model?

What is meant by Primary Key? What is the meaning of Foreign Key? What is Composite Key? What is the meaning of null values with reference to primary key? Whether a primary key can allow null values and if not, why? Whether a table can have multiple foreign keys? Whether a primary key from one table can be used as foreign key in more than one another table?

After going through this course, the students will understand: What are the current trends and future directions in Database Management System? What are the various differences between SQL and NoSQL databases? Why some Companies use a combination of both SQL and NoSQL databases to store and retrieve data? How is data integrity maintained in the relational model? What are various data models to store data?

What are the current trends and areas of interest in DBMS? What is meant by Open source DBMS? What is the meaning of Cloud-based DBMS? What are the various benefits of cloud-based DBMS? Why is the data security a top most priority for DBMS? What is meant by multi-cloud DBMS? What are the various benefits of Automated DBMS? What are the some trends that are shaping the future of DBMS? Why the organizations are shifting towards Cloud-based DBMS? What is meant by Blockchain technology?

What are various differences between SQL and NoSQL databases? Which Query language is used by NoSQL databases? What is the meaning of vertical scaling? What is meant by Horizontal scalability? Whether NoSQL databases follow ACID properties strictly?

How does the relational model handle data integrity and enforce constraints? How does relational model ensure entity integrity? How does relational model ensure referential integrity? What are some commonly used constraints used by the relational model to enforce data integrity rules? What does a Not-null constraint ensure? What is the function of Default constraint? What is the full form of “ACID” properties in DBMS?

What are the broad categories of data models? What are the main types of NoSQL data models?